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 … -
SQL query for item master and functional catalog assignmentsSummary: We have a requirement to develop a report to fetch a list of items with catalog and category values. Content (please ensure you mask any confidential informatio…
-
Customer Recon ReportSummary: We are importing the Cutomers,parties,partisite,partisiteuses,address,site,siteuses,location,contacts details using FBDI.Is there a specific report that we can …
-
Select BIP to get the pick slip for the pending transactionsSummary: Select BIP to get the pick slip for the pending transactions of a specific item Content (please ensure you mask any confidential information): Hi All, we need a…
-
Oauth Error while invoking the SCM RODS api for the new data extract toolSummary: I am trying to invoke the RODS api for the new fusion extract tool . This URL is used to get the extract definitions, it works when using the access token from …
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
OTBI Reporting Performance issueI am using two subject areas Order Management - fulfilment lines real time & Shipping real time for oracle fusion OTBI report, as per the business requirement, inspite o…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…
-
BIP Bursting Email Delivery Failing - SMTP_FROM Missing Required Property in Oracle Fusion CloudSummary: I have set up a BIP bursting report in Oracle Fusion Cloud (SCM/Inventory Management) to deliver personalized Excel reports to multiple email recipients based o… -
Passing Custom Parameters (BIP) in Report Task Type in Guided Journeys (Redwood - shipment page)BI Report on Shipment Page: We need the Guided Journey parameters available on the "Shipment" page to pass the Shipment as an input parameter required by the BI reports.
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
Supplier master Alias name tableSummary: Need a query to get the Supplier master Alias name Content (please ensure you mask any confidential information): Hi, we are maintaining some naming conversion …
-
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…