BI Publisher Reports
Discussion List
-
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.1K views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
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…
-
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…
-
Deep Links for PO and PR in BIP ReportSummary: Hi Team, We have created BIP report with deep links for PO and PR. I have created one custom role to for PO / PR View only access. The user can see PR in UI how…
-
OTBI Reports for BPA or CPA ?Summary: Role requiered to create either a BPA or CPA ? Content (required): Hello I would like to setup either a BPA or CPA , I think the process is 1.-Create a BPA or C…
-
Custom Hold resolution notificationSummary: How can I export the data model to upload it as a sample xml to modify rtf template? What parameters do I need to enter in BI to view a report? When I enter the…Alexandra Bykhan 85 views 8 comments 0 points Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management -
Looking for Entity Relationship Diagrams (ERD) for Procurement modulesSummary: Looking for Entity Relationship Diagrams (ERD) for Procurement models Content (required): Hi, At times we need to use Database tables to find the information we…
-
Report to show what has been changed on a Change Order and on a RevisionContent Hello, is there any way to get what has been changed on a Purchase Order when there is a Change Order or there is a Revision? Many thanks, Mario -
Make Requisition Number as a Hyperlink in PO approval notification?Summary: Make Requisition Number as a Hyperlink in PO approval notification? Our client requires to make the Requisition Number as a Hyperlink in the PO Approval Notific…
-
Need the concept/logic behind why Retroactive pricing is viable only with Non-Cumulative Price BreakSummary We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.Content Hi all, Based on my research, Fo…Harshith Eshwar Shaila-145631 281 views 6 comments 0 points Most recent by Alexander Joseph Purchasing -
Does anyone have a report for the po-headers_draft_table that includes the process code status?Summary: Following error message when importing orders 'The Order Number must be unique for this sold-to legal entity, supplier and supplier site'. Content (required): W…
-
How to handle Daylight savings time change on custom BIP reportsSummary: Hi, we have few BIP reports where we are displaying time stamp on report output and this is a problem when we have the Daylight savings On. We can modify the co…
-
how to add CUPS server and fax4CUPS extension for fax service in Oracle cloudSummary: Client want to add fax server in Oracle cloud. Content (required): Hi team, In Oracle Cloud documentation we found the below- https://docs.oracle.com/en/cloud/p…
-
Custom Data Model to create ReportSummary Use a Custom Data Model to create the PO DocumentsContent Hello, We need to use a Custom Data Model to be able to create our Purchase Order PDF Documents with al…
-
What is the configuration setup to default the Retroactive Pricing check box in Blanket Purchase AgrSummary We have client request to configure the retroactive pricing to default as unchecked.Content Hi all, Based on my research, Implementation Guide points us to the f…Harshith Eshwar Shaila-145631 383 views 12 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Purchasing
-
What is the Navigation for an Inventory usage report in Reports and AnalyticsSummary: What is the Navigation for an Inventory usage report in Reports and Analytics? Found a Distribution details by Account report and a Distribution summary by peri…
-
Can user view reports on approval routing based on purchase categories?Summary: Users want to see reports on approval routing based on purchase categories. Content (required): Version (include the version you are using, if applicable): Code…
-
How to generate purchasing activity report in oracle fusion?Summary: Content (required): Purchasing activity report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) …
-
How to send the XML of Purchase Order automatically to supplier.Summary:Is there a way or is there any feature that allows sending the XML of a Purchase Order automatically to supplier once the purchase order is approved, just like t…
-
Ability to show the attachment text (Content) in the purchase order PDF reportSummary: When we create a purchase order, we have line level attachments and also header level attachments. The content of the the attachments marked as text or other fi…
-
Where can I find the infolets on the purchase order pageSummary Where can I find the infolets on the purchase order pageContent Where can I find the infolets on the purchase order page, I would like to copy the infotes to cre…Leandro Vasconcelos 107 views 8 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
PO FYI Approval notifications not printing any linesContent Hi all, We came across a very odd situation for which I already logged an SR as well. Our PO Approval flow is the following: * Start * FYI notification to an App… -
how to get Good receipt note details with procurement details on OTBI reportSummary: Content (required): Hello everyone, We have a OTBI report in the production instance related to PR details. The subject area, " Procurement - procure to pay rea…
-
XSL Mapping rom PO data modelHello Everyone, We need to transmit the PO through cxml. However, our suppliers are asking for company name instead of bill to and ship to name. We have modified the dat…Yogesh M 22 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice).Summary Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice)Content Hello Gurus, Is there seeded report or any OTBI Subject Area's to join…User_2025-02-03-21-08-45-135 185 views 5 comments 1 point Most recent by Ivan Pena-Oracle Purchasing
-
Table name for data stored in "Manage Catalog Category Hierarchy"Summary: Need table name for data stored in "Manage Catalog Category Hierarchy" Content (required): Version (include the version you are using, if applicable): Code Snip… -
What table(s) store the buyer assignment rules?Summary: Content (required): I am looking for the table so I can use it in a report query Version (include the version you are using, if applicable): Code Snippet (add a…
-
Custom Purchase Order PDF not attached in Email notificationSummary Custom Purchase Order PDF not attached in Email notificationContent Hi, We have developed a custom PO PDF, NOT Customised but a custom one.The Custom report is a…