Data Models
Discussion List
-
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 63 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 14 views 2 comments 0 points Most recent by Pradeep Kumar-Oracle Human Capital Management -
BIP report to fetch department changes record for employeeRequirement to fetch all the records where department attribute is being changed irrespective of action and action reason for an employee. For this we are comparing prev…Kavya Sreenivasulu 11 views 1 comment 0 points Most recent by Kavya Sreenivasulu 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… -
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 22 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 12 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 23 views 2 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
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 …Prasad B-140020 69 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 19 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 799 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