Category 174-2
Discussion List
-
Operation Status columnSummary: Operation Status column Content (please ensure you mask any confidential information): Hi, On which Manufacturing subject area I can find operation status (Read… -
Completed Quantity in One columnSummary: Completed Quantity in One column Content (please ensure you mask any confidential information): Hi, We have a requirement to add an completed quantity of work o…
-
Context PO DFF does not appear in OTBI - PO real time subject areaSummary: We have a context DFF at the PO Header, and I am unable to see those DFF's in the OTBI Report (Procurement- PO Real Time). Is there any way to allow the OTBI so…diego m schenquerman 5 views 0 comments 0 points Started by diego m schenquerman Reporting and Analytics for SCM
-
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…
-
Adding Pending Approver to a ReportWe need to add the next approver to a Report. We are unable derive the next approver (to whom the requisition is not yet assigned for approval) for requisitions which ar…
-
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 561 views 3 comments 0 points Most recent by Mirza_Adeel 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…
-
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… -
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
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 14 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 589 views 5 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …
-
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…
-
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…
-
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…
-
Not able fetch data from Catalog Category Hierarchy using OTBISummary: Not able fetch data from Catalog Category Hierarchy using OTBI Content (please ensure you mask any confidential information): We are not able to fetch the data …Harish Vashist 23 views 7 comments 0 points Most recent by Swathikamburath 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…
-
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 44 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: 25B…Ramamurthy Shankarachetty-Oracle 16.9K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
Change order that is cancelled is still counting as a change orderSummary: Change order that is cancelled is still counting as a change order. Is this is the standard Oracle functionality. If we cancel the change order and create new o…
-
Column for reject/return reason for PO/ Requisition in OTBI Subject AreasSummary: Column for reject/return reason for PO/ Requisition in OTBI Subject Areas Content (please ensure you mask any confidential information): Hi Team, We are searchi…Nidhi Chhajed 3 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas… -
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…
-
How can I use the item keyword as a parameter in a BI Publisher reportSummary: I want to allow users to search the BI Publisher report by any word within the item description. Currently, the parameter for item description limits LOV to 30 …