BI Publisher Reports
Discussion List
-
UCM access permission error while running Procurement BIP report?Summary: In Custom BI Report, we are using Standard FA_UCM_PROVISIONED to read document from this Content server but normal business are not able to run this report they… -
Suppress PO PDF attachment on PO email to suppliersSummary: I'm currently working with a customer who does not want to send the PO PDF attachment to the PO email that is communicated to their suppliers. Is there a way to…
-
The Purchase Order Implemented FYI Notifications Using Oracle BIP stopped working after 25CSummary: We’ve enabled the “Configure Purchase Order Implemented and Rejected FYI Notifications Using Oracle Analytics Publisher” feature to allow customization of notif…
-
Is there a tool or query that can scan and verify where the field is used?Summary: According to DOC ID 2749921.1, we're encountering an error when adding externally sourced requisitions to Sourcing-sourced purchase orders. The proposed solutio…
-
Purchase Order Email Notification not working as expectedSummary: Posting the question based on feedback from SR - 4-0000665238 While trying to customize the Purchase Order Email Notification report, we added a new custom layo…
-
Query to See the Approver Name on Whom a PO is Pending For ApprovalSummary Query to See the Approver Name on Whom a PO is Pending For ApprovalContent Most of the time we get an SR with requirement to see or extract on which approval lev…
-
Best way to generate a report of all users with a specific role with their user name and email?I'm wanting to generate a report of all users able to raise a PO + their user name/emails. Have figured a good way to do this would be to generate a report of all users …
-
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…
-
OTBI - invoice life cycle detailsSummary: Is it possible to add the Order Life Cycle details to an OTBI analysis? Content (please ensure you mask any confidential information): We have created OTBI anal… -
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 5 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…