Data Models
Discussion List
-
Does anyone have a report for page field labels in different languages?Requirement is, to provide for business user review, a list of field labels by page, and their translated labels, for each language pack in scope. Does anyone have a rep… -
How to define pl/sql triggers in oracle hcmSummary: I want a list of pl/sql functions from HCM that can be added as triggers. From what i have learnt so far, oracle does not allow us to define pl/sql functions on…
-
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…Aanila Nanda-Oracle 21 views 1 comment 0 points Most recent by Rafatullah BS Human Capital Management -
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 32 views 5 comments 0 points Most recent by Ghosh Pooja HCM Experience Design Studio: Autocomplete Rules
-
Tables store transaction console approver name showing as AssigneeSummary: Tables store transaction console approver name showing as Assignee Content (please ensure you mask any confidential information): Hi, I'm looking table name whi…Bhavna-Civeo 31 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Human Capital Management
-
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 16 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
-
Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…
-
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…
-
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 85 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 31 views 4 comments 0 points Most recent by FERNANDO RUGEIRO Payroll and Global Payroll Interface (GPI)
-
How to create a document of record from a BI report and add it to employeeSummary: we have a bussiness usecase to add service certificate as document of record in the employee document of records. We already have a BI report which is sending s…