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 … -
Exception Report for Inventory Pending TransactionsSummary: We need a query to get the details of the Inventory Pending Transactions. Content (please ensure you mask any confidential information): We are seeking a PL/SQL…
-
No analysis available while creating a visualization metricI am trying to configure a visualization in the Inventory Management Landing page using an analysis, however when trying to search for the created analysis in the Visual… -
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 query to fetch the PO header detailsSummary: We have a requirement to create a report to show the PO header details Content (please ensure you mask any confidential information): We have a requirement were…
-
How contract terms are merged with BPA PDF?Summary: When we add terms to purchase agreement, then click on View PDF , the Report of agreement( RFT) and Contract terms which has the transformation templates, how w…
-
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain…
-
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin…
-
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…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
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… -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
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 …
-
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…
-
How to run Costing Reports outside of Scheduled Processes?Most of the reports under /Shared Folders/Supply Chain Management/Cost Management/Cost Accounting and /Receipt Accounting are only able to be run through the Scheduled P…
-
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…
-
Report descriptionSummary: I would need a complete list of Out Of the Box Reports for Oracle ERP and SCM. Content (please ensure you mask any confidential information): I would need a com…
-
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 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…
-
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…
-
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…
-
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.
-
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…
-
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…
-
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…
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
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 …