BI Publisher Reports
Discussion List
-
Need table joins between Inventory On hand table and Review completed TransactionsSummary: Hi Team, We have a business requirement to build a report with below columns : Item Item Description Item Category On hand Original Review completed date Wareho… -
Need to know the exact submission date for a Qualification area response from SupplierSummary: We are facing an issue - wherein if the Supplier responds to the same question in multiple different Qualifications, the latest answer is getting populated in a…
-
Procurement Dashboard not showing amounts in ledger currency USDHi, We are using the standard procurement dashboards "Procure to Pay." Our ledger functional currency is USD; however, we have observed that the values displayed in the … -
Some Character in "Madani Arabic" Font visible not correct in the view PDF report.Summary: Some Character in "Madani Arabic" Font visible not correct in the view PDF report. the font installed correctly and RTF file also correct. but while view PDF fr…
-
To print a PO Report after clicking on SaveClient Requirement: after creating a PO and clicking on save, the client wants to auto-print a custom report we have developed for him. is this functionality standard in… -
How to customize confirm receipt notification in fusionSummary: How to customize confirm receipt notification in fusion Content (please ensure you mask any confidential information): Is it possible to customize receipt notif…
-
How to translate data to a local language using BIP Template in FusionSummary: Hi oracle experts, We are trying to customize our PO Print Template by translating it to a local language (like Japanese), but we are only able to translate the…
-
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMPSummary: we have one custom report keeps failing with error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP in saas application. could you plea…Veeragopathi 708 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Can we customize the purchase order implemented notification reportSummary: We try to customize the Data Model trying to add the field ex-factory date into the Data Model. When we try to use the field ex-factory date in our rtf template…
-
Essential field extraction from fusion using API for po creation with ValidationSummary: We have a requirement to create POs in bulk, user only provide us fields such as Procurement BU,Requisitioning BU,Doument Style Name,Supplier Number Supplier Si…
-
REST API to get PO Details from Oracle FusionWe have a requirement to automatically close purchase orders and blanket purchase agreements using REST API and FBDI approach. Currently we are using Fusion tables to ge…
-
Is there a report that will help business with get list of PO number, and corresponding detailsSummary: Do we have any Oracle fusion report that will help business user to get list of PO number, and corresponding requisition number, requisition line number, requis…
-
What would be SQL query to get PO to Receipts with invoices detailsHi …!!! I'm trying to create a BIP report with the details of Purchase Order details and matched Receipts details including receipt amount with Invoice Details. I'm unab…
-
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?
-
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 18 views 3 comments 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
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 …
-
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 …
-
Receipt Number field blank on OTBI report from Procure to Pay Subject AreaSummary Receipt Number field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, we built a OTBI report based on "Procure to Pay" subject area, receipt …User_2025-02-03-22-11-49-695 80 views 10 comments 0 points Most recent by Boopathy CS-Oracle Purchasing -
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…
-
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 15 views 1 comment 0 points Most recent by Miranda Beuc-Oracle Payables, Payments & Cash Management
-
Default Type Lookup for Item Transaction defaultsSummary: In the Item Transaction Defaults page, May i know the Lookup where Default Type values are stored Content (please ensure you mask any confidential information):…Sudheer YN 207 views 6 comments 0 points Most recent by Jason Maen - BHE MidAmerican Energy Company Inventory Management
-
Communicating PO PDF to SFTP location Using BIP BurstingSummary: Can we use Bursting in PO PDF to send the PDF to some SFTP location the moment PDF gets generated? If yes, can someone help me with the Bursting Query. I have t…
-
To Retrieve the PDF attached From UCM Server in BIP BurstingSummary: Hi Team, Kindly let me know, how to Retrieve the PDF attached From UCM Server and sent the same to employees using BIP Bursting Query. Content (please ensure yo…
-
Want to know tables that store PO and Agreement Change Order history detailsSummary: Want to know tables that store PO and Agreement Change Order history details. Content (please ensure you mask any confidential information): I am working on rep…
-
How to change PO e-mailSummary: We are trying to change the body of PO e-mail. Instead of the word "Implemented" the customer wants the word to be "Created" Content (please ensure you mask any…
-
Logic to separate in transit shipment on a purchase order from BIP reportSummary: Business requirement is to finally close a purchase order but system is not allowing due to in transit shipment. In report we have already added the logic for n…