BI Publisher Reports
Discussion List
-
Does anyone have a sql to pull historic PO approvals/workflows?We have an audit request to provide the approval workflow for a change order last year. Since workflows are purged 30 days after completion, I cannot view this in ERP di… -
Why Standard fonts are not reflecting in the BI Reports?Summary: I have used "Times New Roman" font in my RTF Template, but it is not taking that font in BI output report instead of that some other font is present. This issue…Pravallika Mamidipaka 41 views 3 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle Purchasing -
Deeplinks - How to use the return variable ?Summary: Deeplinks - How to use the return variable ? Content (required): Hello, I use this deeplink : ../fscmUI/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHe…
-
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…
-
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… -
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…
-
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
-
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.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 81 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 279 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) …