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
-
Get More from SCM Analytics: Three Webinars You Won’t Want to MissThree upcoming webinars will show how to get more from Oracle Fusion SCM Analytics—using prebuilt analyses, metrics, and dashboards (Sales Orders, Procurement Spend, Inv… -
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 … -
Clarification on Future Support for External Data Sources in BI Publisher for SaaS to OICIntegrationDear Oracle Community, We have a requirement to utilize the external data source configuration feature in Oracle Fusion Applications BI Publisher to establish connectivi…
-
How to schedule report in working hours from Monday to FridaySummary: Schedule oracle standard report in working hours morning 10AM to 7 PM from Monday to Friday Content (please ensure you mask any confidential information): Sched… -
Oracle Fusion’s New Data Extraction Tool for SCMHi - I wanted to try the new Oracle Fusion’s New Data Extraction Tool for SCM . After config I logged in to fusion using the user which has the correct roles as per the …
-
How to customise Print Min Max Planning ReportHi, We have a requirement to add/modify columns in the seeded Print min max planning report. Since it fetches data from a temporary table, is it possible to customise? W…
-
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…
-
Generate Nutrition Facts Panel / Label in Oracle Fusion CloudIs there a way to generate and print nutrition facts panels or labels in Oracle Fusion Cloud? Maybe using BI Publisher or other tools.
-
ARCredit Memo Comments: Attribute CreditMemoComments in view object CreditMemoHeader1 cannot be set.Summary: I'm trying to update the AR Credit Memo Comment field using REST API. It is throwing, Credit Memo Comments: Attribute CreditMemoComments in view object CreditMe…
-
Which table stores FBDI Import Sales Order subprocess errors? Main process shows status, no details.Summary: In which table can I find the error messages for errors that occurred during the Import Sales Order using FBDI at the Import Sales Order Subprocess level? The m…
-
How I can extract the list of subinventories and the respective Inventory OrgSummary: Extract the list of subinventories and the respective Inventory Org Content (please ensure you mask any confidential information): We need a query or a way to e…
-
For retail industry, being a huge amount of transactions, most of the standard reports are failingSummary: For our retail industry specific customers, the amount of transactions are huge per day. Hence whenever we try to run the standard reports, most of the reports … -
Procurement dashboard not showing any dataSummary: Procurement Dashboard returning no data despite user having Buyer role and active Procurement Agent configuration. Content (please ensure you mask any confident…
-
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…
-
How to upload FBDI supplier tax classification code in address levelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Select BIP Query to Fetch the Requisition DetailsSummary: PL/SQL Select Query to Fetch the Requisition Details in Oracle Self Service Procurement Content (please ensure you mask any confidential information): We have a…
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…
-
How can I hide disabled item classes in Report and Analytics?Hi, How do I hide / remove disabled Item Classes in Report and Analytics? I have disabled 2 item classes, but these are still showing in Report and Analytics Is it possi…
-
Query to fetch the item wise lots with the on-hand per subinventorySummary: Request to have a select query to fetch the item wise lots with the on-hand per subinventory Content (please ensure you mask any confidential information): We h…
-
How to fetch Burden Cost Burden Cost Code (Oracle Project Costing) — tables/SQL?Hi All, We’re trying to fetch burden cost details along with the burden cost code in Oracle Project Costing. Environment (please confirm) Product: Oracle Fusion Cloud: 2…
-
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… -
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…
-
Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …
-
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… -
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… -
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Which table in Oracle fusion stores the error messages while Importing sales Order using FBDIIn which table, can I find the error messages for any error occured during the Import Sales Order using FBDI
-
How To restore Deleted Folder Under Shared Folders Within BI PublisherSummary: One of the users deleted a folder under Shared Folders→ Custom. Please let us know how can we retrieve the deleted folder Content (please ensure you mask any co…
-
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… -
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…