Data Models
Discussion List
-
I need to change the Legal entity name and Business Unit name as effective-start date as 01/11/2023.I need to change the Legal entity name and Business Unit name as effective-start date as 01/11/2023, but I need to know the impact of changing these at all modules in HC… -
How to change specific Section in a Redwood Theme?Summary: Hi everyone, we are trying to change the theme of a specific section (Directory-My Organization Chart- in ME Tab) to a Redwood theme without changing the system…Marlon Castillo Maliglig 81 views 3 comments 1 point Most recent by Derek Dreyfus Human Capital Management
-
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 … -
Email Bursting not workingI have the below Email bursting definition configured. The Schedule job completes successfully, however I never actually receive an email from it, even though there was …KDR 1K views 6 comments 0 points Most recent by Sreekanth Chennabathini BI Publisher Learning Center
-
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… -
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… -
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
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…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and… -
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-Support-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