Data Models
Discussion List
-
Query to get the Highest level(One below CEO) of Manager for an employeeSummary Query to get the Highest level(One below CEO) of Manager for an employeeContent Hi Team We have our requirement where we need to fetch the highest level of Manag… -
Can we apply passwords to Excel templates (.xls format) BIP reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Create external bank account for an employeeDear All, I hope this message finds you well. I am writing to seek assistance with two issues related to external bank accounts in Oracle Fusion. 1- Viewing External Ban…
-
How to calculate two dff date values in 3rd dff valueSummary How to calculate two dff date values in 3rd dff valueContent Hi, I am having two Dffs showing start date and end dates. I want to calculate the duration between …User_2025-02-04-15-20-16-786 89 views 5 comments 0 points Most recent by arwa Alsuliman-Oracle Human Capital Management -
How to remove buttons on approval notificationsSummary How to remove buttons on BPM approval notificationsContent We have requirement to remove buttons on BPM approval notification for security reasons. Kindly share … -
Add Pending Worker workflow notification subject not showing proposed start dateSummary Add Pending Worker workflow notification subject not showing proposed start dateContent Hi, Add Pending Worker workflow notification subject not showing proposed… -
OTBI - separate value into two columnsSummary: OTBI - separate value into two columns Content (please ensure you mask any confidential information): I am creating an OTBI analysis report and I want to separa…Nick Henderson 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Document of Records - Attachment is not updated when we are trying to correct/update the data.Summary: we have created a custom report for Document of records and given the path at Document Types. But when we are trying to correct/update the data of existed trans…
-
Third employment relationshipHello everyone, Our client wishes to manage scenarios involving employees with three employment relationships across three different companies. What action can be utiliz…
-
Payload file for Create Time Entries for Project and Task through REST APISummary: Need help on json payload file for Time Entries REST API in link ( for project task related Time entries Content (please ensure you mask any confidential inform… -
Oracle HCM: How to add Prior Individual compensation details to Compensation workflow notificationsHi All, we have a requirement to add Prior compensation details to the existing Compensation workflow notifications. Can you please let us know how to achieve this Thank…
-
Need Table details storing User information created in Security ConsoleSummary: We need to get the information of User like First Name, Last Name, username and email id of the user created in Security console. Content (required): Person inf…Sudheer Movva-193114 1.3K views 8 comments 0 points Most recent by Anirudh Baranwal Human Capital Management
-
HDL Error on Assignment loadSummary: We are trying to perform a load to remove Position Value from Assignment & are running into an Issue with HDL for a subset of our Employees. HDL Error says: "Th…
-
Customer's infosec team wants to review how information is stored in cloudSummary: Customer's infosec team wants to review how information is stored in cloud (data on rest and flow covering end to end architecture). Request for sharing resourc…Maithraye Kambam-Oracle 21 views 2 comments 0 points Most recent by Maithraye Kambam-Oracle Fusion Applications Administration
-
Job Offer Approval Rule in "Worker Type" we have "Contingent worker " & "Employee".Summary: Hello We have a requirement with Job Offer Approval Rule in "Worker Type" we have "Contingent worker " & "Employee". Employee Need to go for Approval Contingent…Krishna Sigilipalli 11 views 1 comment 0 points Most recent by ChelcieN-Oracle Recruiting, Opportunity Marketplace
-
HCM Production data needs to be masked conditionallyRather than the non-production environment (we know that sensitive data can be masked in non-prod during P2T), we need to conditionally mask production data such as sala… -
sql query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date)Summary: Hi Folks, Do you have query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date when Standard Hrs is >=20) Thanks
-
Users Transaction DetailsHi Team, Greetings!! We are looking to get Users Transactional Data (When the user account got inactive or locked, Error message if user trying to login), time the appli…Anand-ST-Oracle 41 views 2 comments 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
HCM Extract - With Document of Records Delivery typeSummary HCM Extract - With Document of Records Delivery typeContent Hi Experts, I have a requirement to store the Report in Document of records, for that we have used HC…User_2025-02-10-21-41-28-701 390 views 13 comments 1 point Most recent by Parag Hiremath Human Capital Management
-
HDL Error in Termination CWK and creating NonworkerSummary: We are facing HDL error while Termination of CWK with Multiple lines and creating Nonworker. Below is the error message Error : You must provide New Start-Date …
-
How to retrieve bank account details on report with correct party ID?Hello, We have run the attached SQL query. However, we have noticed that for one employee, we were not able to retrieve the bank details as shown below: Currently on the…VDoolhur 599 views 5 comments 0 points Most recent by Stephen Westerfield-Oracle Human Capital Management
-
HDL for historical dataHi Team, Could you pls help me with HDL template for loading historical data? Thanks in advance!!
-
Issue with Table pay_dir_comp_details_f, pay_dir_card_components_f 'Responsive UI' calculation cardFor "US Federal Tax Card Details" and " US State Tax Card Details " Records for "calculation card details" are not appearing in the table "pay_dir_comp_details_f" when t…Siddharth D Chaware 463 views 9 comments 0 points Most recent by Vibha Pandey - Oracle Payroll and Global Payroll Interface (GPI)
-
Field URL is blank in view fnd_documents_vlSummary: Field URL is blank in view fnd_documents_vl Content (required): We are trying to report on the documents people have, we are trying to use the "URL" field of th…Samantha Aguilar C 111 views 7 comments 0 points Most recent by John T-Oracle Human Capital Management -
How can we add an LOV to an additional address attribute fieldSummary: Hello, we are struggling to evaluate if we can add an LOV to an additional address attribute field. As of right now, those fields always show up as text fields:… -
Are document records stored in a server?Summary: Hi Community, Our client is transitioning from PeopleSoft to HCM Cloud. Currently the documents they upload are stored in a File Server in PeopleSoft. Are Docum… -
How is data capture in HCM Events TableSummary: We want to understand how is data captured in HCM Events Table & How does it differ from Audit Table ( which is table with_ at the end)? Can anyone share any in…
-
N/APost created by mistakeHumberto Martín-Oracle 11 views 0 comments 0 points Started by Humberto Martín-Oracle Human Capital Management
-
how to change date format un bipSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get the value from the UDT for the Custom field DFF?Hello Experts, We're adding a Custom Grade Ladder through a Descriptive Flexfield (DFF), where the values originate from the UDT. The expected outcome is that selecting …