BI Publisher Reports
Discussion List
-
How to add P Card field in PO PDF templateSummary: How to add P Card field in PO PDF template Content (required): How to add P Card field in PO PDF template Version (include the version you are using, if applica… -
call and update subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
Need to relabel product for receiving import productsSummary: Sometimes when importing products they do not have the label information under our country's regulations, in this scenario, we need to relabel the product with …cgleonch 11 views 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management -
Need corresponding technical information on the R12 views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_VSummary: Looking for the replacement view or table information for the R12 supply chain planning views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_V. Content (required): Curr…Santhi 72 views 2 comments 0 points Most recent by Manojj Basetti-Oracle Reporting and Analytics for SCM
-
How to retrieve negotiation response pdf through BI Standard report in OIC?I understood that there is no data model for the Negotiation response PDF report, so customizing is not possible. from the link below PRC:PON: Need Sample XML for Negoti…
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 221 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Is there a table that holds - Reports usage metricsSummary: Is there a table that holds - Reports usage metrics Content (required): Is there a table that holds - Reports usage metrics, we want to understand which reports…Ramesh Devarakonda 31 views 4 comments 0 points Most recent by Ramesh Devarakonda Reporting and Analytics for SCM -
Why View PDF is showing all PO instead a single PO PDFSummary: Using Custom PO Template Content (required): When clicking 'View PDF' after searching for a PO#, instead of showing single PO output, it is downloading entire P…Mahmoud Elbestawy 51 views 6 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
How to view the PDF for previous versions of POs/AGTsSummary: How to view the PDF for previous versions of POs/AGTs Content (required): I create a PO/AGT initially and i can view PDF. Later when i create a change order and…
-
Reports to capture auto approved purchasing documentsSummary: We have the requirement to get the auto-approved purchasing documents using a custom report. Need assistance to get the right tables or query to get those PO, P… -
Need an SQL Query to find where (Approver) Negotiation Approval is Pending.Summary: Need an SQL Query to find where Negotiation Approval is Pending. For example, we have a negotiation that has 3 serial approvers. Approver 1 Approver 2 Approver … -
Is it possible to show the Cost center in PO PDF?Content (required): Client would like to see item, quantity per delivery location and cost centers reflected in PO-PDF, is it possible? If yes, how? If not, any work aro…
-
How to get negotiation response attachments and response pdf through API from Oracle fusion Saas?The requirement is that the on the basis of the DFF values entered by the user, the output should contain negotiation response attachments and response pdf for the parti…
-
User Defined Tables in SaaSSummary: Requirement for User-Defined Tables Content (required): A business requirement is to use a user-defined table in SaaS to be populated with data related to PR/PO…MohammedNasr 41 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 1.1K views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM
-
Requisitioning BU have null value for header and header linesI made the following query to give me the open agreements and their lines, in the table, some lines had a Requisitioning BU value but the majority does not. In this quer…
-
Get requisitioning BU of item with sql querySummary: While selecting the contents of the po_lines_all table, I'm getting the requisitioning BU id, but I need to get the Requisitioning BU name or code, In which tab…Youssef_Antoury 1.2K views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
How to change returned tag value on Negotiation PDF rtf using Publisher?Summary: I am trying to edit the value being returned from a tag on the seeded Supplier Negotiation PDF. I am using Oracle Analytics Publisher add-in in Word. Content (r…
-
History of Requisition/ Negotiation view or download of attachment?Summary: Is there a way to get a history of a Requisition or Negotiation of the users who viewed the transaction or who downloaded a attachment of the requisition or neg…
-
Query to get blanket purchase agreements and all their detailsSummary: I can't find a query to get the Blanket Purchase Agreements for oracle cloud fusion report. Content (required): I need to get the Blanket Purchase Agreements in…
-
Need Table or Subject area with "Assessable Value"Summary: We need to retrieve the information that is on column "Assessable Value" on the PO Lines. Content (required): Cannot find "Assessable Value" on any OTBI Subject…
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Are there downloadable dashboards for Supply Chain Management modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…
-
Remove Contract Terms in the Supplier Negotiation PDF ReportSummary: Remove the Contract Terms in the Supplier Negotiation PDF Report Is there a way to remove the Contract Terms template from the Supplier version of the Negotiati…
-
Inventory Onhand As of DateDo we have standard Report to check as of Balances lets say if customer wants to see onhand balances for 31-Jan-2022 on 11-Feb-2022 how to check through Standard Report
-
Manage Item Quantities - Page Composer - bindings.Segment1.attributeValue value not being passedSummary: Hi , I have a hyperlink added on 'Manage Item Quantities' screen in Inventory management. This hyperlink launches a BIP report which has Item number and organiz…Sravanthi Kollapudu-Oracle 31 views 2 comments 0 points Most recent by Sravanthi Kollapudu-Oracle Inventory Management
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Bursting report in errorSummary: The log shows the following error: BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition…Giuseppe Galluzzo 323 views 12 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM