Order Management
Discussion List
-
Error while loading Sales order through FBDISummary: Getting error while loading sales order. This error occurs in source order 1103-F65660TEST, on source order line 1, source item name 846581, source item 300,000… -
OrderChargeComponentExtractPVO extract contains duplicates for primary key while extraction.Summary: OrderChargeComponentExtractPVO extract(via DataSync) contains duplicates for primary key. Content (required): We are extracting data using the OOTB PVO 'FscmTop… -
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 3.4K views 30 comments 30 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
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…
-
Unable to link Order Fulfillment and Item Cross Reference Subject AreasSummary Unable to link Order Fulfillment and Item Cross Reference Subject AreasContent Hi, Are there any documentation to identify what join is missing when we try to re…Shifa Nazumudeen 3 views 1 comment 0 points Most recent by Shifa Nazumudeen 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 2 comments 2 points Most recent by Israel J Garcia Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 32 views 6 comments 4 points Most recent by Arghyo Banerjee -Oracle 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 24 views 1 comment 3 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 14 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…Murielle Manambelona-Oracle 16 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
Out of the box Sales and GP reportContent My client is looking if there is a seeded out of the box Sales report that shows the daily sales and Gross profit. The closest i see is the Sales Order document …Hari Thyagaraj 8 views 0 comments 0 points Started by Hari Thyagaraj 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 …
-
OTBI Dashboard results in display errorSummary The dashboard contains an analysis with extensible flexfields. The flex field is deployed and working fine within OTBI but when deployed on OM Landing page via s…Tejas Mehta-248693 19 views 2 comments 0 points Most recent by Tejas Mehta-248693 Reporting and Analytics for SCM
-
How to find or differentiate Internal/External Drop shipmentsSummary How to find or differentiate Internal/External Drop shipmentsContent Can you please share the query for the Internal/External Drop shipments sales order? This wi…AnishRV 9 views 2 comments 0 points Most recent by Arunkumar S-Oracle Reporting and Analytics for SCM
-
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…Jonathan Chan gmg 26 views 1 comment 2 points Most recent by User_LDHCN Reporting and Analytics for SCM
-
Specification for DOO_CROSS_REFERENCESummary Specification for DOO_CROSS_REFERENCEContent In the DOO, most of the views 'DOO_CROSS_REFERENCE' Pkg used to get shipment method, freight term...etc Where we can…
-
Query for Sales Order Contact at header and line levelSummary Query for Sales Order Contact at header and line levelContent Can you please share the query to get the customer Bill_to and Ship_to contact details at header an…
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 25 views 3 comments 0 points Most recent by Karina Ogata 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 47 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 23 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
-
Ship to Org LOV not returningSummary I am able to run a report from the Procure to Pay Real Time subject area and the column returns Organization Name, but the same column in the parameter does not …Ari_L 12 views 2 comments 0 points Most recent by Alexandra Andrei-73074 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 376 views 1 comment 11 points Most recent by Mohammed Ali Manzur Arshi Reporting and Analytics for SCM -
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…Vitor Lima-178070 28 views 4 comments 3 points Most recent by Bradley Q-Oracle Reporting and Analytics for SCM
-
Out of the Box ReportSummary Are there any out-of-the-box reports that satisfy these requirementsContent I have a list of reports/descriptions below for which I am looking for out-of-the-box…
-
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized …Soumya Prakash Parhi 59 views 4 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for SCM -
How to find order number when we have RMA in fusionContent Hi, In DOO_HEADERS_ALL , we have both RMA and corresponding SO number. But how can I find sales order number for a particular RMA Regards NidhiNidhi Chhajed 19 views 1 comment 2 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 36 views 1 comment 2 points Most recent by Mauricio Chavarry-132851 Reporting and Analytics for SCM
-
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 40 views 2 comments 0 points Most recent by Amarnath Govindu Reporting and Analytics for SCM -
Report in Different LanguageSummary Reports in different languageContent Hi All, I am having one requirement in which I need to display the report in different language as per the customer site. fo…Harshal Agrawal-97059 40 views 3 comments 0 points Most recent by Phanindra V Gollapalli-Oracle Reporting and Analytics for SCM