Calculate Work Pattern Factors Issue
(Doc ID 2403380.1)
Last updated on SEPTEMBER 06, 2019
Applies to:Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.
"Calculate Work Pattern Factors" re-generated the work pattern factors for the two seeded work patterns. As the two seeded work patterns are being maintained via Oracle patches, "Calculate Work Pattern Factors" should not update the work pattern factors for seeded work patterns.
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/appld003/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.5.12020000.8), /appld003/fs1/EBSapps/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbutable.ldt) to staging tables
Dumping LCT file /appld003/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.5.12020000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /appld003/fs1/EBSapps/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES PQP_COMPANY_WORK_PATTERNS GB , PAY_USER_COLUMNS PQP_TRAVEL_PURPOSE GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = PQP_COMPANY_WORK_PATTERNS, B_LEGISLATION_CODE = GB, B_USER_COLUMN_NAME = PQP_MON_SAT_8_HOURS, B_LEGISLATION_CODE = GB, ORA-20001: PAY_7038_USERTAB_VALUE_UNIQUE:
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Apply UK TYE patch or any UK Legislative Patch
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