BI Publisher Reports
Discussion List
-
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_… -
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 693 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM -
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i…
-
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 12 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…
-
Print Receipt traveler report is not triggeringSummary: when we are creating expense destination receipts the Print Receipt traveler report is not triggering. For inventory destination receipts was triggering automat…
-
About linking transfer order details and shipment detailsSummary: I want to link transfer order details and shipping details. What is the join key for "WSH_DELIVERY_DETAILS" and "INV_TRANSFER_ORDER_LINES"? Content (required): …
-
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 …
-
query for inbound quantitySummary: From which table we can fetch inbound and receiving quantity coming up in inventory management->manage item quantities
-
What is api to award supplier manuallySummary: What is api to award supplier manually after receiving the response Content (please ensure you mask any confidential information): Created RFQ. Received respons… -
Request to Replicate Oracle GET_POSTING_STATUS() FunctionalitySummary: We need to replicate the functionality of the Oracle standard function GET_POSTING_STATUS(). Requirements: Explain what GET_POSTING_STATUS() does in Oracle, inc…Guthi Mallikarjun 1 view 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
Award Notice PDF report as an email attachment to this same notificationSummary: We have a requirement in Fusion to enhance the award approval notification process. Currently, when an award approval notification is triggered, an email is sen…
-
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. …
-
New Supplier Negotiation PDF Template is not availableHi, I have enabled the feature "Configure Supplier Negotiation PDF with Oracle Analytics Publisher" on a new instance but the new negotiation pdf template is not availab…
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
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 …
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 112 views 3 comments 0 points Most recent by User_2F7TP Reporting and Analytics for SCM
-
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…
-
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…
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 53 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
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 …
-
how to customize buyers negotiation PDF?Summary customize contracts section of Buyers negotiation PDFContent Hi, i am new to Fusion customizations and would like to customize Buyers negotiation PDF. I have dow…