Fusion Global HR: Using Scheduled Hours with User Entity: PER_ASG_SEQ_HISTORY_DETAILS_UE Pulls Unexpected Results for an HCM Extract and from Where Are the Values Pulled?
(Doc ID 2599825.1)
Last updated on SEPTEMBER 03, 2020
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion Global Human Resources - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
This note was created for Release 11.13.19.07.0. The note has been reviewed and is current for release 11.13.20.07.0.
Function Call Returns Unexpected Results in HCM Extract.
The extract used the following:
- User Entity: PER_ASG_SEQ_HISTORY_DETAILS_UE > Database Item Group: Assignment Standard Working Hours
- Used this function in the query per_extract_utility.get_standard_working_hours(asg.assignment_id,asg.effective_start_date, asg.effective_sequence)
Where is the value is derived? There was an HCM Extract built that uses a field which selects scheduled hours (using that function).
Does this function select from assignment (normal hours), or is it performing a calculation based on the actual time worked?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document