Hrglobal Fails with Payauglb.sql and Pyauutable.ldt
(Doc ID 2024146.1)
Last updated on FEBRUARY 11, 2024
Applies to:
Oracle HRMS (Australia) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
When running hrglobal.drv, the following errors occur.
adworker log
------------------------
sqlplus -s APPS/***** @/.../pay/12.0.0/patch/115/sql/payauglb.sql &un_per &pw_per
Connected.
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (HR.PAY_USER_COLUMNS_UK2) violated
ORA-06512: at line 104
------------------------
------------------------
sqlplus -s APPS/***** @/.../pay/12.0.0/patch/115/sql/payauglb.sql &un_per &pw_per
Connected.
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (HR.PAY_USER_COLUMNS_UK2) violated
ORA-06512: at line 104
------------------------
adworker log
------------------------
Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @PAY:patch/115/import/pyusertable.lct @PAY:patch/115/import/US/loc_au/pyauutable.ldt ROW_MATCH=SEQUENCE - LEG_VIEW=hr_pay_au_implementation
Connecting to APPS......Connected successfully.
Calling FNDLOAD function.
Returned from FNDLOAD function.
Log file: /xxx/xxx/xxx/apps_st/appl/admin/devhr12/log/loc_au_pyauutable_ldt.log
Error calling FNDLOAD function.
------------------------
loc_au_pyauutable_ldt.log
------------------------
Uploading from the data file /xxx/xxx/xxx/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_au/pyauutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/xxx/xxx/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8), /xxx/xxx/xxx/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_au/pyauutable.ldt) to staging tables
Dumping LCT file /xxx/xxx/xxx//devhr12/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/xxx/xxx//apps_st/appl/pay/12.0.0/patch/115/import/US/loc_au/pyauutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES ETP_PRESERVATION_AGE AU , PAY_USER_COLUMN_INSTANCES_F TAX_PERCENT AU ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = HECS, B_LEGISLATION_CODE = AU, USER_TABLE_NAME = HECS, B_LEGISLATION_CODE = AU, ORA-20001: HR_7220_INVALID_PRIMARY_KEY:
------------------------
------------------------
Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @PAY:patch/115/import/pyusertable.lct @PAY:patch/115/import/US/loc_au/pyauutable.ldt ROW_MATCH=SEQUENCE - LEG_VIEW=hr_pay_au_implementation
Connecting to APPS......Connected successfully.
Calling FNDLOAD function.
Returned from FNDLOAD function.
Log file: /xxx/xxx/xxx/apps_st/appl/admin/devhr12/log/loc_au_pyauutable_ldt.log
Error calling FNDLOAD function.
------------------------
loc_au_pyauutable_ldt.log
------------------------
Uploading from the data file /xxx/xxx/xxx/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_au/pyauutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/xxx/xxx/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8), /xxx/xxx/xxx/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_au/pyauutable.ldt) to staging tables
Dumping LCT file /xxx/xxx/xxx//devhr12/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/xxx/xxx//apps_st/appl/pay/12.0.0/patch/115/import/US/loc_au/pyauutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES ETP_PRESERVATION_AGE AU , PAY_USER_COLUMN_INSTANCES_F TAX_PERCENT AU ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = HECS, B_LEGISLATION_CODE = AU, USER_TABLE_NAME = HECS, B_LEGISLATION_CODE = AU, ORA-20001: HR_7220_INVALID_PRIMARY_KEY:
------------------------
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Apply HRMS RUP8 (20000288) .
- Run hrglobal for AU payroll and possible other localizations.
- hrglobal failed with the error.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |