Category 81
Discussion List
-
Work Relationship Last Update Date vs Current DateSummary: Hello - we are trying to create a Termination report that will be scheduled to run daily with the condition that the termination date equals Current Date OR the…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Error when using different subject areas in OTBI: Odbc driver returned an error (SQLExecDirectW)When I am trying to use different subject areas (Workforce Management-Checklist real time and Recruiting Real time), I am getting the below error in the Results. Odbc dr…Mohit-Sinha 52 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…Ashutosh12 22 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 71 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display URL or attachment in OTBISummary: After adding attachment url from subject area facing this error Content (required): Health and Safety module Version (include the version you are using, if appl…Surya -Oracle 148 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 746 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 683 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 490 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report for Performance DocumentSummary: Hi Folks, I would like to access a report that will display any 'transferred' performance documents within the Performance System. We would also like to filter …Sowmiya Velusamy 43 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 66 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM -
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can…
-
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 22 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Unable to find the USER_GUID for few employees in ASE_PWD_RESET_REQ tableSummary: Hi All, We have a report which we send to the new hired employee. In the email, we are sending the password reset link as well. For some of the employees the da…Peeyush Chandel 26 views 0 comments 0 points Started by Peeyush Chandel Reporting and Analytics for HCM -
Time to complete self-paced learningSummary: Is there a way to report on the time taken from launching a piece of self paces learning to the point it is finished? We have a lot of compliance offerings whic…Elizabeth Docherty 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I display talent information with job, salary informationSummary: I need to pull current job code and title, salary, salary grade for associates and combine it with their most recent talent meeting results (i.e., date of meeti…User_2025-02-05-22-55-58-511 54 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is Manager Display Name available in OTBI? What SA can be used?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to create custom deeplink in oracle cloud hcm ?Summary: Content (required): Hello Dears , We are looking for custom deeplinks and we need to know if that applicable to create or not ? Thank You. Version (include the …Nariman Moussa 83 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI challenges rendering null valuesSummary: OTBI challenges rendering null values. Content (required): Hi experts, We experiencing challenges to come up with a solution to correctly show the data in the O…Volodymyr Faranosov 114 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to extract PDF bytes from BI publisher using BI web serviceSummary: Client have requirement to extract the pdf output generated from BI publisher to be feed to third party to get that pdf output affixed with digital signature in…Shiva Prasad M 31 views 2 comments 0 points Most recent by Shiva Prasad M Reporting and Analytics for HCM
-
Need subject area to get the manager name of inactive employeesSummary: Need subject area to get the manager name of inactive employees Content (required): Hi, I need subject area to get the manager name of inactive employees. For e…
-
Query to find All grade Rate values with Grade codeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sowmiya Velusamy 2.6K views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Subject Area not displaying Payroll Periods After a certain PeriodSummary: I am facing an issue where in the Subject Area ( Payroll Ruy Result Real Time ) is not fetching the Payroll Period Data of an Employee after a certain Period (s…Rajit Paliwal 11 views 5 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Steps to create OTBI Report / BI Publisher Report for Planned Schedule → Time ManagementSummary: we need steps to configure Planned Schedule report which can be useful for HR Representatives and HR Admin which provides information of employees whose Worksch…
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create Temporary Table or View for complex agreement templateSummary: Seeking advice regarding BI publisher capabilities to create temporary data tables. Content (required): Hi team, I am seeking advice as to whether it is possibl… -
Does anyone how to saved search in BIP parameter?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Ability to report on modified approved future-dated absence entriesSummary: Content (required): Hi - is there a way to report on absences that have been modified by employees ? Example: On 11-Aug-2022, an employee applies for a 2 day ab…
-
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information …
-
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo…Joe Dorrian 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM