OTBI
Discussion List
-
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 814 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 111 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 141 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…user9020833 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 106 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 59 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 82 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 9 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 339 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 41 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 - …
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Direct and indirect reports in dashboard promptHi There, We have designed a custom dashboard with is using the subject area Workforce Management - Checklist Real Time. We have a requirement to display direct and indi…MadanMohan 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 92 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 61 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Specialization Title and Number in OTBI Learning ModuleHi Can you please tell me where can i can able to get the Specialization Title and Specialization Number in the Learning Module of OTBI (Workforce Learning - Learning Re…Shivam_123 81 views 7 comments 0 points Most recent by David Bean - BW Reporting and Analytics for HCM
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c…Hi.itsa.me 95 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM