OTBI
Discussion List
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 430 views 11 comments 10 points Most recent by SankarBalu Reporting and Analytics for ERP -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 1.1K views 13 comments 21 points Most recent by SankarBalu Reporting and Analytics for ERP -
OTBI Analysis - General Ledger - Journal Real Time : No output after MigrationHi, I have migrated OTBI report to one of the demo environment but I am not getting any data in the output. There are no filters in the report and I have validated that …Karun_Jain-Oracle 9 views 1 comment 0 points Most recent by Karun_Jain-Oracle Reporting and Analytics for ERP -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 2.7K views 26 comments 29 points Most recent by Rizwan Basha Reporting and Analytics for ERP
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 6.5K views 149 comments 44 points Most recent by Bob Sheldon-Oracle Reporting and Analytics for ERP -
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…Jacqueline Fournier 169 views 6 comments 1 point Most recent by Tim Sweeney-279789 Reporting and Analytics for ERP
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…
-
Schedule in Analytics is Greyed-OutSummary: The Schedule button is Greyed-out Content (please ensure you mask any confidential information): Please help! Version (include the version you are using, if app…Dorren Veil Laniog 19 views 2 comments 0 points Most recent by Dorren Veil Laniog Reporting and Analytics for ERP -
Replacing Project attribute with Organization name causes severe performance issueSummary: We enabled Project DFF and included the attribute as a filter as organization name in OTBI. The report runs normal if we filter for specific orgs but when submi…
-
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 32 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 25 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP -
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 26 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 34 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 148 views 11 comments 0 points Most recent by ashtrakhov-Oracle Reporting and Analytics for ERP
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second… -
OTBI Incremental Date Parameter ValuesHi, We have a requirement to run the Payables Invoice Register OTBI report with incremental date parameters. We would like to schedule the Payables Invoice Register OTBI…
-
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …SSS Song 71 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
Does OTBI Scheduler return report in non-English?Summary: When we run OTBI in UI, it returns a report with all the colums in Japanese as we set the language preference to Japanese. However, when OTBI scheduler runs, th…CHIZURU SHIGA 16 views 4 comments 0 points Most recent by CHIZURU SHIGA Reporting and Analytics for ERP
-
General Ledger - Balance Real Time OTBI Report IssueSummary: We have used below columns in the report, it is not giving the data with below combination. "Natural Account Segment"."Natural Account Segment Code" "Natural Ac…FirozahamedSK 25 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 35 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Include a row when column null in out of the box analysisI would like to use an analysis in OTBI but include the data when a column has a null value. What happens now is when I add the column and that column is null, the resul…erp_expert03 13 views 2 comments 0 points Most recent by erp_expert03 Reporting and Analytics for ERP -
OTBI - Can we have one line per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 23 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 27 views 1 comment 1 point Most recent by Ayyappa-Oracle Reporting and Analytics for ERP
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
CASE WHEN Formula Not Displaying CorrectlySummary: CASE WHEN STATEMENT shows two different results pending the format export Content (required): I'm using the following CASE WHEN statement to label a value eithe…
-
API Options/Capabilities/Limitations for Cloud/ERP BIP/OTBI ReportsSummary: There have been many posts regarding this topic over the past 3 years and I'm looking for an understanding of API Options/Capabilities/Limitations for BIP/OTBI …
-
Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.Summary: Greetings, i need some help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM. Content (please ensure you mask any confidential inform…Erick Schuenck 23 views 0 comments 0 points Started by Erick Schuenck Reporting and Analytics for ERP