Data Models
Discussion List
-
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
-
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 22 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 258 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 13 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)
-
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 21 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…
-
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 …
-
Database name change after 24B update. Need a SQL to find the alert that are using Database Name.Hi Team, We noticed database name change in Production after 24B patch applied and all our BIP Bursting logics are configured in a way that if the database name (ora_dat…Nayeem Pasha 21 views 1 comment 1 point Most recent by Mihaela Cojocariu-Oracle Human Capital Management
-
A scheduled BI report has been failed in one of it's scheduled runA scheduled BI report has been failed in one of it's scheduled run with below error: Waiting Time: 4.7 seconds Data Fetch Time: 0.4 seconds Total Execution Time: 1.8 min…Ritika.ray-Oracle 11 views 4 comments 0 points Most recent by Ritika.ray-Oracle Human Capital Management
-
Which BI Template does the New Hire FYI notification use?Summary: We have added 2 fields to the New Hire notification (Business Title and Position). The fields were already in the data model to add to the RTF template. The "Ap…
-
Ability To Create Alert for Custom Visas and PermitsSummary: Ability To Create Alert for Custom Visas and Permits Content (required): Hello All, Is it possible to create an alert in HCM for custom permit such as Residency…
-
Edit time-out in Administration-> Runtime ConfigurationSummary: Hi Everyone, I'm trying to increase time-out for query and report but unable to edit the query time out in administrator Administration-> Manage Publisher-> Run…Hrushikesh Pentewad 21 views 2 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM