BI Publisher Reports
Discussion List
-
Custom Delivery Note Reports to be printed automaticallyWe have developed a customer delivery note report. we want that to be printed to the specific users printer as soon as the shipment is confirmed in oracle fusion. The pr… -
Confirm ReceiptsSummary: Is there a report that list all the confirm receipts notification sent to requestor and buyer? If yes, please advise how to generate or extract. Can the notific…
-
Query to fetch all the receivables credit memo along with origi9nal transaction detailsSummary: Need to develop one report to extract data for prior period of Oct-24. For all the receivables credit memo along with original transaction details for only nomi…
-
Can we add custom parameters to the seeded ESS job Communicate Purchasing Documents?Summary: I'm reaching out to see if anyone has experience customizing the ESS job 'Communicate Purchasing Documents', which is responsible for distributing the PO PDF to…
-
Blanket purchase agreement approval notification is not opening in REDWOOD Style and formatSummary: Hi Team - We we create BPA and submit for approval , login with approver access, notification received under bell icon , but when we click on Hyperlink, old cla…Abhishek Tiwari-Oracle 24 views 2 comments 0 points Most recent by Abhishek Tiwari-Oracle Purchasing
-
Need to fetch Contract ownerSummary: Hi Team I need to fetch owner of contract using sql but i am not getting table and link . Can you please help Content (please ensure you mask any confidential i…
-
Is it possible to save signature and fetch on the report in oracle fusion?Hi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin We have the client requirement to fetch si…
-
Clarification on Future Support for External Data Sources in BI Publisher for SaaS to OICIntegrationDear Oracle Community, We have a requirement to utilize the external data source configuration feature in Oracle Fusion Applications BI Publisher to establish connectivi…ReddyBashaShaik 31 views 0 comments 0 points Started by ReddyBashaShaik Reporting and Analytics for SCM
-
Oracle standard report to check the po is received but is not deliveredSummary: Oracle standard report to check the po is received but is not delivered Content (please ensure you mask any confidential information): Oracle standard report to… -
Hello, How can I modify the Supplier Negotiation PDF in Oracle Fusion Sourcing?Hello every one, How can I modify the Supplier Negotiation PDF in Oracle Fusion Sourcing? I’m trying to find the BI Publisher report/template path so I can download and … -
How to customise Print Min Max Planning ReportHi, We have a requirement to add/modify columns in the seeded Print min max planning report. Since it fetches data from a temporary table, is it possible to customise? W…Ankana Bhattacharya 43 views 0 comments 0 points Most recent by Ankana Bhattacharya Reporting and Analytics for SCM
-
Can anyone please let me know the join between the fnd_attached_documents and POR_REQUISITION_HEADERSummary: Hello, The requirement is to get the supplier negotiation notification attachment through UCM.As per the oracle document,fnd_attached_documents and POR_REQUISIT…
-
Default Type Lookup for Item Transaction defaultsSummary: In the Item Transaction Defaults page, May i know the Lookup where Default Type values are stored Content (please ensure you mask any confidential information):…
-
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin… -
Custom PDF template not working on View PDF button in 25DSummary: We had a custom RTF report for PO PDF and it was working fine.. Now after 25D when we click on View PDF button in PO screen , report is being generated in stand…
-
How I can extract the list of subinventories and the respective Inventory OrgSummary: Extract the list of subinventories and the respective Inventory Org Content (please ensure you mask any confidential information): We need a query or a way to e…Mamdouh Ahmed 21 views 5 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
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…
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 51 views 6 comments 0 points Most recent by Abdullah Samy-Oracle Reporting and Analytics for SCM
-
If anybody worked on ZPL format for label printing can you please share the ZPL formats and outputsSummary: We need to implement zpl format to print the labels using zebra printer. So need any samples of ZPL formats which are already implemented Content (please ensure…
-
Select BIP Query to Fetch the Requisition DetailsSummary: PL/SQL Select Query to Fetch the Requisition Details in Oracle Self Service Procurement Content (please ensure you mask any confidential information): We have a…Mamdouh Ahmed 12 views 3 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 183 views 2 comments 0 points Most recent by Dineshkumar.A-Oracle Reporting and Analytics for SCM
-
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 …SamerSaber 445 views 8 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
Can we create a separate queue for some priority processes within the ESSSummary: We have few priority requests which needs to run in the system as these are dedicated for patient care , is there a way we can create a new ESS manager to run t…Praveen3015-Oracle 2 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
How to Query Available to Reserve Quantity to show in Custom Report or Any calculation (Formula)How to Query Available to Reserve Quantity to show in Custom Report or Any calculation (Formula)
-
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 524 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.4K views 9 comments 4 points Most recent by PranjulG Reporting and Analytics for SCM -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Buyer planner group summaries query forSummary: In Buyer Planning we have plan information along with Group Summaries. Can someone help us to provide the sql query or tables where group name for that supplier…balla Bhaskar 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle Supplier 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…
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…Sarath Lakshman 12 views 7 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM