Data Models
Discussion List
-
How to define pl/sql triggers in oracle hcmSummary: I want to define or use triggers in my bi publisher model but can't find the package to call them from. What is the list of packages in oracle HCM where i can r… -
Ways to identify the Person's Assignment attributes modified in "Correct" modeSummary: Need to know the SQL/DB Table through which Oracle Fusion HCM maintains the modifications done to Person's Assignment attributes in "Correct" mode. Content (req…
-
Social Security Number shows up on approval email when employees update emergency contactSummary: We have an issue where when employee update emergency contact, SSN shows up on approval email to approver. SSN should not be disclosed on email. Can anyone help… -
How to update an Assignment Number using HDL?Summary How to update an Assignment Number using HDL?Content Hi Friends, We were converting employees in HCM, and wanted the person number to be generated automatically … -
Is it possible to correct the assignment number in HCM?Summary Is it possible to correct the assignment number in HCM?Content Hi i have a scenarion where i do need to correct the assignment number. the reason for this is i h…
-
How to identify the correct report to customize FYI notifications for Onboarding Checklist Tasks?We have a requirement to add few additional fields on FYI notifications for Onboarding Checklist. Can anyone help us with identifying the BIP Report that is generating t…
-
How to edit my extract to pull more than one benefit plan per employeeSummary: Hello All, I am working on integrating HCM with Oracle EPM. We are using provided extract templates from Oracle to pull associated data. Currently I am struggli…
-
Position and Business Unit moved to when and why: What's the impact to autocomplete?Summary: We're starting the move to redwood and we see that on the change assignment flow, position and business unit have been moved to the when and why section. Today …jmainini 31 views 5 comments 0 points Most recent by Ghosh Pooja HCM Experience Design Studio: Autocomplete Rules
-
BI data model for user license count maintenanceSummary: We have found that the seeded employee and line manager roles have unneeded privileges which are leading to a false user license count for our Oracle subscripti…JP_1142619 11 views 3 comments 0 points Most recent by Letícia Costa-Oracle Fusion Applications Administration
-
What is the behavior of Enabled and Start Date/End Date inside a value set?Summary: Hi , We are trying to understand the logic behind Enabled and Start Date for each value inside a value set. We understand Enabled is a flag like active/inactive… -
Updating Assignment Status Using HDLContent Hi all, looking for a way to load assignment status using HDL/spreadsheet loader. thanks -
CCC Additional person info fields issueWe tried to remove some fields in the "Trade Union Relationship" inside "Additional person info," but even via sandbox we cannot remove these fields from the drop-down m…
-
Can we have different notification content in In-App and Email Notifications?Summary: We have a requirement to display different details on In-App and Email notifications for approval workflow transaction notifications. Content (please ensure you… -
How to Convert Contigent Worker into EmplyoeeSummary: Hi Experts, Please confirm. How can we convert a Contingent Worker into an Employee? and after conversion, the contingent worker history is maintained in the sy…
-
How can auto populate INSEE PCS job code into position DFFSummary: Hi experts, I have a requirement to auto-populate the INSEE PCS job code into the DFF field while creating a new position. When creating a new position and prov…Saher 21 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Report error within a journey taskSummary: Content (please ensure you mask any confidential information): Hello everybody, We are experiencing a blocking issue completing a certain task within a journey.…
-
Historical Data Migration - Employees from 1961Summary: Hello, We have a requirement to migrate historical data for HCM from 1961 and I'd like to understand if this is feasible and if it would cause any performance i…
-
Issue with multiple "and" conditions in RTF templateSummary: Hi Team, In an offer letter I have used multiple "If" and "and" condition. If employee is not having Fixed Mobile Allowance-SI, Fixed Transport Allowance-SI and…Asha Jennifer 1.5K views 2 comments 0 points Most recent by Basavaraj Navalagi Human Capital Management
-
Managing Hierarchical List of Values in Oracle HCMSummary: We have a client requirement to manage a hierarchical list of values at single field level in Global HR. The request is for more Business Use Cases. Content (pl…
-
We are looking for SQL query which can pull the list of employee whose assignment data is missingBasically,I am trying to set up a query that will find records that are missing data. For example, I have a main form where users will enter biographical data, but they …
-
Future approval of transactionHow can I extract all the confirmations of the transaction? From table FA_FUSION_SOAINFRA.WFTASK only the current one is extracted and I also need the future onesAlex_Balanovsky 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Need Oracle Database table for "Time card Required" fieldsContent Hi I need Oracle Database table for "Time card Required" fields for BI report. The field is on Manage Payroll Relationship page. Version 21 b
-
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 277 views 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Documents of Record attachment migration between two Fusion environmentSummary: Hi Experts We have a requirement to migrate the DOR attachments from one Fusion environment to the other due to EURA migration. Could you please share if we hav…Pradeep Kumar-Oracle 11 views 2 comments 0 points Most recent by Pradeep Kumar-Oracle Human Capital Management -
How to obtain the RATE in HCM fusionHello everyone. Could you help me obtain the employee rate field from the HR module in HCM Fusion through SQL?FERNANDO RUGEIRO 32 views 4 comments 0 points Most recent by FERNANDO RUGEIRO Payroll and Global Payroll Interface (GPI)
-
HDL not working for document of recordsHi Team, We are trying to upload Document of records via HDL but we are having the following errors: Grateful if you could help, below our HDL METADATA|DocumentAttachmen… -
Dashboard Prompt not working for logical SQLSummary: Hello, I've developed a report using logical SQL by combining several modules, and it's functioning correctly. However, when I add a dashboard prompt, the data …Ishak03 23 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
Can we add custom additional attributes to delivered Workflow notifications?Summary: The requirement is to add some additional fields to the delivered workflow notifications. Here I could see some delivered functions/Packages were used to captur…User_PXZTL 4 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
BIP Report returns sql time out error for few usersHi, We have a BIP Report which is working fine for few users and returns SQL time out error for few users. The user who is getting error is running the report by using s…
-
DOR with report reference, don't have attachment link in the final approval emailsSummary: Hi, We have set up DOR with approvals and with reference to Report link. SO report will automatically run and the draft letter is shown as attachment until all …