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
-
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)… -
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …
-
Work Definition view only- secondary quantity is updatableSummary: Created custom view only manufacturing engineer role which is working fine, except secondary quantity for operation items (input material / ingredient) is edita…
-
Customising Datamodel of (seeded) Sales Order ReportSummary: How can we customise the Datamodel of the (seeded) Sales Order Report? Content (please ensure you mask any confidential information): The Sales Order Report is …
-
Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transactHi Team, We need to retrieve available to reserve and available to transact , but we've observed discrepancies when querying through SQL. Our goal is to achieve this via…
-
Shared SCM ReportsDoes anyone have a monthly total spend report that they might share? OTBI or SQL code? Co
-
Prompt LOV restriction in OTBI according to user Business unit data accessSummary: We are trying to restrict the prompt LOV which returns BU names that currency configured in the system. But we want that when a particular user will try to run …
-
Requisition Counts and Year to dateSummary: Requisition Realtime Help! I am trying to create a Requisition report that will display Departments and columns Jan ct, Feb cnt etc and the last column will be …
-
Serials in Transaction History for PO Receipt Number – SQL Query Adjustment NeededSummary: Hi Oracle Support, I am using the query below to retrieve serial numbers for receipt 30148, but it does not show all four serials as seen in the Transaction His…
-
Database table to get the min and max quantity for Replenishment plan type item in oracle fusionSummary: Hi all, please let us know Database table which stores min and max quantity for Replenishment plan type item in oracle fusion Content (please ensure you mask an…
-
How to get original or first requisition approved dateHi! I need to get the first or original requisition approval date for a report. How do I get it? The field Requisition Approval Date shows the latest/recent approval dat…
-
Subject Area to return the Reservation Date of Fulfillment line in Order ManagementHi all, I am currently trying to calculate the length of time an item has been Reserved to a Sales Order in Order Management. Is there a subject area in OTBI that contai…
-
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion. -
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po…
-
where can i find receiving and inbound quantity's for on hand reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need a Query to build a BI report to get the details on exceptions table from supply planning cloudSummary: I am trying to build a BI publisher report to extract data from exception table as per our requirement. Could you please help to find a way to get the query/tab…
-
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…
-
Capacity / Resources Requirement calculation for Phantom subassembliesSummary: Hello All, How is Capacity / Resources Requirement calculated for Phantom subassemblies in constraint supply chain planning? supply planning doesn't calculate p…
-
Purchase requisition and purchase order Comparison ReportSummary: I want to create a query to retrive PR Amount and PO Amount Associated with It and return difference between them Content (please ensure you mask any confidenti…
-
Query for Workflow Details of NIRHi Everyone, I am looking for the query to get workflow task details of an NIR. Please refer to highlighted part screenshot for details. I am creating a custom BIP Repor… -
Review work order cost View Detailed balance UI: Need table for Cost Allocation FactorSummary: Hello Community, I'm developing one report related to manufacturing costing for which I need table name for Cost Allocation Factor. Any leads will be helpful. P…
-
extensible flexfieldSummary: 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 attachment actions in PIM can be restricted in ITEM tab for Approved Items using a Page ComposerCurrently we have used below expression builder to hide the Add/delete/Check In/Check out Component from 'Item Revisions' Tab, But the Same expression builder is not all…
-
Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,… -
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
How to access and print attachments in Quality Action/Issue ReportSummary: We have a new business requirement where they want a report that lists/print all the attachments of each Quality Action/Issue available in Attachments section. …
-
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
can you join "Fulfillment Lines Real Time" with "Receivables - Customer Real Time"Need to join those 2 subject areas to bring the "collector" from the account to the orders data. Both areas have the account number, but cant seem to find a way to join …