OTBI
Discussion List
-
Completion Certificate DefaultsSummary: Is it possible to create various types of certificates so that each course has its own individualized certificate? I don't see a way for us to associate a uniqu… -
Where in OTBI subject areas can I find the actual start date of an assignment?Summary When trying to find the start date of an assignment, I can only find all actions related to the assignment. How to show only the actual starting date of the assi…Matti Bugge 664 views 6 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Repeating RowsSummary: I am creating a report that will show job requisitions, the candidates who applied along with their education and previous employment information. Due to multip…UserAA_2026 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 121 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM -
Possibility to do Gross Pay in OTBIContent I am working on a report to show gross pay and specific imputed earnings during a specific date range divided by pay dates. I am attempting this report with Orac…User_2025-02-10-19-21-48-801 135 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report for Performance Document Question ResponsesSummary Report for Performance Document Question ResponsesContent I have created a performance document with only a questionnaire section. I am trying to build an OTBI r…User_2025-01-22-19-28-29-985 235 views 21 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…Patrick Scally 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…Ankush_Jadhav 11 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
Average salary by compensation zone (getting sum instead of average)Summary: I am trying to create a report that will show Minimum, Average and Max salary for each compensation zone (Market A,B,C,D) using Compensation - Salary Details Re…Ameya_J 41 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to find the Purchase Requisition (PR) based on projects in the approvers User accountSummary: The business wants to see the requisition and the status (Approved, rejected) based on the project filter and approver person further to see the relevant requis…
-
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dynamic Date parameter in OTBISummary: I have a requirement to get output depending on date parameter user will provide from prompt . how can i achieve this in OTBI report Content (required): Version…Sudipta007 592 views 8 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to pull only one field for Person Legislative Information > CountrySummary: I am attempting to pull an employee file that includes which country an employee lives in. I am using the subject area "Workforce Management - Person Real Time"…joshvanlaan 21 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Table to fetch HCM Extract name and delivery optionsHi Team, Please let us know the tables required to fetch submitted extracts and its status in fusion HCM. Thanks, Jahanavijahanavi metta 201 views 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
-
Migrated AR report returning an error which has DFFsSummary: I have migrated 3 AR OTBI reports from one instance to another and earlier I was not able to find those DFFs in OTBI though it was configured but post running t…Rahul Kumar Gupta.-Oracle 1 view 0 comments 0 points Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…
-
Records for Cancel Workrelationship and Reverse Termination scenarios in new subject area in 24AIn 24A , oracle have introduced new subject area - Assignment Action Occurrence Real Time , allows you to report on all HR Actions and reasons associated with the worker…Manisha Singh 251 views 31 comments 0 points Most recent by Melissa Shropshire Reporting and Analytics for HCM
-
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…Henry Imgrund 81 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP
-
How to combine multiple max formula criteria in OTBISummary: I'm having trouble pulling in all employees latest Seniority Dates. It seems I need to pull in 2 criteria: 1. LATEST Seniority Change Start Date & LATEST Senior…
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…alliebaker 53 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
SQL with statement window function errorHello! I am trying to run a window function to rank the rows in order to remove any duplicates (code below). I am getting the error "ORA-00923: FROM keyword not found wh…alliebaker 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
24B - reporting on offering enrollment questionnaires / evaluationsSummary: To ask: Will evaluation etc. questionnaires have to be recreated, or is this just to do with reporting? Does it affect assessment questionnaires as well? Conten…
-
Personal Payment Method HistorySummary How to find out if the Employee has Added, Updated or Deleted a Payment Method?Content Hi All, I am trying to build a Personal Payment Method History Report in w…User_2025-01-31-02-00-10-435 153 views 8 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
We need to create one OTBI analysis to display current and previous year calendar for Learning.Summary: We need to create one OTBI analysis to display current and previous year calendar for Learning . How can we achieve this? Content (please ensure you mask any co…Piyal Basak 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
-
Which areas are affected when time zone is changed in the Manage Inventory Organization parametersWhich areas in the oracle fusion cloud are affected when time zone is changed in the Manage Inventory Organization parameters
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Redwood - See all Email Interactions in a ReportAs an admin or sales manager, I want the ability to see all activities logged for customers. Prior to Redwood, an Activity Report could be leverage to see all activities…Amanda McAfee 61 views 14 comments 0 points Most recent by Amanda McAfee Reporting & Analytics for Sales