Global HR
Discussion List
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha… -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 41 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal ReportSummary: Content (please ensure you mask any confidential information): How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal Rep…OliveiraRR 205 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HCM Extract | Fast formula to get position budget detailsHi Experts, I need your assistance. I created a fast formula to get the budget amount in my extract file, and it's successfully compiled. However, I can't see the values…
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…Reshma Eldho 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to enable visual builder in production environmentSummary: Content (please ensure you mask any confidential information): Hello everyone, I would like to remove the filter "Personal" in Explore tab about Journeys. Our c…Silvia Salomè 1.6K views 16 comments 0 points Most recent by DanielJMcMillian Visual Builder Studio for HCM
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe Cannova 31 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
How to add background image in fusion home pageSummary: How to add background image in fusion home page Content (please ensure you mask any confidential information): Hi All, How to add background image in fusion hom…
-
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 71 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 900 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 1 view 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 21 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 551 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 3K 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 1 view 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 21 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 361 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