OTBI
Discussion List
-
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 51 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 38 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 488 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 172 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 54 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 28 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 142 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
What View Object uses GL_DAILY_RATES in 20A?Summary I need a VO that uses the data in that table to export via BIACC.Content Hi. I need to export the daily currency rates my company loads in Oracle. I checked the …User_2025-02-07-06-48-26-537 39 views 5 comments 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for ERP
-
How to remove html tags from report outputContent Hi team, We built some Analysis based on Sourcing related subject area's Where we see some html texts in the resulting columns like below. How remove these sufix…Nishanth B Jain 134 views 5 comments 0 points Most recent by Anandakrishna Thamballa Reporting and Analytics for ERP -
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,