OTBI
Discussion List
-
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 443 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 164 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 44 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 741 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 1 view 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 102 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 92 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 21 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…Franz Marcelo 148 views 2 comments 1 point Most recent by Franz Marcelo 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 283 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 386 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…Gamal 44 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle 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 31 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 111 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…
-
User should be able to create a new OTBI Report(Analysis) but will not be able to edit the existing.Our requirement: We need to create a custom role in which a user should be able to create OTBI Reports by using subject area "Procurement- Procure To Pay Real Time" but …
-
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks… -
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i…
-
Financials Cloud OTBI Release 12: 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…Anand DN-Oracle 394 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Summary Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Content Is it possible to run BI Publisher reports from excel ( Oracle ERP Cloud SAAS ) ? if so then…Shlomo Elnekave 58 views 4 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for ERP -
Is it possible to grant access to a subject area from Administration/Security/Manage Privileges?Summary: If I want to grant access to all employees to one certain subject area (that really has no harmful or sensitive data 😄), is it then possible to give them access…Anders W. Langholm 45 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI how to assign roleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Somchat Wattanaponwadee-185289 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Risk Management Access Violations by User ReportSummary A dashboard displaying top 10 users with control violations. Below this is a detailed view by role for a specified control and user showing the conflicting acces…Stephanie Golly-Oracle 117 views 2 comments 1 point Most recent by Uma Maheswari Reporting and Analytics for ERP -
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 73 views 3 comments 1 point Most recent by Renganathan V Reporting and Analytics for ERP