Category 174
Discussion List
-
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… -
Need query for Change Order History TabSummary: I need query to extract these columns as mentioned in the screenshot. -
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent.
-
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. 30 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 1 view 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 51 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. 1 view 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 41 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
-
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 15 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 636 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for 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 13 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 108 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 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 3 views 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…
-
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 43 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
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…
-
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. Release: 25D…Ramamurthy Shankarachetty-Oracle 17.4K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
Are Sourcing Rules (Table MSC_SR_ASSIGNMENTS) available in BICC?Summary: Which is the right PVO / Dataset to use for this in BICC Offering setup? Content (please ensure you mask any confidential information): We need to extract Sourc…Frank.Steinjan 33 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for SCM
-
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…