OTBI
Discussion List
-
Ability to pull criteria used in OTBI reports using Bi Data ModelHi, Do we have possibility to pull the Criteria used in OTBI reports using bi data model? Example: We have 100+ OTBI reports created for Module Enrolment under Learn Fol…Boopathy Laxmipathi 21 views 2 comments 1 point Most recent by Konda Reddy A Reporting and Analytics for HCM -
Unable to Find "Placement Match Date" Field in OTBI - Workforce Management: Absence Real TimeWe're encountering an issue in Oracle Fusion HCM when reporting on Adoption Leave (Event Type: Placement) using the Workforce Management - Absence Real Time subject area…Minal Deshmukh-Oracle 1 view 0 comments 0 points Started by Minal Deshmukh-Oracle Reporting and Analytics for HCM -
Perform Lot Split, Merge, and Translate transactionsSummary: Perform Lot Split, Merge, and Translate transactions Content (required): Would like to understand how to perform Lot Merge / Split transaction through front end…Jayaharan Krishnamurthy 1.1K views 15 comments 0 points Most recent by Mangesh Shastri Inventory Management -
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 121 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM
-
Could you recommend vulnerability scanning tools for BIP, OTBI, and OIC (To Integrate with CI/CD)?Summary: Could you recommend vulnerability scanning tools for BIP, OTBI, and OIC that can be integrated with CI/CD pipelines? Content (please ensure you mask any confide…Kalyan_Duggineni 11 views 1 comment 0 points Most recent by Kumar -Oracle Product Master Data Management -
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co…LynneLBL 21 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is possible Learner User can view the approval stage in learning applicationSummary: When User requested for External or Internal or Catalog Learnings. Learners currently cannot see the approval chain and where a requested learning is waiting (i… -
CC wise expense report in OTBISummary: we have tried to create an OTBI report for the expense total with break down by Cost Center with GL but it not showing any break down sum we can get only total … -
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…User_2025-07-18-13-29-11-469 51 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI Analysis report not fetching value type as 'Text'Summary: How to fetch text based value in OTBI Analysis report. Content (please ensure you mask any confidential information): Developed an OTBI report to display suppli… -
Project Financial Analytics ReportsSummary: I'm able to navigate to this URL to look at the seeded Project Financial Analytics Reports. However, I'm not able to see the all column details to understand if…Raj Mohanraju FRNT 11 views 2 comments 0 points Most recent by Raj Mohanraju FRNT Project Management -
Supplier User Account last login historySummary: As part of monitoring and controls in our organization, we would like to have an audit of the last login date for the supplier user accounts registered in our s… -
Onboarding/Recruiting Employee Name fieldSummary: What is an alternative for updating the "Employee Name" in OTBI, where it displays First Name Last Name for Onboarding/Recruiting, and not change any of the exi… -
Scheduling analysis for last day of monthSummary: Analysis schedules for end of month Content (please ensure you mask any confidential information): Hi everyone, Is there a way to schedule reports (analysis) in… -
OTBI schedulingHello everyone, we need to schedule a report that needs to be sent to the client on the last day of the month for each month of the year. Currently the report is schedul… -
Users able to access OTBI without security rolesSummary: Users without who do not have security roles to access reports and analytics are able to bypass this by using the below URL https://FUSIONURL.COM/analytics Is t…Tara Samari-237472 41 views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to show Attachment Link in the ReportSummary Is there a way to show actual attachments link in a report whether in analysis or BIPContent Is there a way to report on actual attachment which was attached as …Prateek Parasar - GTUK, ACE Pro 1.4K views 25 comments 3 points Most recent by Neha_Naik004 Reporting and Analytics for HCM -
Employees with and without goalsSummary: Hello, I need help on this report. I need to show employees even if no goals. It used to show properly but now the report is only fetching the "with goals" stat… -
How to Find Table with Approver Details for General Ledger Lines.Summary I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this informatio…Dave Sherrard 592 views 9 comments 1 point Most recent by Deepak Kumar Dev-Oracle General Ledger & Intercompany -
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …Rory Mullin 165 views 5 comments 0 points Most recent by Alek Strader Payables, Payments & Cash Management -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …Abhishek Dixit-Oracle 271 views 7 comments 5 points Most recent by MMS Reporting and Analytics for HCM -
Compensation - Indvidual compensation real time not showing any detailsDespite of having the necessary roles I still don't have access to show data from this subject area I added everything from this document, Document 3052888.1 but still, …Joliver Caangay 21 views 4 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM -
How to know what AP invoice approval rule was triggered for a particular invoice?Summary: How to know what AP invoice approval rule was triggered for a particular invoice? Content (required): How to know what AP invoice approval rule was triggered fo…User_2025-03-10-23-59-44-230 1.1K views 5 comments 2 points Most recent by Prudhvi_S-Oracle Payables, Payments & Cash Management -
Goals Created or Not Created by Country CodeSummary: When I use the union report suggested by Oracle/the community forum the no of workers without goals is not returning enough workers Content (please ensure you m…LynneLBL 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can…Reddykrishna Chidella-Oracle 105 views 4 comments 1 point Most recent by Soumya Suravita Reporting and Analytics for HCM -
Some of the fields in the OTBI subject area are not populating valuesWe are trying to select "check number" from the OTBI subject area "Payables Payments - Disbursements Real Time" but the field results no values in it due to which the da… -
Employee Name ChangesSummary: Employee Name Changes Content (required): I'm trying to determine via OTBI the history of someone's name and their changes, but I don't see any values where I t… -
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in… -
OTBI missing journey tasksWhen creating an analysis to report on deferred journey tasks, I am not seeing ALL results. I am getting some, but there are definitely others that are seen in the UI, b…Jessica D 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM