Data Models
Discussion List
-
Is it possible to query or export approval rules + conditions for a transaction?Summary: I want to export the configured rules and conditions for the Manage Employment approval rule (Transaction Console > Approval Rules). How can I do this? Is there… -
HDL for custom section in Additional Person Info pageSummary: HDL for custom section in Additional Person Info page Content (please ensure you mask any confidential information): Hi experts, does anyone has a simple HDL te… -
Not able to see the data Annual PDP 2026 from hra_doc_types_tlSummary: I am able to see the performance document Name in OTBI and front end but not able to see in the oracle fusion HCM table hra_doc_types_tl Is this expected or do … -
Is there an OTBI/BIP Report for Employee Personal Information Change Transactions?Summary: Looking for an OTBI/BIP Report for Employee Personal Information Change Transactions! Content (please ensure you mask any confidential information): Checked the…nikhilnelluri 11 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management
-
Additional Assignment Info - not visble in Employment infoSummary: Hello, We are unable to see the Additional Assignment Info, under employment info, in Redwood. In RUI, the section is correctlu displayed. We deployed online an…
-
REASON_CODE is not populating in PER_ALL_ASSIGNMENTS_M tableWe have custom reports which are using the REASON_CODE column from PER_ALL_ASSIGNMENT_M table. After we enabled Redwood, the REASON_CODE column stopped populating UI sho…
-
BI Audit Report/Tables connection errorSummary: We are seeing below error when user is trying to run a BI Report which fetches data from fusion iau viewer.bipublisher_v table to capture report access timeline…
-
How to schedule the same PDF notification for Casual employees at 6 months, 12 months, and yearlySummary: Hi All, I have a requirement where we need to send the same PDF document to employees whose Assignment Category = Casual based on the following timeline: First …Dharani Dhar Gupta 14 views 0 comments 0 points Started by Dharani Dhar Gupta Human Capital Management
-
Need a sample query of Team Time Card page, to fetch staus value.Need the sample query to get the staus value (Approved, Submited etc..) of Time Cards for an employeeKalpa Sandaruwan 24 views 1 comment 0 points Most recent by HD - Oracle Fusion ERP-Oracle Human Capital Management
-
Under HCM only license, capture Department Costing under GL Cost Centre.Under HCM only license, can we capture Department level cost under 'GL Cost Centre' ( Which is used by ERP) ? And if we do would we have any downstream implications? Als…Prosenjit Manna 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
How to Add Document of Record Object from HCM Employment Flow to Approval BIP NotificationHas anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added Thanks! Update: I figu… -
What are the ways to identify a no show new hireWe have few new hires which did not show up for some reasons, however as they were provided with a start date, once they became a regular employee few outbound files/rep…
-
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 23 views 2 comments 0 points Most recent by Milan_Chandra Recruiting, Opportunity Marketplace
-
SQL to get Checklist Status for EmployeesSummary: SQL to get Checklist Status for Employees Content (required): If we have a requirement to get Checklist status for Employees, below SQL can be leveraged. Versio… -
Change Working Hours approval notification template shows old template in RedwoodSummary: Change Working Hours approval notification template shows old template while submitting via Redwood UI . Showing correct template while submitting via Responsiv…M Santoshi-Oracle 81 views 10 comments 0 points Most recent by Gretch Atienza Human Capital Management -
How to get the user details to whom termination notification is getting sent from workflow .How to get the user details to whom termination notification is getting sent from workflow notification AssignmentTerminationReport. Objective is to customize template b…
-
Query to find transaction details for stuck 'Time Change Request Approval' process_OTL cloudSummary: We have multiple transactions in 'Stuck' status after a DB outage for a certain date, these transactions don't have any details for the dates/time for which the…
-
Customize report directory printSummary: Content (please ensure you mask any confidential information): Hello everyone We're customizing the directory printing report. Therefore, among the selectable p…Gerardo Peluso 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
need the translate table where we can get the state columnSummary: We have tried to apply the translate column from the associate table Content (please ensure you mask any confidential information): we wanted to include the tra…
-
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 read content of attachment of Document of RecordSummary: How we can read the content of attachment attached to DOR. Content (please ensure you mask any confidential information): We have requirement to read the conten…Alpesh Sanghvi 21 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management
-
Report parameterized with person_id inside journeySummary: Content (please ensure you mask any confidential information): Hello everyone We're experiencing issues with a report to be included in a guided journey. Specif…Gerardo Peluso 27 views 2 comments 0 points Most recent by Gabriele_Cristofalo Human Capital Management
-
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…
-
Validate transaction console complex triggered approval rule on a completed transaction.Summary: I'm looking to review completed transactions details to see that the correct approval rule has been triggered in the change salary transactions we have had subm…Georgia Puddifoot 19 views 0 comments 0 points Started by Georgia Puddifoot Human Capital Management -
Clarification Required on Seniority Dates Data Fetching in Oracle HCM BI Report.Summary: A person having 2 Seniority entries- one for worker type as "Pending worker" and other for "Employee" is existing for below Seniority codes- "Legal Employer Sen…Amit Khadakabhavi 42 views 2 comments 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Human Capital Management
-
How can we store a BI Report (PDF) in the Document of Records without using HCM Extracts?Summary: We have configured a journey for Associates in which they receive a document as part of their task allocation. When an Associate is assigned a task, a correspon…
-
CreatePosition rtf template- DFF not showing in notification templateSummary: Hi Experts, We are trying to add custom DFFs in the CreatePositionrtf template. We modified the template but the DFFs attributes are not showing up once the pos…Revathi Thangaraj 28 views 4 comments 0 points Most recent by Revathi Thangaraj Human Capital Management
-
SQL Query to fetch all Notification details (approval, fyi and reminder notifications).Summary: Need SQL Query to build a Report to fetch all Notification details (approval, fyi and reminder notifications) sent in 2024 for some particular employees. The re…Saurabh Maheshwari 715 views 5 comments 0 points Most recent by Jamie Walsh Human Capital Management
-
Is there any consolidated excel available module wise listing all deep links till 25CSummary: Hi Team, Need the complete list of deep links available in oracle fusion till release 25C. Is there any document available for the same or is there a way we can…
-
Is there a DM Table or Subject area to track log in timesSummary: Is there a DM Table or Subject area to rack log in times Content (please ensure you mask any confidential information): Version (include the version you are usi…