OTBI
Discussion List
-
Rehire recommendation details are inconsistent in OTBI reportSummary: Need help with fetching data for Rehire Recommendation for terminated employees Content (please ensure you mask any confidential information): Hi, We have an OT…Sai.V 111 views 22 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM -
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by…
-
SQL Query to get Value Set ListSummary SQL Query to get Value Set ListContent Hi Team, Could you share me any BI/SQL query to fetch the all list of Value sets using in HCM Instance like Dependent, Ind…User_2025-01-29-00-33-34-534 3.6K views 4 comments 0 points Most recent by Swarna Mahadevan Reporting and Analytics for HCM -
Filter query using NVL not workingSummary Unable to save query when trying to use the NVL command with a logical sqlContent Hi All, I hope someone is able to help me with an issue that I am having. I hav…User_2025-02-04-08-51-08-912 87 views 10 comments 0 points Most recent by Tharuka Reporting and Analytics for HCM
-
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Most recent date paidSummary: I have an OTBI report that runs every other Thursday pulling earnings. The Effective Date field uses the below advanced SQL filter to pull only the current date…
-
how to create ORC otbi hires based on nationalitySummary: We have requirement to create otbi report for hired list based on nationality in ORC module. Content (please ensure you mask any confidential information): Vers…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to report on workers with termination date in last two monthsSummary: Content (required): I'd be grateful for some help with a filter on an OTBI report. The report is quite basic, showing employee name, person number, position, lo…Leanne W 818 views 7 comments 0 points Most recent by anusha chunduru Reporting and Analytics for HCM
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Employee / Employer Pension Contribution Report for a specific durationSummary Employee / Employer Pension Contribution Report for a specific durationContent Hi, May I check if anyone has any OTBI / BIP report for Employee / Employer Pensio… -
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…Welsey 113 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Position Costing with Incumbent ReportSummary: Does anyone have a report that includes both Position costing, with position number, and the position incumbent. We don't have the skills on the team to build a…Jenna Savage 143 views 9 comments 0 points Most recent by Jenna Savage Reporting and Analytics for HCM -
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Management Levels on OTBISummary: We have Management Levels defined on Job definitions. (Screen shot attached). For a person we would need to capture the management levels against the job on the…Vibha Pandey - Oracle 52 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…E McDonald 54 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…Tina T 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 107 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
OTBI Report is not giving actual Absense start date and absence date insted it is giving Date StartSummary We developed a OTBI Report to get the Absence details using the subject area Workforce Management - Absence Real Time subject area.To get the absence start date …User_2025-01-30-17-37-30-647 68 views 2 comments 0 points Most recent by Neha H Sharma Reporting and Analytics for HCM
-
Is it possible to hide unnecessary buttons from OTBI Dashboard?Summary Is it possible to hide unnecessary buttons from OTBI Dashboard?Content I designed an OTBI dashboard, which when I run shows OTBI Header buttons and search option…Dharmendra Shukla 70 views 10 comments 2 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Trying to pull Comments from Mid-Year Performance document into a reportSummary When Employee/Manager Comments fields are added to performance report, errors outContent I have a request to pull a report of all Goals and include the Employee …User_2025-01-28-20-43-56-568 60 views 4 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
-
DOR Report: How would I create a report that allows me to see DOR data by employee?I am trying to build a report that shows the following information for Document of Records, but the fields I add show no data. Would it be possible to know which fields …Jay_Brannan 87 views 11 comments 0 points Most recent by Jay_Brannan Reporting and Analytics for HCM
-
Is it possible to add candidate Hire date using OTBISummary: We have a requirement to include hire date in the report. The intention of the report is to capture all offers that are created, even if they don't end in hire.…Christina Roy 10 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Field to report the "Last Hire date"Summary Field to report the "Last Hire date"Content What is the field present in OTBI to report Last hire date. We are looking for the Field to populate Hire date if the…Prabhu Krishnamoorthy 341 views 3 comments 0 points Most recent by Gunjan Bobade Reporting and Analytics for HCM -
concatenate error in otbi reportSummary: CONCAT(NVL(TO_CHAR("Worker"."days"), '0'), ' Days, ', NVL(TO_CHAR("Worker"."months"), '0'), ' Months, ', NVL(TO_CHAR("Worker"."year"), '0'), ' Years') i tried t…
-
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 21 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI report only showing an individual's supervisor and managerSummary: I have a requirement to create a report showing each workers named supervisor and line manager (mostly these are the same person, but in some cases they're diff…Rich M 42 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …