Category 81
Discussion List
-
Person id equals to 0 using the Person Profile Real time subject areaSummary: Person id equals to 0 using the Person Profile Real time subject area Content (please ensure you mask any confidential information): Hi experts, we are facing t…Oriana L. 21 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Infolets - hide 'Edit Titles and Views' buttonIn the Analytics/Infolets section on the HCM homepage, employees have access to a button in the top right of each infolet to either 'Edit Title and Views' or 'Hide'. Is …Edward_Cowne 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to hide schedule from BI reports action menu?Summary: How to hide (Schedule) option from actions menu for BI reports Content (please ensure you mask any confidential information): Version (include the version you a…Nourhan_Reda 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Remove Edit Capability from the Reports Shared Folder but Retain Edit Capability in the My FolderSummary: We are trying to update report permissions to remove the edit capability from the shared folder but retain the ability to edit in reports in My Folder. We have …G. Class-Peters 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.Shanna Oppenheim 31 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Adding Total Headcount and Response Percentage Columns in OTBI ReportHi Community, I am working on an OTBI report that aggregate responses from employees related to their self-identification. Current Setup: The report currently includes c…Ashok Kumar Sharma 21 views 1 comment 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
In Learning Module, can we create Offerings, Courses, Specializations with HDL?Summary: Hi Fellow Developers, Whether we can create Offerings, Courses and Specializations using HDL in Learning? If yes, kindly let me know the steps or any related do…Dhilip Kumar P. 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 11 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM -
Year over year disability disclosure reportsOur requirement is to provide a report and graph with year over year counts of disability self disclosures. Attached is an xml version of my report. I'm joining the Work…Jenna Fuchs 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Identifying duplicate emailsSummary: An analysis that highlights the same emails being registrered to multiple persons Content (please ensure you mask any confidential information): I need an OTBI … -
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct… -
How to handle "Personnel File Request" in Oracle HCMSummary: Hello, Per Personnel Records Review Act, Current and Former employees can request their Personnel File information from the employer. I would like to know the f…Deepa Kannan 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to link pay_costs table back to an organization_idSummary: How can I get pay_costs info to tie back to an organization_id? We want to be able to derive our costed department name the same way that the costing segments a… -
How to find Grade ID for EmployeesHi, I am trying to complete a Bulk Load and require 'Grade ID' for employees, I have the Grade Name and Grade Code but not the Grade ID associated, how can i extract thi…Jacob Good 132 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 322 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
send alert to employee department headwe need to Alert notification to employee department Head, could you please assist on this -
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 81 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How to Specify Multiple People in Cc While Bursting in Custom BI AlertsSummary: Content (required): There is a requirement of having multiple people in Cc while bursting. How to configure PARAMETER 2 for multiple recipients? Version (includ…Shashank Singh 1.1K views 3 comments 0 points Most recent by jahanavi metta Reporting and Analytics for HCM -
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 61 views 0 comments 0 points Started by jtwhit_hcm Payroll and Global Payroll Interface (GPI) -
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay https://us.v-cdn.net/60…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an… -
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to pull employees and contingents on a OTBI report along with seniority datesSummary: Hello, I am trying to pull both employees and contingents on a OTBI report along with seniority dates. I am noticing that since contingent workforce donot have …Nikhila 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Perfermance Status Chart (SPI AND CPI)Summary: In which type of Analysis the said graph could be made. Thank you for your prompt attention to this matter.Looking Forward for your reply. Version (include the … -
Sql to get period end active head countSummary: Hi Does anyone have sql to get active head count at the end of each month/quarter? Thanks in advance. Content (please ensure you mask any confidential informati… -
Trying to invoke candidate attachment REST API through PL SQL procedure giving errorSummary: Trying to invoke candidate attachment REST API through PL SQL procedure giving error " PLS-00306: wrong number or types of arguments in call to '||' " v_buffer1… -
Vinay Prasad 38 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 61 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM