Popular Tags
- OTBI 1,450
- Reporting 1,395
- FDI 1,130
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 592
- Administration 555
- OAC 463
- OBIEE 433
- Analytics 406
- BI Publisher Data Models 357
- Security 294
- HCM 270
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Oracle Analytics Cloud 201
- Fusion Data Intelligence 192
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI (Oracle Transactional Business Intelligence)
Discussion List
-
10Oracle Fusion OTBI (Transactional BI) and BI Publisher - Integrated Git Version ControlCurrently, Oracle Fusion OTBI (Transactional BI) and BI Publisher lack a native version control system or DevOps pipeline integration. To promote analytics content (repo…RVohra 82 views 2 comments 10 points Most recent by IteSel Oracle Transactional Business Intelligence Idea Lab -
How do I show 1 row per employee based on ranked address typeSome employees have multiple address types on file. I am trying to show 1 row per employee based on address type. I want it show home address (address rank 1) but if non…Riti Malhotra 64 views 8 comments 0 points Most recent by Riti Malhotra Oracle Transactional Business Intelligence -
Status field for Employment Contracts (Oracle HCM)Hello experts, we are creating an OTBI report with the Employment Contracts Real Time subject area and we have seen that it is available the fields Status and Status cod…Oriana L. 14 views 1 comment 0 points Most recent by RVohra Oracle Transactional Business Intelligence
-
What privilege grants access to data in the Purchase Order Measures folder columns?I have a user who is trying to use columns from the Purchase Order Measures folder in the Procurement - Procure to Pay Real Time subject area. I've created a custom role…Selene Becerra 17 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Backend tables to get if an approver added manually and then gets removed from the approval workflowWe have a requirement to create a report that will allow to see if an approver that is added manually gets removed from the approval workflow. We cannot see that approve…
-
2Inventory related Subject area need to include inter/intraclass conversion valuesOTBI dashboard is being developed for CSRs to view the avaialbility of items in different UOMs. UOM conversions exist in the application and OTBI Subject area is bringin…Dan.C 15 views 0 comments 2 points Started by Dan.C Oracle Transactional Business Intelligence Idea Lab
-
Workforce Mgmt - Areas of Responsibility does not extract Responsibility Type linked to RecruitmentGood morning We have an OTBI report built using the subject area: Workforce Management - Areas of Responsibility with the following fields: Person Number Display Name Re…
-
How to fetch the lookup codes and lookup Types created in Fusion HCM into OTBI reportHello All, we are using a OTBI analysis (Subject Area - Workforce Learning - Learning Records Real Time) to fetch the Learning Records for a few particular courses. so, …KarthikDamamkar 140 views 8 comments 0 points Most recent by Abhisek Choudhury Oracle Transactional Business Intelligence
-
How to get industry name from receivables in otbi(receivables-customer real time)Hi we are joining two subject areas receivables-customer real time and receivables-transactions real time through (bill to customer number and organization number), we a…Ani_tha 18 views 3 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence
-
How do I validate the data across different FDI HCM subject Areas ?Visualizations/KPI's Workers with Absences Absence Days Absence Hours Absences Days by Type Absence Days by Legal Employer Absence Details Approved Absences Pending Appr… -
Link between 2 subject areslink between CRM interactions real time and order management - order headers real time CRM interactions real time and Receivables transactions real timeAni_tha 39 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
7Add ability to change color coding on custom Dashboard pie graph to something other than alphabeticWe have a custom ERP Dashboard that captures ESS jobs - Currently it captures the Status' of Error, Running and Succeeded for ESS Job Names. The issue occurs when one se…Dawn Watson 38 views 4 comments 7 points Most recent by Andrew Mc Oracle Transactional Business Intelligence Idea Lab -
Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…Anick B Augustin_SAMC 194 views 22 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence
-
Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…Anick B Augustin_SAMC 6 views 0 comments 0 points Started by Anick B Augustin_SAMC Oracle Transactional Business Intelligence
-
Sick absence duration sum issueHello, I'm trying to produce an analysis showing total days lost to sickness per quarter for each department. I'm working in the Workforce Management - Absence Real Time…SarahDonoghue 12 views 0 comments 0 points Started by SarahDonoghue Oracle Transactional Business Intelligence
-
Is there a field in OTBI to tell if a Receipt was created in Redwood vs Classic page?Im looking for a field in OTBI that I can use to develop a report to identify if a Receipt was created in the new Redwood Expected Shipments Lines page vs the Classic Re…Nathan Tiede 13 views 1 comment 0 points Most recent by Nathan Tiede Oracle Transactional Business Intelligence -
Issue on exporting entire dashboardI’m currently experiencing an issue when trying to export the entire dashboard to Excel. The export function only allows a maximum of 500 records to be displayed and exp…User_FO8AR 27 views 2 comments 0 points Most recent by User_FO8AR Oracle Transactional Business Intelligence
-
1Need new attributes to be included in OTBI subject areasHi Team, We are looking out for the following additional attributes to be included in OTBI subject areas 1.- Enterprise Contracts Subject Area i. First signed version fl…Sathish Srinivasa-Oracle 4 views 0 comments 1 point Started by Sathish Srinivasa-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing PageSummary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited …Santiago Sánchez R.-Oracle 41 views 0 comments 0 points Started by Santiago Sánchez R.-Oracle Oracle Transactional Business Intelligence
-
How to Automatically Refresh Dashboard in OTBI?Hi Gurus, We have an operational dashboard build which is displayed on the Production Floor. Is there a way to make it auto-refresh. We have observed that user need to a…Amrish_Amradkar 73 views 4 comments 1 point Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence