BI Publisher Reports
Discussion List
-
Can someone please provide underlying sql query for Available To ReserveSummary: Looking for underlying sql query to get "Available to Reserve" and "Available to Transact" qtys on onhand UI. I tried with joining multiple tables and condition… -
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Graeme Gerber Inventory Management
-
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…
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 51 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM
-
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 12 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to remove the footer with auto-populated page numbers from the 'Supplier Negotiation PDF Report'Hello, I am looking for a method to remove the auto-generated page number from negotiation PDFs. I noticed that a post was created a little over a year ago on the same t…
-
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… -
How to correct the Error Manual Recovery in Print Inventory Labels ESS JobSummary: We are generating the barcode labels for the Locators in our new Warehouse. However, when we run the Print Inventory Label, the Error Manual Recovery appeared i…
-
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…
-
How to create a query/ extract data by joining WSH : interface errors and Delivery InterfaceHow to create a query/ extract data by joining WSH : interface errors and Delivery Interface
-
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…shaikh123 91 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsNeed SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsDhilip Kumar P. 2 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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…
-
How can we configure the date picker parameter in an ESS job to show JST instead of the default UTC?Summary: We have an ESS job where the 'Territory' is set to Japan, and the 'Time Zone' is set to (UTC+09:00) Tokyo – Japan Time (JT) in the Process Options. However, in …
-
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…
-
How to print "order number" barcode to receive goodsHi community, in mobile inventory management you can receive goods by scanning order number barcodes. I want to ask whether there are predefined BIP templates or some fe…
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 218 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
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… -
Query to get Receipt Accounting Transaction StatusHi Team, Please let me know from where we can get the Receipt Accounting - Transaction status column from backend. ( Navigation - Supply chain execution → Receipt accoun…
-
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…
-
PO>I WANT to get the information in the order life cycle in SQLHello. If you click on the View Order Life Cycle details on the right side of the purchase order screen, you want to pick up the information (such as received, delivered…
-
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
Issue related to Available to Reserve that needs to be printAs I am verifying the tables to get OnHand quantity INV_ONHAND_QUANTITIES_DETAIL, for pending quantity related I am using this table INV_MATERIAL_TXNS. But the problem I…