OTBI
Discussion List
-
Getting error while downloading larger amount of data in BI ReportSummary: We have observed one issue in BI Report wherein while extracting the report output, it only shows total 74701 number of records. After that it shows error as Ex…Anurag Gandhi 1 view 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for SCM -
Data not showing albeit correct rolesSummary: Data is not showing whilst creating an OTBI analysis Content (required): Data is not showing whilst creating an OTBI analysis for the Unit Cost Dimension althou…
-
What is a "Perfect Invoice" in Oracle terms?Summary: In the subject area "Procurement - Spend Real Time" there is a measure called "“# of Perfect Invoices". Content (required): In the subject area "Procurement - S…Anders W. Langholm 1 view 1 comment 0 points Most recent by Anders W. Langholm Reporting and Analytics for SCM -
Report needed for department inforSummary: PO charges and inventory report request Content (required): I need to build a report that can provide departments the PO charges and inventory charges with the …
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
SCM roles to create OTBI reportSummary list of roles is requiredContent Hi All, Kindly, I want to use OTBI to create reports specifically in SCM. I need the list of roles that facilitate this kind of …Morad Alshammari 7 views 5 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Unable to link Order Fulfillment and Item Cross Reference Subject AreasSummary Unable to link Order Fulfillment and Item Cross Reference Subject AreasContent Hi, Are there any documentation to identify what join is missing when we try to re…Shifa Nazumudeen 3 views 1 comment 0 points Most recent by Shifa Nazumudeen Reporting and Analytics for SCM -
Unable to access or capture Database prompt value (From Date and To Date) in variable to use in anaSummary In AP, invoice count need to be calculated based on consecutive dates between from date and to date (input from dashboard prompt). It is pivot table where we cal…
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 59 views 6 comments 4 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…Harish Gundre 13 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
Is there a way to restrict BI Admin role user to Query only Supply Planning related tables to buildSummary BI Admin - Role restriction per moduleContent We are already live with HCM and implementing Planning modules. When a user having only supply chain roles get BI A…Ramkumar Sethuramalingam 16 views 2 comments 0 points Most recent by Ramkumar Sethuramalingam Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 186 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 68 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 23 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …Sushan Peiris 381 views 1 comment 2 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…Rohit Kumar-266502 98 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 31 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Extract current and historical data from Oracle Engagement Cloud (EC) backend tableContent As part of one of the analysis, I am trying to extract current and historical data from Oracle Engagement Cloud (EC) backend table and load it into ADW using ODI…
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 20 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…Murielle Manambelona-Oracle 16 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
OTBI - Product Management - Cross Subject Area Logical SQL giving ErrorSummary OTBI - Product Management - Cross Subject Area Logical SQL giving Error 'The selected request cannot be performed because it references an unknown subject area n…
-
Presentation Variable working from one analysis and when I call the same analysis from other analysiSummary Action link presentation variable working for 1 analysis and does not for anotherContent I have created two analysis 1. XXVS Analysis 1.. In this I have created …
-
Suing ASBN on In Transit OTBI ReportSummary a)ASBN with 1 line received , 1 not disappear from In Transit report b) Possibility to add Received Quantity (Receiving In-Transit Advance Shipment Not. Real Tim…Bernd Borstelmann-203269 4 views 0 comments 0 points Started by Bernd Borstelmann-203269 Reporting and Analytics for SCM
-
Out of the box Sales and GP reportContent My client is looking if there is a seeded out of the box Sales report that shows the daily sales and Gross profit. The closest i see is the Sales Order document …Hari Thyagaraj 8 views 0 comments 0 points Started by Hari Thyagaraj Reporting and Analytics for SCM
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…
-
Costing - Item Cost Real Time - Cost-As Of dateContent Hi, Is there some way to in BA Costing - Item Cost Real Time for the Cost-As Of date include also HH:MM:SS? like "Transaction Date" in the BA Inventory Transacti…Elisa Ortiz Rincon 17 views 0 comments 0 points Started by Elisa Ortiz Rincon Reporting and Analytics for SCM -
Does anyone know if there is a Report to track the unused items in our Warehouse?Summary We need to get rid of unused products and can't find a report for unused items (or for used items turnover)Content Is there a standard turnover report for Invent… -
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…Helen Thomas 23 views 2 comments 3 points Most recent by Helen Thomas Reporting and Analytics for SCM