BI Publisher Reports
Discussion List
-
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 42 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 21 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…
-
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 704 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 11 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
-
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…