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
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…
-
How to enable Procurement Dashboard in development instance?How to enable Procurement Dashboard in development instance? Does this work area require extra licence appart from the regular licensing? I can see Procurement Dashboard… -
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…
-
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
Difference in report outputs in PIMI have a custom report built using SQL based data model, no UI or report level filters. However when I run the report an excel is downloaded with inconsistent report out…
-
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…
-
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 …
-
Supplier Statement ReportSummary: Any OTBI or Seeded Supplier Statement Summary & Details report including transactions details and opening closing balances. Content (required): Any OTBI or Seed… -
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …
-
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…
-
Unable to find PartySiteID received in EDI850 payload in backend CML Log tables for CMK Errors.We have a requirement to display the 'PartySiteId' and 'AccountSiteUseId' fields—present in the Purchase Order Inbound EDI payload—in the Custom EDI850 Error Report when…
-
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… -
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 …
-
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain…
-
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …
-
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…
-
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…
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data … -
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…
-
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl… -
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 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…
-
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…
-
OTBI is not showing Safety Stock Quantity values from Supply PlanningSummary: OTBI is not showing Safety Stock Quantity values from Supply Planning when using Supply Chain Planning Real Time subject area. Content (please ensure you mask a… -
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… -
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…
-
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 add Shipment Header DFF in OTBI report?How to add Shipment Header DFF in OTBI report?
-
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…