Calculate Work Pattern Factors Issue

(Doc ID 2403380.1)

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.

Symptoms

Problem Statement:

"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.


Uploading from the data file /appld003/fs1/EBSapps/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbutable.ldt
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


Changes

 

Cause

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