BI Publisher Reports
Discussion List
-
Local Time Conversion for PO PDF ReportWe have a requirement in our project to develop a custom PO PDF report. A header-level DFF is used to capture the appointment date and time, which is updated by a third-… -
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 465 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 11 views 3 comments 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Not able to see PO Header DFF on BI Subject Area "Procurement - Purchasing Real Time"Summary: I have created a DFF at PO Header level and enable BI checkbox: Then I have run the folllowing scheduled Process: Import Oracle Fusion Data Extensions for Trans… -
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 70 views 10 comments 0 points Most recent by Boopathy CS-Oracle Purchasing -
Table names for the DFF , KFF, EFF in fusion.Summary what are the tables for DFF,KFF,EFF in fusion.Content Hi All, Can anybody knows the back end tables for the DFF, KFF, EFF in fusion. Thanks, Sameer A.
-
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 11 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 177 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…
-
Print PO PDF in multiple languageHi team, We have requirement where for Germany we have to print PO PDF in german and english language both. In German language for local suppliers and in english for for…
-
Need DocuSigned PO PDF storage details in Oracle Fusion for automation to external systemSummary: We are implementing DocuSign Signature functionality for our client, who requires all signed PO PDFs to be automatically stored in a separate system. To enable …
-
PO PDF not displaying lines intermittently.PO PDF not displaying lines intermittently, it stops displaying lines for the first go and is available when PO is re-queried. We have custom PO PDF template. -
PO E-mail Subject & Body Template changes not reflecting when the PO Print PDF is generatedSummary: I have made changes to the RTF template for Purchase Order E-mail Subject and Purchase Order E-mail Body template and uploaded it on to the application. But whe…