BI Publisher Reports
Discussion List
-
How to show physical attribute data of Item at process requisition levelSummary: The business requires item weight details, entered under Physical Attributes in the item specification, to be visible on the Process Requisition page during PO … -
Disable contract terms and conditions on POPDF layout?Hello We are passing Contract Terms and Conditions on PO header (Controls Tab). These Terms and Conditions are printing at the end of the PO PDF in a new page which are …
-
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.
-
Requirement to Display Conditional Message in Requisition Approval Notification OnlyHi All, We have a requirement where the following message needs to be displayed only in the Requisition Approval notification, based on a DFF condition: "Test business m…
-
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… -
Automatically populate associated CPA terms and conditions on the Purchase Order PDFSummary: We want to force the Purchase Order PDF output to have the T&Cs from the associated CPA Source Agreement. Can this be achieved without linking the PO PDF direct…
-
We are trying to Update the PJC_PROJECTS_CCW_V value set to restrict the project number'sSummary: We are trying to Update the PJC_PROJECTS_CCW_V value set to restrict the project numbers at purchase order lines based on the sold to legal entity selected at p…
-
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…
-
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-… -
Purchase Order Rejected Notification Report Opening in ADF Template and Not RedwoodHi All, The report "Purchase Order Rejected Notification Report", I clicked "Customize" from XMLPServer. The report output before clicking "Customize" : Displayed Redwoo…
-
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… -
PO Delivery failure notification for supplier to be notified to businessSummary: PO Delivery failure notification for supplier to be notified to business is there any way the buyer get notification when the supplier does not receive notifica…
-
One time address is not showing in the PO PDFSummary: how to show one time address in the PO pdf print copy Content (please ensure you mask any confidential information): One time address is not showing in the PO P… -
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…
-
Purchase order approval email notification includes taxs amount in headers amountSummary Purchase order approval email notification includes taxs amount in headers amountContent Purchase Order approval email notification has header order amount with … -
How to Customize the Supplier Audit Report ?Summary: How to Customize the Supplier Audit Report ? Content (please ensure you mask any confidential information): Hello I did one Supplier Bank Account Change and aft…
-
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…
-
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 …
-
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 : https://docs.oracle.com/cd/A60725_… -
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…
-
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 …
-
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: https://docs.oracle.com/en/cloud/saas/sales/fasca/contract-printing-and-layout-templates.html#Printing-of-Contract-Terms-on-Purchase-Orders-and-So…