Data Models
Discussion List
-
Seeded Termination Report in Oracle HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 191 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Human Capital Management -
Oracle UI: determine data source (table/columns)Summary: Hello, When using the web interface of Oracle HCM, I need to determine which table and column the UI values are being populated from. Is there a reliable way to…
-
Excel Report only showing data on 2 out of 3 tabsSummary: We have an HDL Error report that is an Excel spreadsheet with 3 tabs of data. https://us.v-cdn.net/6034893/uploads/RZA3CHT7YYQX/summary-not-appearing.docx The d…
-
Is there any way to extract user account details with who have person data and without person data?Summary: Is there any way to extract user account details with who have person data and without person data? Content (please ensure you mask any confidential information…
-
Reporting on HR Error During ProcessingSummary: Reporting on the reason for HR, Error During Processing Content (please ensure you mask any confidential information): I've created a report to highlight new hi…
-
Aduit Report for ESS jobs scheduled/rescheduledHi, We need an audit report on list of all ESS jobs scheduled/rescheduled, who scheduled them and when were they scheduled/rescheduled. Has anyone worked on any similar …
-
Hide the section "Change Photo"Hi everyone! How can i hide the section "Change Photo" ? Thanks!Mario Della Monica 31 views 9 comments 0 points Most recent by Nivya Mathire Human Capital Management
-
How to call a service logistics PVO from an SQL query from BI Publisher and BI AdministrationHow to call a service logistics PVO from an SQL query from BI Publisher . We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesP…P.S.Nikhitha Muduliar 31 views 1 comment 0 points Most recent by Shrikant Nene-Oracle BI Publisher Learning Center
-
How an employee logged into HCM can run a BI report to get output with his/her own dataSummary: How an employee logged into HCM can run a BI report to get output with his/her own data. My requirement is that who over logs in and runs a particular report, s…
-
Create bank account to an employeeDear All, I am trying to create an external bank account to a new employee using this endpoint:/fscmRestApi/resources/11.13.18.05/externalBankAccounts. But I am obtainin…
-
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…
-
Seeded Function PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS takes longer to run in BI ReportThe function takes longer time to run in BI report and gives time out errors out when run in Adhoc. Since we are placing this report in dashboard as a link to BI, the re…
-
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…
-
Why does the query in the dataset take an extended time to process?I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the…
-
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 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
-
Do all view tables hold data constantly or is there a process to get the information to showHello, I'm using the view FND_BPM_TASK_HISTORY_VL to see the history of tasks and approvals for transactions. This is to create a report to show the approval workflow fo…