Fusion Supply Chain Management reporting
Discussion List
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…Sudhir Behera 14 views 1 comment 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration -
How to find which attribute is being updated based on Order Attribute Updated business event.Summary: How to find which attribute is being updated based on Order Attribute Updated business event. Content (please ensure you mask any confidential information): Ver…User_9HG0E 24 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…Shahid Qureshi 18 views 4 comments 1 point Most recent by Shahid Qureshi Reporting and Analytics for ERP
-
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 14 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 87 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2K views 7 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Historic table for EFF "ego_item_eff_b_" is timing out.I am writing a very simple query to see historical EFF data for an item and It is timing out when I tried to search with the inventory Item ID. What is the issue with th… -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 46.7K views 128 comments 30 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 106 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 367 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
SOAP Web Service to download attachments for Fixed assestsSummary: When I tried to call soap service to download Fixed attachments then I got this error. "JBO-Request Failed : Reason- User did not supply correct user key: Reque…
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
Unable to export the report in text format Windows (CRLF) UTF-8Summary: Hi We have a custom report. When we export the report in text format, should be export in Windows (CRLF) UTF-8 format but it is exported in Unix (LF) format. Ex…
-
Return to Vendor Report?Summary: Business needs a report of completed and pending RTV/RMA transactions. Content: Business is using Sales Orders to ship product to customers. Need a report to tr… -
How to add a deep link to items ?I have attempted to use the Deep Link SCM document to create a deep link for Items, but unfortunately, it didn’t work as expected. Could you kindly assist me with a step…
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 63 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 1.5K views 11 comments 0 points Most recent by User_2Y0JM Reporting and Analytics for ERP
-
How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?Summary: I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and ad…
-
Order Management Extension to copy Inventory Organization from Original Sales Order to RMASummary: Customer needs to copy warehouse information from the original sales order when creating a referenced RMA but we couldn't do it using pretransformation rules. I…
-
I am not able to access data model through report edit section, page showing as unresponsiveWhen I am trying to access a BI report to attach a data model through Edit section of the report, page is showing as Page Unresponsive in DEV instance, can i delete the …Shahid Qureshi 68 views 8 comments 0 points Most recent by Mahesh Kumar C Reporting and Analytics for ERP
-
How to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql queryHow to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql query(Fusion). SELECT INTRANSIT_TIME FROM msc_interorg_ship_methods mism, msc_s…Sreekanth Kandula 1 view 2 comments 0 points Most recent by Sreekanth Kandula Supply Chain Planning and Collaboration
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 775 views 14 comments 1 point Most recent by Adwait Rajmane 1 Reporting and Analytics for ERP
-
How to we call multiple Standard Packages in Data ModelSummary: As part of our requirement we need club two standard FA report columns. Two report called two different Standard Default Packages and in Report triggers also. C…Sarala B-Oracle 42 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 995 views 8 comments 0 points Most recent by MangalThorat Reporting and Analytics for ERP -
BI Cloud Connector (BICC) - Not all columns selected by default in PVOSummary: By default, not all columns are enabled in PVOs (This can be noticed when we enable a PVO in a BICC job). - Is there any logic used to choose the default column…
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 21 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP
-
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…