Reporting and Analytics for SCM
Discussion List
-
DFF details are not found in Install base Subject AreaSummary: By default the DFF on IB will show up in OTBI reporting ? Content (required): I have DFF created on IB asset, When I tried to add the DFF to a OTBI analysis I d… -
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
Get latest revision of sales order in OTBISummary: Get latest revision of sales order in OTBI Content (required): Hi Team, A sales order may have more than one revision. We are trying to create a OTBI analytics … -
Navigate to Installed base Assets page using action links in OTBISummary: Issue with Navigating to specific Asset summary page from OTBI analysis for IB assets Content (required): I am trying to click to view, and navigate to IB asset…
-
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…
-
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… -
Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User-Summary: Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User Content (required): Hi, We have a requirement for a report which…
-
Product Development Change Order Audit history reportSummary: Need sql or database tables to generate Change Order Audit history report Content (required): As of today, there is no decent Audit history report of change ord…
-
Unable to print from ERP cloud to on-premise Print serverSummary: We implemented in Integration between Oracle ERP Cloud and On-Premise print server as mentioned in Doc ID 1964157.1 and completed all steps mentioned in above d…
-
Is there a way to dynamically update the column header names on reports when Name = Months?We have a report that displays monthly data with the Months as Column Headers. Currently, as a workaround, row 1 is displayed as Month 1, Month 2, etc. and row 2 is mont…
-
Is there any subject area with the Planned Delivery Date on the shipment?Summary: We have to create a report on the shipments and need the Planned Delivery Date that appears in the shipment. We cant seem to find it. Content (required): Versio…
-
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Need to report which Orgs have a common BOM added in OTBI reportSummary: When I run a BOM report in OTBI only brings up the master org when other orgs have the common BOM added Content (required): We have a group of products where th…
-
How to give access to a custom dashboard and data within itSummary: How to give access to a custom dashboard and data within it Content (required): Hi, We have some custom dashbaords developed and each dashboard has multiple ana…
-
Filter Planned Completion Date Based on Current DateSummary: Content (required): Hi, We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time…
-
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. …
-
Need a way to create OTBI for Available to transact quantity in Inventory ManagementSummary: We are trying to create a OTBI to report 'Available to Transact' on hand quantity. However, we dont find this field in any OTBI under Inventory Management. Any …
-
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i… -
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c… -
Is it possible to give OTBI analysis access to Department Managers without any job role?Summary: Hello, We have a requirement to see PR-related analysis by department managers. These managers are not having roles or data access related to SSP module. Simila…
-
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…
-
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…
-
Fusion SCM Analytics for MFG and Planning?Summary: Does Oracle has any plans to extend its current footprint of Fusion SCM Analytics with pre-build (industry standard) KPIs for MFG and Planning ? Content (requir…
-
Can we customize the Award Negotiation Spreadsheet?Summary: Is is possible to customize the Award Negotiation spreadsheet? Also , is this report a BIP report in OTBI? If yes can you share the location? If it is not what … -
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…
-
Custom Report Printing PO Terms and ConditionsSummary: How to Print PO Terms and Conditions? Content (required): Is there a way to add the Terms and Conditions attached to PO to a custom report. I've checked the sta…
-
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…
-
Documentation on Complete list of available pre-built KPI/metrics in Fusion SCM Analytics (FAW)?Summary: Can you please let us know the link where we we can get to know the complete list of metrics/KPI available in SCM Analytics for OM, Procurement and Inventory? C…