OTBI
Discussion List
-
Select_physical * fromVO_nameSummary Select_physical only works on some VO'sContent Hi, Looking to expand the capability to search VO's using "Select_physical" on all VO's. "Select_physical * from V…
-
How to filter between Accounting Period Name in GL dashboard promptSummary How to filter between "Accounting Period Name" in GL dashboard promptContent Hi, I need to use "Accounting Period Name" in "General Ledger - Journals Real Time" …
-
How to set Default Rows Displayed In Download in OTBI reportContent I need to set DefaultRowsDisplayedInDownload as " 65000" for my OTBI report. Is there a way to do it ? Already referred some oracle docs but I could not able to …User_2025-01-28-21-18-43-496 79 views 5 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for ERP
-
Requester field blank on OTBI report from Procure to Pay Subject AreaSummary Requester field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, In R13, we built a OTBI report based on "Procure to Pay" subject area. But R…
-
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 482 views 14 comments 9 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Reporting on descriptive flexfields - BI Enabled checkbox not showingSummary Unable to use descriptive flexfield in OTBI - missing BI Enabled checkboxContent I need to create a new report using the Receivables - Customer Real Time subject…elenorh 168 views 2 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for ERP
-
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v…Achala Munasinghe 62 views 3 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP
-
Default "Account Period Name" value in OTBI Prompt while scheduling AgentsSummary Is there a way to default Period name on the OTBI Prompt while scheduling the Analysis from Agents?Content We have an OTBIE analysis "AP Transaction Report" that…GopiKAutomus 382 views 5 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP
-
How to update the New Analysis querySummary How to update the New Analysis queryContent How to update the New Analysis query from advanced tab with other operator functions/Group by functionUser_AEMC1 55 views 3 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for ERP
-
Report that shows Payables Invoice Approver name, Initiated by , Validated by valuesSummary We are trying to build a report in Payables that shows Invoice details along with Approver name, Initiated by, Validated by ValuesContent We are trying to build …
-
OTBI Reporting QuestionSummary Adding field, removes othersContent Hi, I am brand new to OTBI and am having issues adding a field to my Received Not Invoiced report I am attempting to build wi…
-
Add OTBI reports to Scheduled ProcessesSummary How to add OTBI reports to Scheduled ProcessesContent Hi, Can we add OTBI reports to Scheduled Processes rather than access them in Reports and Analytics?Lakmal 234 views 7 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for ERP
-
Custom Data Model - Remittance Advice - Change From Check to Wire Payments?Summary Custom report using SQL data model - How to change from check payments to wire payments?Content We have a custom report for AMEX remittance advice which gives us…
-
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…User_2025-01-29-02-09-34-137 59 views 1 comment 1 point Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Check Overflow check number in Fusion PayablesSummary Check Overflow check number in Fusion PayablesContent Hello All, Did any one build a report to get the list of Overflow Check number and Void Check numbers? if s…Srinivasa A-Oracle 99 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
Custom Enterprise Scheduler Job not showing to intended usersSummary Custom Enterprise Scheduler Job not showing to intended users while showing to othersContent Hi All, I have created a custom scheduler job using "Manage Custom E…
-
OTBI Custom Report SecuritySummary OTBI Custom Report SecurityContent Hi, We have problem with OTBI Custom Report Security , i create several otbi analysis and dashboard and prompt and put them al…User_2025-01-29-22-38-36-974 84 views 1 comment 1 point Most recent by Shakher Sharma Reporting and Analytics for ERP
-
After delete report folder Path not foundSummary After delete report Path not foundContent Hi, We have problem with OTBI Custom Report Security , i create several otbi analysis and dashboard and prompt and put …User_2025-01-29-22-38-36-974 27 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
Preparing a custom fixed asset reportSummary Custom report designContent Hi, I would like to create a custom fixed asset report.What data model should I select or create or how can I do that ?(BI Publisher,…Armagan Sahin-57534 201 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL Reporting and Analytics for ERP
-
Suppliers on Purchasing Hold by Supplier Type ReportSummary Dashboard Displaying Active Suppliers On Purchasing Hold By Supplier TypeContent This dashboard will allow you to retrieve a list of your active suppliers that h…Aishwarya Pawar-Oracle 126 views 2 comments 4 points Most recent by Aishwarya Pawar-Oracle Reporting and Analytics for ERP
-
How can we find roles/access needed for a subject areaSummary How can we find roles/access needed for a subject areaContent Hi All, We are on R12. Our OTBI subject areas (for FIN and PRC) are working only for some users and…
-
FA Retirement & Reinstatement SummarySummary How to Print Retirements and Reinstatements in the same OTBI reportContent Hi, We are trying to print FA Retirement details (Asset Cost, NBV, Gain Loss) and FA R…Sridevi Srikanth 35 views 0 comments 0 points Most recent by Sridevi Srikanth Reporting and Analytics for ERP
-
Addition of New Field withing Subject AreaSummary How to add new filed (proejct classification) within a particular subject areaContent We have created Project Classification such as "Accounting Business Objecti…User_2025-01-30-19-08-20-842 56 views 1 comment 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
I Cant find the Flexfield AR_CASH_RECEIPTS in OTBIContent Hi All, I did add Descriptive Flexfield to account receivable - Receipt Screen - under Additional Information ( global segment - Descriptive Flexfield name ( AR_…User_2025-01-29-22-38-36-974 82 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Cross Subject Area Search Missing in OTBISummary Recently the instance we are working on (R12) Lost the ability to "Add a Subject Area" for OTBI reportsContent When we try to create a New Analysis and choose a …Sridevi Srikanth 110 views 7 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP
-
OTBI Analysis merging columns when exporting to Excel 2010Summary OTBI has starting merging columns since R12 upgradeContent Hi Hopefully someone can help - since our recent R12 patch was applied, a number of our custom OTBI re…JennyB 143 views 2 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…User_2025-01-29-02-09-34-137 88 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Application Policy NameContent Hi, We are on Cloud R12. Oracle provides an audit report by name "User Role Membership Report". This report displays all the roles a user has in cloud. Is there …
-
Standard Financial DashboardsSummary Need to create some basic Financials Dashboards, which gives a clarity over Company Financial HealthContent Hi All, I have implemented Oracle Financials Cloud fo…User_2025-01-29-20-34-14-699 157 views 2 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for ERP
-
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleSummary After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleContent After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry…