OTBI
Discussion List
-
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…Mansi1302 923 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 59 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…Tasha Kretlow-Oracle 111 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI users are able to edit the report when they have only Read permissionSummary: OTBI users are able to edit the report when they have only Read permission Content (please ensure you mask any confidential information): Version (include the v…Pablo Schenquerman 34 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba…User_2025-02-06-06-17-13-684 114 views 4 comments 3 points Most recent by Andres Hernandez Suarez Reporting and Analytics for ERP -
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…Prathyusha pari 116 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very badSummary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to. There is same … -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 422 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP
-
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
Inactive User Report - Is it possible to see this in OTBI?Inactive User Report - Apart from the scheduled process, the report can be seen. Is it also possible to see this in OTBI? If yes, where is the path name?
-
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 32 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a…
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 515 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 188 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…Erik Bjerkelund 92 views 2 comments 0 points Most recent by Erik Bjerkelund Reporting and Analytics for ERP
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 1K views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
FUSIONAPPSS_REQUEST_IDSummary: I'm trying to modify the ChartOfAccounts report in order to add new filters to the query, but as soon as I add the parameter :fusionapps_request__id the DM stop…Victor Bocardo Negrete 5 views 0 comments 0 points Started by Victor Bocardo Negrete BI Publisher Learning Center
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …Edlyn Almanzar 513 views 7 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …Mike.Myers.CDIPRODUCTS.COM 234 views 1 comment 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for ERP
-
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…Ajeez K-Oracle 22 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 290 views 18 comments 0 points Most recent by Mayur_P Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 516 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP
-
Can I have a link for data lineage for 24 A versionSummary: Can I have a link for data lineage for 24 A version Content (please ensure you mask any confidential information): Version (include the version you are using, i…Prateek Dhawan 36 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
ZIP and PDF inquiries for Oracle BIPSummary: 1. We are trying to create bursting email which sends 1 zip with multiple pdf(separated by invoice). 2. In history we have a consolidated output which has 1 zip…
-
OTBI report is taking very long time to complete.I have built one Payroll OTBI report. I have been able to run it successfully from my private folder in the Prod environment, but when we load it to the Payroll Team fol…Chetana Pawar 340 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
Not able to create analysis report while using a enquiry role.We need to grant users an "enquiry" role, which allows them to create analysis reports but restricts them from editing pre-existing reports. As we have added all the ana…