Data Models
Discussion List
-
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 391 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 41 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 71 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 351 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 11 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 2.1K views 1 comment 2 points Most recent by Parag Hiremath Human Capital Management -
Conditionally send report to email ONLY if query returns data resultsIs it possible to setup a schedule in BI Publisher to run every day that will only output a report to EMAIL if the query fetches at least one row of data? In other words…
-
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 111 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
Impact Analysis of Work Measure UpdateSummary: Impact of updating Work Measure for all Employees through Data Exchange. Content (required): Requesting inputs on impact on all modules and tasks that may be af… -
Would like to report on HR Help Desk Audit History table in BI PublisherHello, We would like to report on HR Help Desk audit history in a BI Publisher report. Has anyone done this and might be willing to provide instruction? Thank you, Natal…Natalie A. 51 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center -
I can't view a job option in more menu for default report ?I can't view a job option in the more menu and the scheduled job doesn't appear on the Manage Report Jobs page for default reports. but it works well and shows scheduled…New 41 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Table Value set not returning data?Summary: I have a scenario where in i need to pull data stored in DFF and into another dff as read-only. The query below is generating data in Data model but not via val…