BI Publisher Reports
Discussion List
-
Accrual Month End Report Query based on CMR_PO_ACCRUAL_AMTS tableSummary: Hi All, Business Background: Our business requires an automated PO Receipt Accrual Period End Process to support end-of-month activities related to purchasing. … -
How to get data access for a specific user through the REST APISummary: Through the REST API, we need to obtain from a given user which BUs are granted and what roles are assigned. We need to retrieve these details depending on the …
-
ContractTermsProcurement - Disable No-Merge TemplateProcurement Contracts: While printing Purchase Orders, when there is a custom attached contract terms to the PO, since the layout is not structured it will print using t…
-
ONE TIME LOCATION is not populated in attribute1 for POR_ONE_TIME_LOCATIONS TableWe came to know that one time location address is earlier stored in attribute1 of POR_ONE_TIME_LOCATIONS Table. Our PO PDF report uses this column to populate one time a…
-
Purchase Order Report through View PDF ButtonCreate a custom report for PO including PO status, when run it through View PDF button after it is approved the po not updated untill a change order is created and appro…
-
where can i get the list of standard reports available in Oracle Fusion procurement ?Hi where can i get the list of standard reports available in Oracle Fusion procurement ?
-
Query to get Purchase Order with an Approved AP InvoiceSummary: I need to write an SQL query to get Purchase Orders with Approved AP Invoice, Could anyone please help me with this? Content (please ensure you mask any confide…
-
We need a report to identify all the users who have delegation set up for HCM/Procurement Approvals.Summary: We need a report to identify all the users who have delegation set up for HCM/Procurement Approvals even if that user don't have a approval notification transac…
-
Table to retrieve attachment of purchase ordersSummary: I need to retrieve attachment of purchase order in BI Publisher report. I am not able to get the URL of attachments in fnd_attached_documents. Is this feasible …
-
BIP Report scheduled JOB not visible to usersSummary: BIP Report scheduled JOB not visible to users other the user who schedule it " BI Administrator Role" is also assign to the users Content (please ensure you mas… -
Released Amount and Release Quantity not showing in Agreement PDF ReportSummary: We have customized the Seeded Oracle Purchase Agreement report and added the 2 columns at line level "Released Amount" and "Released Quantity". Data not showing… -
Email Notification Sent out to Supplier for Purchase OrdersSummary How to Modify Email Notification Sent out to Supplier for Purchase OrdersContent Hi All, Can we add conditions to email body of po pdf notification sent out to p…User_2025-02-03-22-11-49-695 260 views 13 comments 0 points Most recent by Srinivas Reddy Purchasing -
Changes to PO not reflecting in PO PDF DocumentSummary: Hi, I have a PO that was approved. We then submitted a change order to change the deliver to location. This has also been approved. However the PO PDF document …
-
Is there any Blanket Purchase Agreement Notification Report available in Oracle.Summary: We have a requirement to customise a purchase agreement approval notification, I'm unable to find the approval notification report to customize in the Notificat…
-
How-to: Display Text Attachments in PO PDFContent Customers who attach many large text attachments to their purchase orders may find that the text attachment content does not appear in the purchase order PDF. To…
-
Purchase Orders are not using the latest BIP PDF templateSummary: Purchase Orders are not using the latest BIP PDF template Content (required): We have updated our PO RTF template and for some reason the changes are not being …
-
Unable to view Purchase order PDF in UI on purchase orders over £9,999,999.00We have a high value purchase order of more than £10mill in our system but when trying to view the Purchase order PDF from the UI it will not load. I have tested values …
-
Requisition Email Approval templateI am currently working on updating the custom requisition email approval template. As part of the testing process, I have enabled the BIP_CLIENT_REFRESH_TME profile opti…
-
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T… -
What is the character limitation to show Oracle Purchasing Text attachment on PO PDF DocumentSummary: We would like to know what is the character limitation to show the text attachment on the PO PDF Document. Content (please ensure you mask any confidential info…
-
Are there available standard reports showing the return transactions?Summary: Hi Community, Would like to check if there are Oracle standard report available showing the return to vendor transactions? Thank you. Content (please ensure you… -
Deep Link for AP Invoice within BI ReportSummary: We are wanting to build a BI report (SQL based) from where we can navigate to AP Invoice page in (Manage Invoice) page or (Edit Invoice) page. We are finding in…
-
Query to get Requisition and Standard PO details for the respective BPASummary: Query to get Requisition and Standard PO details for the respective BPA Content (please ensure you mask any confidential information): We are developing report.… -
Query to find the approved purchase requisition based on specific rulesSummary: Hi Team, We are looking for a purchase requisition information where the specific rules are triggered as part of the approval workflow Content (please ensure yo…
-
Open Oracle Cloud Application PDFs in the browser to avoid local downloading.Summary: Open Oracle Cloud Application PDFs in the browser to avoid local downloading. Content (required): Hi, So in a normal scenario when we will click on any of the P…
-
AnyTable to get po status list which is used to store in document_status in po_headers_allSummary: Hi All, We have one requirement to pass the PO status as a parameter in PO details BIP Report. To create the SQL query for LOV we need distinct value of Po stat…
-
PO PDF cannot be viewed online and attached from Email for requesterHi Everyone, We have created custom data model for PO PDF. We checked that the error caused for the PO PDF cannot sent to our requester after PO created. Is there any ad…
-
Can we replace PO PDF document with Other PDF DocumentsWe have a requirement to replace PO PDF document with other PDF Documents once POs are created. Is there any way we can replace PO PDF document. I know we can customize …
-
Budget Carryforward and Budget Transfer Movement DetailsDear Oracle Cloud Community, We are currently working on a requirement to fetch Budget Carryforward and Budget Transfer Movement details after executing the PO Carry For…
-
How to fetch the below utility package source code from oracle fusion instance.Summary: We are working on the PO PDF report, to fetch requester phone number details. As per our analysis the requester phone number is begin fetched by utility package…