Category 174
Discussion List
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 26 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM -
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 9 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…shaikh123 23 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsNeed SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsDhilip Kumar P. 8 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Will the Redwood upgrade will impact our existing Analysis reports and/or DashboardsSummary: Will the Redwood upgrade will impact our existing Analysis reports and/or Dashboards that use Analysis reports? We are trying to schedule and prioritize project…Bill Stearns at Essex Grove Consulting 33 views 4 comments 0 points Most recent by Bill Stearns at Essex Grove Consulting Reporting and Analytics for SCM
-
Work Order DFF not visible in OTBI Subject AreaSummary: Work Order DFFs are not visible in OTBI Subject Area We have run the process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" also…
-
Query to get Receipt Accounting Transaction StatusHi Team, Please let me know from where we can get the Receipt Accounting - Transaction status column from backend. ( Navigation - Supply chain execution → Receipt accoun…
-
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 32 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
Error when running report using REST apiSummary: Error when running/calling the report using REST api. Content (please ensure you mask any confidential information): Hello Experts, Is there a way to call or ru…Shiva Kumar Bandaru 23 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Report is ending in errorWe have a custom BI report related to Inventort module. The report generates excel output and the file size can be of 100 MB or more. When we run the report for multiple…KabirB 13 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query… -
Tracing bursting processSummary: We are currently sending mails to customers through the bursting process. Could you please confirm if it is possible to trace, from the backend, the details of …
-
How to make the report link variableSummary: Sandbox-How to make the report link variable Content (please ensure you mask any confidential information): Hi Team We have customized a report and use sandbox … -
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 593 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
inventory aging preview feature in FDI--how to fully enable?I have enabled the feature inventory aging in the preview section of Fusion Data Intelligence. We are running version 25.2. But I don't see a new subject area called SCM…
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…VDM_IM 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
https://CloudUrl:443/xmlpserver/services/ExternalReportWSSService' failed:Timeout exceeded.Summary: We have custom BI Report data model and layout. we trigger BI report using https://iaxgqy-dev1.fa.ocs.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSS…sasi 58 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Issue creating RTF Template using Non-standard SQL Data ModelSummary: Issue creating RTF Template using Non-standard SQL Data Model Content (please ensure you mask any confidential information): I have created a new Data Model in …
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da… -
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…Krishan_Palihakkara 628 views 5 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Can we fetch tax classification code using subject areas under supplier address levelHi , We are trying to add tax classification field in otbi report using subject area Supplier - Supplier Real Time, we can get the details of tax classification code und…
-
Transfer Orders enabled - table fieldSummary: Transfer Orders enabled - table field Content (required): I am looking for what the correct database table field is for the below highlighted field in the UI un…
-
Need to validate why the value is differing from ERP in TableHi, At the table level, for item SU103216, we are seeing the inverse usage rate value as 1000000000, with a last update timestamp of 2025-05-19T10:33:22.169+00:00. Howev…
-
BICC Extracts: how can i find out what attributes are used for each of the fields in the data storesI am looking to find out what attributes are used for each of the fields extracted within our BICC Extract data. Our data reporting teams need to understand if a field i…Tracy Collins 1 view 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting and Analytics for SCM
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
Lexical parameter values for Movement Request Pick Slip Report data model changesSummary: We are working on the SQL query for Oracle Seeded Data Model - Movement Request Pick Slip Report Data Model where it shows some lexical parameters and asks to p…Suyog Dhongade 16 views 0 comments 0 points Started by Suyog Dhongade Reporting and Analytics for SCM
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 41 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
Does anybody know why fields are not available to be shown on template for data modelSummary: Does anybody know why the data model may be correctly reading my 2 fields (source_document_id, txn_qty) but they are not listed in fields available in current d…
-
Inventory Transaction Detail BIP Report-30 Columns-Item with Serial Control Enabled-65K LimitationSummary: Hi Everyone, We have a requirement from business to build BIP report for the Inventory transactions which they track manually at present. There are around 30 co…