Get Started with Redwood for Oracle Cloud SCM Begin Now
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
-
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w… -
No data displayed in Goods Received not Invoiced ReportSummary: Hi, I am using seeded OTBI Report 'Goods Received not Invoiced Report' and made a custom report with the same subject area i.e. Costing- Receipt Accounting Real… -
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…
-
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…
-
Shared SCM ReportsDoes anyone have a monthly total spend report that they might share? OTBI or SQL code? Co
-
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…
-
Do we have to update vendors to point to a new ledger and/or BU? If Yes, how to do this in MassSummary: We are considering changing our Fiscal Year to the Calendar Year and would like to know if we have to update vendors to point to a new ledger and/or BU? If yes,…
-
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… -
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 …
-
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…
-
how to improve the OTBI analysis export record limit?Summary: Hi Guru, we created an OTBI analysis using the standard data model, but looks like it can only support to export 250k records, is there any way to improve that …
-
How to import a Order Management data to Fusion Data Intelligence from Oracle cloudSummary: We have a FDI installed in a customer, but we don't find the Order Management data to load in the FDI We found only Financial Analytics, Procurement Analytics, … -
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…
-
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.
-
need to add item number with item class and item category in bipneed to add item number with item class and item category in bip, How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ? The…
-
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…
-
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…
-
why the custom report of item inventory is taking longer time to generateSummary: why the custom report is taking longer time to generate while we have only less items in the inventory Content (please ensure you mask any confidential informat… -
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…
-
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…
-
P2P report. PR-PO-Receipt-InvoiceSummary I need a report on P2P process.Version 19A
-
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…
-
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…
-
Not able to find backing Requisition number field for Transfer Order in OTBISummary: Not able to find backing Requisition number field for Transfer Order in OTBI Content (please ensure you mask any confidential information): We are creating an O… -
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…
-
Data Not Visible in OTBI Dashboard for the userSummary: We have create a custom OTBI dashboard to show Item Information, Inventory Information , Purchasing Information, Sales order Information, Price List Information… -
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. Release: 25A…Ramamurthy Shankarachetty-Oracle 15K views 53 comments 40 points Most recent by Praveen Kumar Akkala-Oracle
-
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 …