Calculate Work Pattern Factors Issue
Last updated on MAY 25, 2018
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms