OTBI
Discussion List
-
Emailing report based on field on data model?Summary Send report to destination based on field on DM?Content Hi. I'm working on a simple report to show the quantity on hand of items based on subinventory. Each subi…User_2025-02-07-06-48-26-537 29 views 3 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP -
Subject Area for BMP Workflows / How long to approveSummary Subject Area for BMP Workflows / How long to approveContent Is there a subject area for BMP workflow? I'm looking for a query to tell how long project related ap… -
Goals Report - Quarterly reviewSummary Unable to find columnsContent Hi, I've been asked to build a Goals report that contain the following fields that I cannot seem to find in any of the Goals Subjec…User_2025-02-05-22-44-35-842 34 views 0 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for ERP
-
Logo in OTBI AnalysisSummary Getting error when uploading images into OTBI analysis from local driveContent Hi All, I am getting below error when uploading logo image into an OTBI analysis u…Vinod Kumar Mohanraj 285 views 7 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
In what table is stored the transaction reference?Content Hi. Where is stored the inventory transaction reference accessed via the "Edit details" button in the "Create Subinventory Transfer" form? Thanks! Version Fusion…User_2025-02-07-06-48-26-537 31 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage … -
Procurement - Pending Change Order - Pending ApproverSummary Procurement - Pending Change Order - Pending ApproverContent Hello All, I am trying to get the the "Pending Approver" of a pending Change Order. Let me know if a… -
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…Nageshwaran1 98 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Drill Down from the Master to Detail via Action Link using case formula columnSummary I am trying to drill from the Master report to the detail report, I am fetching the count of rejected invoices with respect to each statusContent Dear Friends, M…SandeepPaspunuri 52 views 3 comments 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
OTBI Reporting reporting Invoice Summary + checking hold statusSummary Wanting to report on Invoice summary (outstanding, in progress etc) but need to be not on holdContent Hi I am using the Payables Invoices Transactions Real Time …RichardChan 63 views 2 comments 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?Summary An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard gene…
-
OTBI performance recommendations V2 paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 83 views 2 comments 5 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
OTBI Dashboard to Monitor AssessmentsSummary Includes deep drills to control and assessment records in Risk Cloud pagesContent This dashboard is useful for monitoring and acting on open assessments as well …Stephanie Golly-Oracle 69 views 0 comments 3 points Most recent by Stephanie Golly-Oracle Reporting and Analytics for ERP -
View Objects to get Invoice Headers and its Business Unit?Summary Need Invoice Header and Business Unit of those invoices.Content Hi. I'm working with VO extracts in Tableau. I'm using: fscmtopmodelam_finapinvtransactionsam_inv…User_2025-02-07-06-48-26-537 39 views 4 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T…
-
Spend calculations - Procure-To-Pay Subject AreasSummary How is Spend value calculated in Procure-To-Pay Subject AreasContent Gurus, Looking at seeded 'Top 10 Spend by Category' OTBI report and see Spend column. Wonder…Manoj Acc 48 views 1 comment 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 495 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP
-
Fixed Assets - Asset Balances Real TimeSummary Assets OTBI Report for CIP not showing balancesContent Hi FA Experts, We built an OTBI report with Fixed Assets - Balances Real Time Subject area to display bala…Muhammad Hamza Hanif 173 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
OTBI dashboard operators link to BI publisherSummary Can we use OTBI dashboard operators in BI Publisher sqlContent We are embedding SQL query based BI publisher report in OTBI dashboard. The OTBI dashboard has an …saravana maneeian subhramaniun 87 views 6 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP
-
Analytics / Dashboards to measure efficiencies from ERPSummary Tracking KPIs using Oracle Analytics to measure efficiencies from ERPContent Are you using any Oracle seeded reports / analytics / dashboards to measure KPIs / e…User_QZ639 55 views 2 comments 0 points Most recent by Sophie RUDENT Reporting and Analytics for ERP
-
PO_RELEASES table equivalent in Cloud 20A?Summary Looking for the equivalent table.Content Hi. A coworker needs the table that replaces the Oracle 10g PO_RELEASES in Cloud 20A. Looked the Supply Chain mapping an…User_2025-02-07-06-48-26-537 22 views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
Cannot show more than one field in Analytics.Summary If I try to use more than one field the data is not displayed. With admin privileged it worked.Content Hi. Recently I just got a proper personal account in our p…User_2025-02-07-06-48-26-537 29 views 7 comments 1 point Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
OTBI Report how to only have the last valueSummary I have a report for asset that have cost and Net book value, but i have all the different net book value instead of only having the last net book valueContent He…Francis Thériault 59 views 5 comments 0 points Most recent by Muhammad Hamza Hanif Reporting and Analytics for ERP -
Find parent value in CoA hierarchy for balancing segment in OTBIContent As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracl…MaartenDIF 133 views 8 comments 1 point Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from theSummary What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from the OTBI report.Content Hello Experts, I have followed https://ww…
-
Viewing pending scheduled reportSummary How to view the schedule details for a scheduled reportContent Followed steps from other posts to search in the "hierarchy" view of scheduled processes. I do not…Justin M Roth 32 views 2 comments 0 points Most recent by Justin M Roth Reporting and Analytics for ERP
-
Report completed in errorsSummary OTBI report completed in errorsContent Hi all, I have custom a OTBI report with data model and layout. Also, I have defined the ESS job in SaaS for user to submi…User_2025-02-04-05-26-22-197 37 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
ExternalReportWSSService -> runReport failing with error 415 Unsupported Media TypeContent I am trying to run a simple report from pl/sql using ExternalReportWSSService -> runReport and it is failing with error 415 Unsupported Media Type. The same payl…Murthy Kodavati 143 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP