Global HR
Discussion List
-
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new … -
loader for licenses and certificationsSummary: I'm trying to figure out how to do a bulk load of employee licenses/certifications with the field below. I looked in HSDL and I'm not sure what I need to pick t… -
Change assignment transaction cannot be approved with a comment.Summary: In change assignment, transaction cannot be approved with a comment but without comment it can be approved Content (please ensure you mask any confidential info…Abhishek Kr. 11 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management -
Unable to change the Parent root data group in 24DSummary: Unable to change the Parent root data group in 24D. Content (please ensure you mask any confidential information): We have multiple UE (User Entities) in a extr… -
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…Vaishnavi Katiyar 72 views 5 comments 0 points Most recent by Chantel Berger Reporting and Analytics for HCM -
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.Summary: Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause. Content (please ensure you mask any confidential information): In the custom HCM Extrac… -
Using the Termination Date value for counts between Calendar Month Start Date & Calendar Month EndSummary: I have read a lot of posts where individuals have been looking to get counts of employees who have a termination date between X & Y. However, if an employee has… -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 906 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Display position in Me > DirectorySummary: Hello, We want to display the employee position instead of his/her job in Me > Directory. Can you please advise if this is feasible and how? Regards Hayat Conte…hakl 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Visual Builder Studio for HCM -
Display position in Me > ConnectionsSummary: Hello, We would like to display the employee position instead of the employee job in Me > Connections. Can you please advise if this is possible and how? Regard…hakl 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Visual Builder Studio for HCM -
Can we change desctripton of tabs in what to include page ?Hi Team, On the Redwood 'Hire an employee' or 'Add a contingent worker' page, we are looking to change descriptions of boxes present as some of them are not relevant to …Nissy Prathyusha 1 view 2 comments 0 points Most recent by Nissy Prathyusha Visual Builder Studio for HCM -
SQL query to retrieve employee country (work relationship level)Summary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve Country field at the employee level by SQL query? If so…Valerio Curzi 546 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 2.9K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM -
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt… -
Trying to Retrieve the Specific Ethnicity Record Associated with each Period of ServiceSummary:It appears that there is a separate row in table per_ethnicities for each of an employee's period of service. Looking for a query Content (please ensure you mask…ChicagoConsultant 3 views 1 comment 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM -
Recently updated data in an Org Tree is not displayed in OTBI reportsSummary: In mid December, I created about 20 new departments and tied them to existing Divisions in an Organization Tree. The departments were created with a 1/1/25 effe… -
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 22 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM -
Approvals are in progress. Info is lockedHello, I am trying to transfer an employee from one legal entity to another and I am getting a message that approvals are in progress. I tried to run the Conflicting Tra…Catherine Abi Samra 358 views 6 comments 0 points Most recent by Rahul M Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 541 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu… -
On Worker Assignment, Default the value of BU using a LE EFF Info SegmentHi We have an AutoComplete Rule in HCM Experience Design Studio which is Object Defaulting Rule Type. As per this rule On Worker Assignment, Default value of BU using a …Ashish.Chinchulkar.BNYMellon 21 views 0 comments 0 points Started by Ashish.Chinchulkar.BNYMellon Visual Builder Studio for HCM -
How to end date Job & Position using HDLSummary: How to end date Job & Position using HDL Content (please ensure you mask any confidential information): Hi All, Is it possible to end date/delete Job and Positi… -
Use VBS to change view of Personal Details sections.Summary: Hi, I have switched on Redwood for 'Personal Details'. We have a DFF that holds additional questions, is there any way to re-order these as the display is sligh…Stacey Williams 31 views 4 comments 0 points Most recent by Chris Borsh-Oracle Visual Builder Studio for HCM -
PDF available for Tables and Views for HCMSummary: Is PDF option available for Table and Views i see there is no option to download. Tables and Views for HCM Content (please ensure you mask any confidential info… -
Unable to find Global Payroll Interface v3For an integration with Alight payroll, they recommend using Global Payroll Interface v3. But we cannot find it as HCM Extract. We have tried with different LDG, etc. We… -
We want to rename a field Business Title on Compensation Info PageSummary: We want to rename a field Business Title on Compensation Info Page to Assignment. Please guide on the steps , how we can do it. Content (please ensure you mask …FNU Monika 11 views 3 comments 0 points Most recent by Sonia Bourak Partouche-Oracle Visual Builder Studio for HCM -
The route text for database item GLB_PAY_BAL_EXCP_PER_PAYROLL_RELATIONSHIP_ID is empty or too longI have a HCM Extract working good till last 2 weeks. Error: ORA-20001: The EXT_PAYROLL_RECORDS_300000020284428 formula can't be run because it isn't compiled. Details: A… -
Unable to edit the extract in advance mode in 24DSummary: Is it possible to edit HCM extract in Advance mode? If yes how we can do it? Even after adding below lookup as well, still we are not able to edit HCM extract i… -
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 738 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM