BI Publisher Reports
Discussion List
-
Export Approval DetailSummary: Hi We are currently setup po approval in setup and maintenance. We are not using BPM. But in another product segment, we use BPM, such as project budget approva… -
How to get more details of this package PO_BIP_HELPER.get_requester_name?How to get more details of this package PO_BIP_HELPER.get_requester_name? -
Need a SQL query to fetch Miscellaneous transactions in Oracle Fusion CloudSummary: Need a SQL query to fetch Miscellaneous transactions in Oracle Fusion Cloud. I'm building a report to capture the Account Alias Issue type of transactions. Cont… -
What is template name of email body and subject of awarded negotiation that send to supplier?Actually our client want to customized the email body and subject name for Negotiation Invitation and Negotiation Awarded email that send to Supllier. We are to able fin…Chandan Kr 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Once PO has been generated via Oracle ERP Cloud email is triggeredSummary: Once PO has been generated via Oracle ERP Cloud Email is triggering with attachment, there is no bursting in data model. Not sure how email is getting triggered… -
Is There a Quicker Way to Retrieve Payables Close ReportsSummary: We have a large handful of closing reports for accounts payable that we run every financial month end, and it is causing a significant amount of time to go into…Nikki K 11 views 3 comments 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM -
Is there any seeded report available to list the supplier login history?Client would like to know the adoption rate of the supplier portal. Is there any seeded report that can extract the supplier login history for a specific period of time? -
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …SukumarKondaveti 73 views 7 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.4K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Transitioning Oracle BIP Reports from Packages to Standard TablesSummary: Can we convert Oracle BIP reports to use only Oracle standard tables instead of Oracle standard packages? We should not call standard packages in the report. We… -
Custom Delivery Note Reports to be printed automaticallyWe have developed a customer delivery note report. we want that to be printed to the specific users printer as soon as the shipment is confirmed in oracle fusion. The pr… -
sql query to show approval and reject history for purchase requisitionsSummary: I'm looking for sample sql queries to display history of PR approval, reject and the next persons who need to approve, just like View Document History. Content … -
how is INV_CONS_ADVICE_REVISIONS table populated?Hi Team, For a consumption advice, I am seeing 2 revisions- 1 & 2 present in front-end while database table INV_CONS_ADVICE_REVISIONS is just fetching revision 1. Would … -
Copy of 'Print Movement Request Pick Slip Report' does not show parameters screenSummary: I have created a copy of 'Print Movement Request Pick Slip Report' process in order to make required the parameters 'From Movement Request' and 'To Movement Req… -
Key colimn for joining INV_RESERVATIONS and DOO_HEADERS_ALLI would like to get data of Manage Reservations and Picks. More specifically, I need order number, quantity, customer, and shipping status from demand tab. According to … -
Edit Purchase order page to implement one custom PO template on "VIEW PDF" buttonSummary: When user opens the Purchase order page , after clicking on "View PDF" , custom report should be called and report should be generated for corresponding PO .We … -
How to fetch Ship-From Site in receiving Transaction UI pageSummary: In receiving UI pages of Fusion Procurement Cloud, we have observed some Ship-from Site in Transactions uses the Vendor_site_code in the UI pages, while others … -
Table for Source Reference field on Completed Transaction page - SCM CloudSummary: Hello, We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field. Content (plea… -
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult… -
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How can a buyer compare rounds of negotiation documents (RFQ) in Oracle Fusion?Hi, Is there any standard report or options available in the sourcing, which can provide detail comparison between the rounds of the negotiation document "RFQ" How buyer… -
Unable to view the User Defined InfoletsHi, During the Oracle demo demonstration session, User Defined Infolets was shown to us, however, we are unable to navigate to the same in our Test/Live instance. User D… -
Value Set to be created based on Geography StructureSummary: Hi Team, We have a requirement to create Country , State and City as EFF on Assignment page which will fetch the values from Geographies. We were able to create… -
How to query Receiving Quantity & Inbound quantityHi Experts, I am developing a report to show Item On hand quantities along with the Lot and corresponding Sales Order details. I am also trying to show the Receiving Qua… -
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 11 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Invoice header and line level report from OBN?Summary: Hi All, We would like to fetch a report from OBN to get invoice header (and specially) line level details such as line type and line amount. Does OBN has any su…Rajat_Gupta 11 views 1 comment 0 points Most recent by Miranda Beuc-Oracle Payables, Payments & Cash Management