Data Models
Discussion List
-
How to update Disciplinary incident status in UI?Summary: How to update Disciplinary incident status in UI? I have checked this data is storing on PER_PEOPLE_EXTRA_INFO_F table Content (please ensure you mask any confi… -
Is it possible to trigger an alert as soon as employee submits resignation?Summary: Is it possible to trigger an alert as soon as employee submits resignation and before resignation is approved? Content (please ensure you mask any confidential … -
Unable to get data for Secured views pay_payroll_secured_list_vSummary: When the user is trying to run the report not getting the data as secured view used in the report. Content (please ensure you mask any confidential information)…
-
If we load pending workers through HDL, will the onboarding will trigger automatically?Summary: If we load pending workers through HDL, will the onboarding trigger automatically? Content (please ensure you mask any confidential information): Version (inclu…
-
SQL to get current Oracle ReleaseSummary: We're looking for the database table (or even a complete query if anyone has it) to retrieve the current version of the environment. Basically we need it to che… -
Incumbent on positionSummary: I cannot see the Incumbent Position Entry Date, Position Exit Date, Status, Type information in any columns in the hr_all_positions_f and hr_all_positions_f_tl … -
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dynamically parameterized OTBI for journeysSummary: Content (please ensure you mask any confidential information): Hello everyone, We have created an OTBI report on the subject area "Workforce Management - Checkl…
-
Is it possible to use different BI templates for different Legal Employers in one report?Summary: Is it possible to use different BI templates for different Legal Employers in one report? Content (please ensure you mask any confidential information): Is it p…
-
The custom dashboard in the UI of the DEV environment is redirecting to the PROD dashboard.Summary: When I try to open the custom dashboard located in My Client Groups in Dev it is redirecting in Prod Custom Dashboard Content (please ensure you mask any confid…
-
SQL query for absenceSummary: Hi, I have to create a query with 2 types of abcence. The data model is ready but i have to show each absence day in the seperate row,example: E123123 2023-10-2…
-
Data Removal - How to treat records with Work Relationships in multiple countriesSummary: Hi all So we have been configuring a process to remove data with the Person Removal Tool. This works amazing for those who have one or more Work Relationships w…
-
Document of Records Letter Generation Does Not Have Proper Values or Has No DataSummary: The issue can be reproduced at will with the following steps: 1. Employee adds a document record by navigating to Me > Document Records 2. Select Document Type … -
How to add logo inside approval notifySummary: Content (please ensure you mask any confidential information): Hi everyone, We are customizing the approval notifications that reach a customer's employees to a…
-
We need a value set through which we can auto generate the incident numbers.Summary: We are looking to setup a value set through which we can auto generate incident numbers where incident number is a DFF on DOR. We are trying to create a Value s…Pravesh Jain 61 views 6 comments 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
Can we rename notification button.Summary: Hi Expert. Good day! Just wanted to know can we rename the "Reject button" Example - for inida Legal entity it should (Revoke) and for US legal entity it should…
-
which table has VISA Comments and Notes?i need to create a BIP report including Visa information. But i can't find the right table for VISA Comments and Notes. Does anyone know about it please?
-
Mass Update ChangesSummary: Content (please ensure you mask any confidential information): Hi everyone, We are configuring the actions and fields relating to the Mass Update action made av…
-
In which table is the Document of Record attachments stored?Summary: In which table is the Document of Record attachments stored? Content (please ensure you mask any confidential information): In which table is the Document of Re…
-
-
-
HDL Template to convert Non Worker work relationship to Contingent WorkerSummary: Hi All, Can someone please provide the SQL query and HDL template for the below requirement. 1. We need to update the "System person type" from "Non worker" to … -
Is there a way to update HZ_PHONE_COUNTRY_CODES in UI?Summary: Is there a way to update HZ_PHONE_COUNTRY_CODES in UI? Content (required): Hi community, There is a Kosovo country code missing. So I am curious if there is a w… -
Address fields Unique Identifier required for PolandSummary: We require the Unique Identifier for each of the address fields, like code for Address Line 1, Address Line 2 etc and also the Unique Identifier for the values … -
Regex to extract text from html documentSummary: I need a regular expression to extract words from a html document (or any document which comprises of tags). Content (required): For example, given the followin…
-
adding data access by roleSummary: Added a data privilege to a security current custom role but need data access to go with that Content (required): we added a data privilege to a security role t…Bernadette Dorris 21 views 2 comments 0 points Most recent by Bernadette Dorris Human Capital Management
-
How to remove ORA_BIP_APPROVE_START, ORA_BIP_APPROVE_END displaying on NotificationSummary: Resignation Custom/Configurable Notification - How to remove ORA_BIP_APPROVE_START, ORA_BIP_APPROVE_END and ORA_BIP_SUBMIT_START not to display on notification(…
-
Change Full Name format in Performance Document to Preferred Name or Display NameSummary: Is there another way to change the Full Name format in printable Performance Documents? I attempted to configure the data model for the predefined report, but i…
-
How to remove the document link from the Notification pages?Summary: How to remove the document link from the Notification pages of Document Records? Content (required): Hi, we have a requirement that on the FYI notification page…PavanDuvuri 31 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Human Capital Management
-
Where are absence statuses stored in the tables?We are wanting to add the status of Absences to our reports but we are having difficulty locating them. We have found ANC_PER_ABS_ENTRIES to view absence statuses and Ap…