OBI Answers
Discussion List
-
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 423 views 14 comments 9 points Most recent by Koteswararao Yenikepalli 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 51 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 114 views 5 comments 0 points Most recent by User_AEMC1 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… -
What table joins required to link PO Receipts to GL lines in Data Model?Summary Need to Extract GL lines with PO Receipt details, PO Number with Data ModelContent Hello, We are trying to create a custom GL Report that will show subledger det…user6675104 100 views 2 comments 0 points Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP -
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…Abdalaziz Barham 74 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 …Abdalaziz Barham 17 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
BI Analysis and/or Report for Specific Fiscal Year per Specific Account CodeContent I am needing to prepare either a report and/or analysis to show all purchase orders from a specific account code over a specific time period (ex: FY16). I have z…Brad Stefanoni 32 views 1 comment 0 points Most recent by User578443-Oracle 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 120 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL 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_…Abdalaziz Barham 62 views 3 comments 0 points Most recent by ashtrakhov-Oracle 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…Doron de Jong-57089 43 views 1 comment 0 points Most recent by Aaron Leggett 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… -
R13 Risk Management OTBI subject area Description documentationSummary R13 Risk Management OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides users a…User720640-Oracle 69 views 1 comment 5 points Most recent by Youssouf Reporting and Analytics for ERP
-
Data mapping for Oracle Business Intelligence Cloud Connector ConsoleSummary Mapping details for file extracts offerings from 'Oracle Business Intelligence Cloud Connector Console' and BI Apps Tables.Content We get 'Oracle Business Intell…Senthilrajan V 88 views 1 comment 0 points Most recent by Rohan Lobo-Oracle Reporting and Analytics for ERP -
Uk compliant VAT report in r12Content All,We are trying to find a uk compliant report or processes/white paper that we can use to run our vat returns from, are you please able to point me in the righ…Doron de Jong-57089 20 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Financial OTBI Index ColumnsSummary This workbook documents index columns in R13.17D Financials OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use d…User720640-Oracle 80 views 2 comments 5 points Most recent by rajArun Reporting and Analytics for ERP
-
Fusion R12 Upgrade -BI | Icons appearing as dots ( . )Summary After upgrading to R12 Fusion, the BI icons like "Add" (+) and "Delete"(x) are appearing as dots (.)Content After upgrading to R12 fuion, the icons like "Add" (+…
-
Customizing a standard reportSummary Customize option is not visibleContent Hi, I'm trying to customize "General Ledger Trial Balance Report ".I want to copy and save it under my custom folder for e…Armagan Sahin-57534 82 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Running an uploaded .RTF reportSummary Edited report cannot be run in the financial reporting centerContent Hi, I've downloaded a standard trial balance report and edited it.But when I try to run it I…Armagan Sahin-57534 26 views 1 comment 2 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Group Project Tasks by Task NameSummary Group Project Tasks by Task NameContent We have a standardized work breakdown structure and would like to compare costs for the same task across projects, right …Prasanna Reka-OC 29 views 0 comments 0 points Started by Prasanna Reka-OC Reporting and Analytics for ERP -
What happened to OTBI Web Query(iqy)Summary What happened to OTBI Web Query(iqy)Content In older releases if we edit analysis and go to advanced tab we used to have option to download Web Query (iqy) for t…Prasanna Reka-OC 34 views 0 comments 0 points Started by Prasanna Reka-OC Reporting and Analytics for ERP
-
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle).Content This note provides information about Fusion OTBI R12 PB10 (…User720640-Oracle 56 views 0 comments 0 points Started by User720640-Oracle Reporting and Analytics for ERP
-
Subject Areas and Roles - R12Content Can anyone point me in the direction of some documentation which shows which Roles can access which Subject Areas across ERP for Fusion R12? Thanks Dean WillifordDean Williford 58 views 4 comments 0 points Most recent by Venkateswarlu Yenuganti-23335 Reporting and Analytics for ERP
-
How to change the Costs Column for periodsSummary How to change the Costs Column for periodsContent Hi, I have a requirement to show the Budget and Actual costs with figures for month on month basis. So kindly g…User_AEMC1 22 views 6 comments 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
How to make the Graph OTBI ReportSummary How to make the Graph OTBI Report with feature drill down to applicationContent Hi, We have require to prepare the OTBI graph report with the feature drill down …
-
Project Portfolio Management Cloud OTBI Release 13: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Rohan Lobo-Oracle 123 views 0 comments 3 points Started by Rohan Lobo-Oracle Reporting and Analytics for ERP
-
Fill group by data in Group by columns and sub totals in a BI Publisher reportSummary Fill group by data in Group by columns and sub totals in a BI Publisher reportContent Current Output 1. Group by column data is merged 2. Group by column data is…Sachin Mistry, CFA, PMP 47 views 2 comments 2 points Most recent by Sachin Mistry, CFA, PMP Reporting and Analytics for ERP
-
Trading Community Model DFFs (Eg, HZ_PERSOn_PRFILES) not visibile in OTBISummary DFFs that were enabled for the respective regions under Trading community Model module are not visible in OTBIContent We have some DFFs defined under some of the…