Data Models
Discussion List
-
Delivered Reports in Fusion HCMSummary Delivered Reports in Fusion HCMContent Dear All, Reporting and Analytics is an integral part of any ERP implementation. At times we tend to create reports for cl…Ankur_Fusion_HCM 1.2K views 7 comments 6 points Most recent by Jitender Rawat-281454 Human Capital Management -
Query to download user profile photoSummary: IS there any way we can download the Staff (User)Profile photo from backend (using SQL) Content (required): Version (include the version you are using, if appli… -
Manager Hierarchy LoopSummary We want a report that can tell us Manager Hierarchy Loop conflictsContent Hi All, We are seeing certain termination and promotion transaction failing due to mana…
-
Release Update Issue 23b: Error in custom reportsSummary: 'ORA-32036: the unsupported case for inlining of query name in WITH clause' Content (required): Hi Everyone, I'm facing an error on reporting level after the Re…
-
Best way to query HCM tables??Summary: Content (required): Hi, so for the past 3 years, the way I've been querying HCM tables is by using a BI data model to write the query and output the data. I'm c… -
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
I want to extract distinct user logins that logged in to the systemSummary: Requirement is to extract distinct user logins who logged in to the system and compare the statistics for Q1 2022 and Q1 2023 Content (required): Version (inclu…Keval_Shah 101 views 7 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
Doc ID 2331021.1 Release 13 Configurable Notifications Enhancements (20B Update)Summary This is part of a series of Quick Reference Guide "Frequently Asked Questions and Answers"Content To improve the performance of Oracle Business Intelligence (BI)…Dr Surlina Yin-Oracle 1.4K views 15 comments 12 points Most recent by Meghna_Av Human Capital Management -
V3 Seniority dates BIP query issueHi Experts, I am working with a BIP query using V3 Seniority dates table (PER_SENIORITY_DATES_F), I need to map the seniority date with assignment table or work relation…Yuvraj S-Oracle 373 views 14 comments 0 points Most recent by Ramanathan Sockalingam Human Capital Management
-
Department Manager InfoHi, I wanted to extract department details with reporting manager person number and name. Can anyone help me with the userentity where i can extract department details w…Yuvraj S-Oracle 71 views 4 comments 0 points Most recent by Yuvraj S-Oracle Human Capital Management
-
How to send documents saved in Document of records?Summary: Hi all, we have a requirement to send the employee document which is saved under documents of records to the downstream system using SFTP. can anyone please let…Naveen setti 31 views 1 comment 0 points Most recent by Rachita Mishra-Oracle Human Capital Management
-
Create Person Security Profile with AoR and Position TreeSummary: Cannot select position hierachy as scope of responsibility in creation of person security profile. Thus, position tree cannot be referenced rendering our plan t… -
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…
-
Required documents related to approval delegationSummary: I want documents related to approval delegation.Like how to set approval delegation. Content (required): Version (include the version you are using, if applicab…Lakshmi Prasanna Aaula-Oracle 42 views 1 comment 0 points Most recent by Mairina Human Capital Management
-
Table Details that stores all information about a Custom Quick ActionHi All, Please help know the table name that stores Quick Actions ,Eg: If there is a custom Quick Action created like "Colleague Details" under Me TAB,want to know when …
-
Need to edit Enterprise Onboarding TemplateSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We want to display the first name in place of full name in the Enterprise On…
-
Worker.dat is not loading to update SenioritybasisSummary: METADATA|Assignment|AssignmentNumber|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|SeniorityBasis…User_2025-07-18-06-45-42-477 72 views 5 comments 0 points Most recent by MandeepGupta Human Capital Management
-
SQL to fetch all the worker objects to load using HDLHi all, I needed a SQL to extract the worker objects (worker, person_name, phone, assignment, work relationship, assignment supervisor, etc., ) to load into fusion from …Yuvraj S-Oracle 313 views 2 comments 0 points Most recent by Yuvraj S-Oracle Human Capital Management
-
Access of All Employees - Workforce Management - Absence Real TimeThe client requirement is to have access of Approved upcoming absences of all employees to the line managers and I have defined data security under Line manager - Person…Sandeep Nihalani 41 views 3 comments 0 points Most recent by Sandeep Nihalani Human Capital Management
-
Fusion to Fusion with HCM ExtractSummary: Hi, I want to know how can i configure a Fusion to Fusion using HCM Extract and Report. Is there a document with a guide to configure it and the flow pattern to…
-
Add New Assignment CategoryContent Hi Guys, I'm looking to add a new label in the area 'Assignment Category'. We're basically using this area to record the region of an employee, but I can't seem … -
Approval Delegates DataSummary Need Approval Delegates Details ReportContent Hi All, We have BIP report for role delegation with all role delegation details. Now the request is to get the data…
-
How to add Deeplink for on Dashboard or My Teams -->My Teams WorkersSummary: How can we add DOR deeplink to Line Manager Dashboard where he can choose a person for that specific DOR, Or If we can add a deeplink on MY Team--> My Team --> …
-
SQL for 'Include for Automatic Conversion' and 'Synchronize from Position'On a pending worker record(My Client Groups ->Pending Workers -> Edit a pending worker/Add a pending worker), there are these two Yes/No dropdown fields in the Employmen… -
Updated Data MartSummary: Updated Data Mart by adding new field but not showing up when running the report. Content (required): I have a report created in and updated the data mart by ad…Jose Guerra 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Human Capital Management -
Employee access only report and analytics.Summary: Hi Team, We have a requirement , where employee can see only "Tool> report and analytics> and Browser catalog. Let me know anyone knows the privileges name. Tha…
-
Department details with BU and LE InfoHi Experts, We had a requirement to fetch the department details( name , status, effective start date & effective end date) along with its business unit name and legal e…Yuvraj S-Oracle 51 views 7 comments 0 points Most recent by Yuvraj S-Oracle Human Capital Management
-
SQL to Extract Tax Withholding Calculation card DetailsSummary: SQL to Extract Tax Withholding Calculation card Details Content (required): If there is a requirement to pull the Tax Calculation Card Details on BIP Report, th…B S Rafatullah-Oracle 1.8K views 1 comment 2 points Most recent by Parag Hiremath Human Capital Management -
SQL - How to identify list of employees that are missing HR areas of responsibility for current weekSummary: Hi, Need find the list of employees who are not assigned HR responsibility Content (required): SQL Query Version (include the version you are using, if applicab…User_2025-02-12-21-24-25-654 71 views 6 comments 0 points Most recent by Stephanie Moxley-Oracle Human Capital Management -
Generating DOR Records via Document Records in Termination HCM Transaction FlowsSummary: Generating DOR Records via Document Records Available in Other HCM Flows Content (required): Hi all, I am seeking some information regarding the report paths av…Luke.Findex 104 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management