To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
SCM Report queriesSummary I would like to know where i can find a repository of report queries for this subject area.Content I would like to know where i can find this information for Pro…User_2025-01-25-06-03-46-894 97 views 4 comments 3 points Most recent by User_2025-01-25-06-03-46-894 -
Inventory Transaction and Costing - Cross Subject AreasSummary I need an OTBI Analysis that includes Inventory Transaction Real Time and Costing Item Cost Real TimeContent Hi, I created a cross subject area Analysis to displ…User_2025-01-28-18-00-07-296 112 views 4 comments 0 points Most recent by User_2025-01-28-18-00-07-296 -
Assign Printer to a UserSummary Assign Printer to a UserContent Hi, Can we assign a printer at user level without specifying any document. So whatever that user prints gets printed to a specifi… -
Defaulting LOV parameter value from sysdateSummary Defaulting LOV parameter value from sysdateContent Hi All, How to default Menu Parameter, from sysdate. Say, we need to get Month and year in the format of 'Mon-… -
Procurement Agent ReportSummary Needing Procurement Agent Report of Agents Allowed Actions and AccessContent I am looking for a report or way to find out not just which users are setup as a pro… -
Need a query to fetch all the report names and its locationSummary Need a query to fetch all the report names and its locationContent Hello All, We have a requirement like what are the reports are avilable in the system and what… -
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… -
Net Available Item QuantitySummary Subject area for Reserved Quantity and Net Available QuantityContent Hello Team, We have to update our analysis report, please suggest which subject area in Inve… -
Inventory OnHand Balance ReportSummary Inventory OnHand Balance Report
-
Purchase Order Pending for RecevingSummary Need report for Purchase orders pending for recevingContent All PO's which delivery dates are passed, we need the report to see PO pending for delivery date. -
How to override NULL valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …User_2025-02-06-00-08-33-553 43 views 6 comments 0 points Most recent by User_2025-02-06-00-08-33-553 -
Monthly POs Received ReportSummary Monthly PO Received ReportContent Is there any POs' received report for Inventory & Expense (items & Services ) . -
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in… -
Consigned Inventory ValuationSummary Consigned Inventory ValuationContent Our healthcare organization is new to Oracle Cloud Fusion SCM. I ran inventory valuation reports (from scheduled processes) …Pattianne Belitz-Children's Hosp Omaha 60 views 3 comments 0 points Most recent by Pattianne Belitz-Children's Hosp Omaha -
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 55 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 -
SCM Item PVOsSummary SCM Item PVOs Definition or explanationContent Hi, I am using BICC to extract data from ERP Cloud for downstream integration with a client's data lake. We are in… -
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… -
Please Help me to Get LinkContent Could you please help us to get link on Below Table. DOO_HEADERS_ALL, DOO_LINES_ALL, egp_system_items_b, DOO_FULFILL_LINE_DETAILS, WSH_DELIVERY_DETAILS.User_2025-02-05-19-52-13-612 41 views 2 comments 2 points Most recent by User_2025-02-05-19-52-13-612 -
How can we differentiate Payables and manual Journal Balances for a PeriodContent Hi, Normally in GL balances we have balance for Manual Journal + Payables Sub Ledger Journal Balances. If we have to differentiate two balances , then can you pl… -
Report 'Receipt Accrual Balances'Summary Report similar to 'Adjust Receipt Accrual Balances' menuContent We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Ba… -
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… -
BI Publisher: Parameters not getting passed from custom ESS job to BIP reportSummary BI Publisher: Parameters not getting passed from custom ESS job to BIP reportContent Hi We have a requirement to create a custom BIP report with From and To date… -
Work Order Table DetailsSummary Work Order Table details neededContent Hi All, I need the table name to get the work order number when its status is closed or completed, but sales order line is…User_2025-02-06-09-39-00-756 36 views 2 comments 0 points Most recent by User_2025-02-06-09-39-00-756 -
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… -
Supplier Registration or Profile Change Approval DetailsContent Hi , I want to prepare a SQL which will have supplier and approver details. I know we have below workflow and supplier tables: fa_fusion_soainfra.wftask fa_fusio… -
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee… -
Unable to select Data Source from Data ModelSummary Unable to select Data Source from Data ModelContent All --> I am facing issue with OTM BIP cloud Catalog. Issue: Not able to choose/select Data source from Data … -
Reports needed as per the customer languageSummary Manual reports need to be generated in customer languageContent Hi All, We are facing requirement from customer side that they want reports need to be generated … -
Procurement - Purchasing Agreements Real Time created reports does not show any dataSummary when a user having only the Purchase Analysis role run a report created using the Purchasing Agreement Real Time subject Area the report does not show any result… -
Demand Supply Inventory ReportSummary Looking for subject area that has all data elements for Demand Supply Inventory ReportContent Requirement: Purpose report is to provide the Demand, Supply and In…