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. …Ramamurthy Shankarachetty-Oracle 6.2K views 37 comments 33 points Most recent by Tracy C 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 27 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…
-
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…Sushan Peiris 57 views 8 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
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 16 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 181 views 1 comment 3 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 26 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 368 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 98 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 35 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 52 views 3 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
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…
-
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 23 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Boost Revenue and Profit Performance With Oracle IBPXSummary Join us on Wednesday, January 20 from 11:00 AM - 12:00 PM CT to learn how to implement forward-looking metrics to drive optimum performanceContent Manufacturers … -
Relate EGP_STRUCTURES_B/EGP_SYSTEM_ITEMS with Catalogue Categories.Content Hi. I made a BOM explosion using EGP_STRUCTURES_B and now I need to filter out some results based on catalogue properties of the items. I did not find meaningful…Gabriel Alejandro Zorrilla 26 views 0 comments 0 points Started by Gabriel Alejandro Zorrilla 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 22 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 26 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 29 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 48 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 25 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 20 views 2 comments 2 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Updating DFF on Requisition Distribution based on Other fieldSummary Need to Update Requisiton Distribution DFF on the basis of another field of Requisition DistributionContent Hi There, We have a requirement where in we need to u…
-
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 16 views 2 comments 0 points Most recent by Ali Essam El-Bandrawy Reporting and Analytics for SCM -
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 394 views 1 comment 11 points Most recent by Mohammed Ali Manzur Arshi Reporting and Analytics for SCM -
Monthly POs Received ReportSummary Monthly PO Received ReportContent Is there any POs' received report for Inventory & Expense (items & Services ) . -
Need A SQL query to get the supplier contact address detailsSummary Need A SQL query to get the supplier contact address detailsContent Need A SQL query to get the supplier contact address details Here I have attached the screens…Koteswararao Yenikepalli 54 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM -
Need EL Expression for the Requisition ID from the Purchasing ScreenSummary Need EL Expression for the Requisition ID from the Purchasing ScreenContent Need EL Expression for the Requisition ID from the Purchasing Screen Version 19cKoteswararao Yenikepalli 15 views 0 comments 0 points Started by Koteswararao Yenikepalli Reporting and Analytics for SCM