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
-
Report descriptionSummary: I would need a complete list of Out Of the Box Reports for Oracle ERP and SCM. Content (please ensure you mask any confidential information): I would need a com… -
Unable to find the subject area for the context segment of work order for OTBI reportHi Everyone, We’re working on an OTBI report for Work Order details and need to include the Context Segment field. However, this column doesn’t appear in the Work Order …
-
How to create an infolet link to an Advance Seach to the applicationSummary: How to create an infolet link to an Advance Search to the application. Similar of what I attached to the question. This one is an Oracle seeded infolet. if you …
-
How to add a new page for the inforletSummary: I was able to add a few report to an existing page. but I want to be able to crete a new page and add all my reports. I added my report using the page Composer …
-
Best way to create custom infolet and a dashboardSummary: Best way to create custom infolet and a dashboard Do you have any documentation? Content (please ensure you mask any confidential information): Version (include…
-
Warning while Deploying DFF's into OTBI and BI ReportsSummary: In oracle fusion, we run "Import Oracle Fusion data extension for transactional Business Intelligence" process to deploy the DFF for OTBI and BI. However the pr…
-
report only returns current live inspection dataWe have developed an Inspection Summary Report in Oracle Fusion (BI Publisher / OTBI) to retrieve inspection history for all items in our inventory organizations. The re… -
Oracle 26A release impacting the OTBI subject area "SCM – Inventory Receipts".Oracle has announced changes as part of the 26A release impacting the OTBI subject area "SCM – Inventory Receipts". As per Oracle documentation, the Inventory Receipts s…
-
How to run Costing Reports outside of Scheduled Processes?Most of the reports under /Shared Folders/Supply Chain Management/Cost Management/Cost Accounting and /Receipt Accounting are only able to be run through the Scheduled P…
-
Supply Planning Orchestration - need to populate Subinventory from "Manage Subinventory Items"Summary: We have a requirement for Requisitions created from planning - where we need to default the SubInventory from "Manage Subinventory Item mapping" in Supply Orche…
-
How to identify Region/Location names on Transit time tables?Summary: On the transit time tables (WSH_TRANSIT_TIMES/WSH_TRANSIT_TIME_VALUES), we have the From & To Location and Region ID's. So, which tables can be used to map thes…
-
How to View the Output of an ESS Jobs Submitted By Another UserSummary: How to View the Output of an ESS Jobs Submitted By Another User? I am unable to view it even though I have ESS Monitor Role. Only people with BI Admin are able …
-
How to add Shipment Header DFF in OTBI report?How to add Shipment Header DFF in OTBI report?
-
25D New Column in EGP_SYSTEM_ITEMS_B - Custom Integrations FailingSummary: We are currently reviewing the recent Oracle patch updates in PROD and have encountered an issue that warrants clarification to ensure smooth implementation for… -
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin…
-
How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI ReportSummary: How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI Report. Which parameters need to pass to this function. Content (please ensure you mask …
-
how to extract One Time location entered in Ship to location on Purchase Orders using BIP reportWe want One Time location entered in Ship to location on Purchase Orders. Where it is stored? How we can extract using sql query.
-
FDI SCM analytics workbook newschedule option not displayingSummary: The user has Service Administrator access and Read/Write permissions on the workbook. However, while attempting to create a schedule for the workbook, the “New … -
Configuration and Roles required for Evaluate Procurement PerformanceSummary: Hi All, We are looking for details on Configuration and Roles required for 1) Evaluate Procurement Performance, 2) Evaluate Supplier Performance and perform 3) …Goopikrishnan Jayaraman-Oracle 1 view 0 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle -
Sales order report customization and how to get XML for current Sales orderSummary: I have to customize Sales order report of the below path. But this Data Model SQL query is not exposed. Oracle has provided the sample xml in datamodel properti…
-
Need Join between projects and item tables in fusionHi Team, I am using below query to fetch the data for Project Budget details. I am unable to fetch the join between project and egp_system_items_b tables.If any one havi…
-
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25D -
How doo_headers_all and por_requisition tables are related .Summary: We need to write query to connect doo_headers and requisition to get po_number and receipt . or it can be connect from PO or RCV tables? how can i form query wi…
-
SCM INT Process Work Order Details (ASN) Oracle to Third PartySummary: outbound integration report from Oracle to Third Party Content (please ensure you mask any confidential information): Hi Team, Need information on creating outb…
-
what is the equivalent table in Oracle fusion for wf_notification table in EBSSummary: We are looking to build a report to get approval details of delegated approvals . E.g: Workflow type, original approver , approved by , Approval Date Etc. Conte…
-
HOW TO CALCULATE GRAND TOTAL OF LINE VALUES IN MY RECEIVING PAGE ON ORACLE FUSIONSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How can I determine which weekday corresponds to DAY_START_NUM and DAY_STOP_NUM(ZMM_SR_PATTERN_DTLS)Hi everyone, I have a question regarding the ZMM_SR_PATTERN_DTLS table, specifically the DAY_START_NUM and DAY_STOP_NUM columns. In my case, I have: DAY_START_NUM = 1 DA… -
The .xls output format is missing on Scheduled process Advanced Options tabHi Community, When we try to run a BIP report from Scheduled Process and use the Advanced Options tab to select Output format, the .xls format is missing and only mhtml …
-
In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What …
-
How to bulk create item structure from "Create from common" using FBDISummary: How to bulk create item structure from "Create from common" using FBDI Content (please ensure you mask any confidential information): In our project there is re…