BI Publisher Reports
Discussion List
-
Request Delivery Status Notification (Schedule Report Job)Summary: We have a client requirement where they would like to request Delivery Status notification to make sure that the Purchase Order document was successfully delive… -
Oracle BI Publisher - Data table for 'Invoice' area at Purchase Order's Order Life Cycle pageHello, I am attempting to create a custom SQL report (Oracle BIP) to include this field, Matched Amount, from this page. (Purchase Order's Order Life Cycle). Can you ple… -
Is there a query/sql that links a PO Change Order to the PO line it created?Summary: I am trying to create a data model that shows for each PO Change Order, the Requisition Number and the PO line it created. How can I do this? Content (please en…
-
Where is the Invoice Price Variance Report in Fusion?Summary: Hi gurus, I am unable to find the Invoice Price Variance Report in Fusion. This report used to be part of Purchasing in R12 : but we are unable to find it in Fu… -
Is there any standard Report relating to Purchase Order Change Order Revision DetailsSummary: Is there any standard Report relating to Purchase Order Change Order Revision Details Content (please ensure you mask any confidential information): Version (in…Kavitha Nanjundaiah-Oracle 4 views 1 comment 0 points Most recent by Shaik Nayab Rasul-Oracle Purchasing -
Change Order PDF Attachment shows the new "Note To Supplier" value, but post-approval View PDF idemSummary: Change Order PDF Attachment shows the new "Note To Supplier" value, but post-approval View PDF report and the data model they are stuck on the initial value Con…
-
Need Report to show Change Details of a BPA Change OrderSummary: Looking for a report to see what details were changed in a BPA or PO Change order. Please advise if there is any OTBI report or table to create BIP report. we c…
-
Note to Supplier” on PO PDF Based on Cost Center in Oracle FusionSummary: We want to automate the insertion of a “Note to Supplier” (delivery specs) on the PO PDF in Oracle Fusion Procurement. The note should: Be dynamically populated…
-
Write a report to fetch list of PO attachment under different categoriesSummary: SQL to fetch Content (please ensure you mask any confidential information): PO attachment under some categories (e.g. to buyer) are visible to supplier but not …
-
Disable/ edit the ContractTermsNoMerge layoutSummary: Content (please ensure you mask any confidential information): I understand from the documentation here: That, while printing Purchase Orders, when we attach th… -
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da… -
Attachments Missing in PO Document NotificationsSummary: After 24A upgrade, we are unable to see the attachments in the PO Notification emails and getting the below mentioned error message. " An error occurred while c…
-
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 254 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…