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
-
query to get start date and finish date for a resource in project taskSummary: Need a query to get start date and finish date for a resource in project task Content (please ensure you mask any confidential information): Version (include th… -
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens…
-
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled …
-
Tools>>Reports and Analytics Page is still not available in RedwoodSummary: Reports and Analytics Page is still not available in Redwood . By when this page will available in redwood ? Content (please ensure you mask any confidential in…
-
How to restrict BOM import for Items in the Production Lifecycle Phase Using Import MapsUse case: While end users can import BOMs through import maps in SCM, the system must restrict BOM imports for items in the Production lifecycle phase.The requirement is…
-
Query to get all the defined UOMSummary: Query to get the UOM that we've defined in our application. Content (please ensure you mask any confidential information): Hello, We need to have a query to get…
-
Does Oracle fusion PIM provide seperate privileges for adding attachments and removing attachments?>Summary: We want to provide users to add attachment privilege, but remove only those attachments that are created by the user. Is that possible in Oracle fusion PIM 25D?…
-
In OTBI's Order Management - Order Headers Real Time, all currency fields are nullSummary: Our customers have a requirement to output a report of the total amount of sales orders in OTBI. At that time, we want to display the currency code along with t…
-
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control… -
Where can i find latest Lineage docs ?Summary: Where can i find latest Lineage docs for FSCM, FHCM , CRMAnalyticsAM ? Content (please ensure you mask any confidential information): Version (include the versi…
-
From where to get the return order number for SO without fulfillmentSummary: We need a place where we can get the return order number for an original order number in case there is no fulfillment. Content (please ensure you mask any confi…
-
SQL query for Fusion Subledger Accounting Hub with Channel Revenue ManagementHello, we need to create an SQL query where we have ChRM Program details, Accrual and Journal Batch Transaction Details: Debit/Credit from Accounting Hub. Can you please…
-
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…
-
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 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… -
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…
-
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.
-
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…
-
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…
-
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 … -
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…
-
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…
-
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…
-
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 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…
-
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… -
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…
-
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…
-
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… -
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…