Supply Chain Planning
Discussion List
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 22D…Ramamurthy Shankarachetty-Oracle 8.7K views 50 comments 35 points Most recent by Anders W. Langholm Reporting and Analytics for SCM -
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 11 views 2 comments 0 points Most recent by Ripendra Kumar-Oracle Reporting and Analytics for SCM
-
What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and S&OP?Summary: What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and Sales and Operations Planning? Content (required): What BICCs are…
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…
-
How to make a custom report available in supply planning work area?Summary How to make a custom report available in supply planning work area?Content Created a custom report. Users want it to be able to open from the supply planning wor…
-
BI publisher for Demand Plan custom measures.Summary: Hi all, please I would thank for any help with the following. We need the query below this Demand Plan screens. Example 1. Example 2. We have noticed some table…Juan Jesus 41 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…Yogesh Nemchand 36 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Org LOV throwing error in Standard Report - Exception Summary by ItemSummary: Org LOV throwing error (Attached Screenshot) in Standard Report - Exception Summary by Item. Content (required): Org LOV throwing error (Below Screenshot) in St…Jasvinder Singh-Oracle 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Table and column for Firm DateSummary: The supply planning UI shows Firm Date as a column in the supplies and demands table. This date reflects when the product is expected to arrive. What is the tab…
-
Can I compare archived versions of supply plan in OTBI?Summary: I am trying to build analytics/ reports in OTBI, where I can compare different versions of the same supply plan. Content (required): does that work similar to A…
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
Is there a way to restrict BI Admin role user to Query only Supply Planning related tables to buildSummary BI Admin - Role restriction per moduleContent We are already live with HCM and implementing Planning modules. When a user having only supply chain roles get BI A…Ramkumar Sethuramalingam 26 views 2 comments 0 points Most recent by Ramkumar Sethuramalingam Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 525 views 1 comment 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 116 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …Sushan Peiris 1.2K views 1 comment 2 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…Rohit Kumar-266502 266 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 205 views 1 comment 3 points Most recent by Sushan Peiris 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 532 views 3 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 42 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Complex Inventory Stock Ageing Report by Original PO Receipt DateSummary Require feasibility check on a complex Inventory Stock Ageing Report (Across Multiple Inventory Orgs)Content We have an unique report requirement for customer re…Balachander G-Oracle 42 views 2 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for SCM
-
Generating a indented BOM list report.Content Hey there, I'm trying to generate a report with the indented list of a BOM. In Oracle 10 we had fields to build the structure based on a starting node and then j…Gabriel Alejandro Zorrilla 45 views 4 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for SCM
-
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 40 views 2 comments 2 points Most recent by Renuka Soneja-154959 Reporting and Analytics for SCM -
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…Yogesh Nemchand 77 views 8 comments 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…Yogesh Nemchand 53 views 1 comment 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Report for All Products in Staging with Order NumbersSummary Report for All Products in Staging with Order NumbersContent Hello, Can you please advise from which subject area we can download a report with all products in s…Yogesh Nemchand 30 views 2 comments 2 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Enabling the User to Edit Reports Created by other USerSummary Enabling the User to Edit Reports Created by other USerContent Hello , I need to enable a user to edit reports for SCM created by other user i created a Custom R…Ali Essam El-Bandrawy 37 views 2 comments 0 points Most recent by Ali Essam El-Bandrawy Reporting and Analytics for SCM