BI Publisher Reports
Discussion List
-
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 220 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…
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 41 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
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…
-
Knowledge Article: 20B Updates to Sourcing NotificationsSummary This article is about recent updates to Sourcing Notifications and how a Category Manager can configure external notifications sent to suppliers as per the busin… -
Report is ending in errorWe have a custom BI report related to Inventort module. The report generates excel output and the file size can be of 100 MB or more. When we run the report for multiple…KabirB 22 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
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…
-
Adding a sorting option in Min-Max planning reportSummary: Hi, there's a requirement to add an additional Sorting option in the Min-Max Planning seeded report. Currently it has option to Sort By Buyer, Category, Invento…
-
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 …
-
Movmnt of Stock frm 1 Inv Org to Other Such That Its Current Bucket in Inv Aging Reprt isn't ChangedSummary: Business user wants to transfer two items (one item has 1 quantity and the other item has 2 quantities) from one of their inventory orgs to the other in such a …
-
Question about DOS_SUPPLY_TRANSFER_ORDER_DTLS tableSummary: Question about DOS_SUPPLY_TRANSFER_ORDER_DTLS table Content (please ensure you mask any confidential information): We have a question about the DOS_SUPPLY_TRANS…
-
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…