Hrglobal Fails Loading Pyusfedtaxut.ldt with ORA-20001: HR_72033_CANNOT_DNC_RECORD Error (Doc ID 2224156.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle HRMS (US) - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

Hrglobal fails loading pyusfedtaxut.ldt with the following error.

Uploading from the data file /XXXX/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/US/loc_us/pyusfedtaxut.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/XXXX/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.5.12020000.8), /XXXX/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/US/loc_us/pyusfedtaxut.ldt) to staging tables
Dumping LCT file /XXXX/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.5.12020000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /XXXX/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/US/loc_us/pyusfedtaxut.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES Federal Tax Standard Deduction Table US , PAY_USER_COLUMN_INSTANCES_F Exemption Amount US ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = Federal Tax Standard Deduction Table, B_LEGISLATION_CODE = US, USER_TABLE_NAME = Federal Tax Standard Deduction Table, B_LEGISLATION_CODE = US, ORA-20001: HR_72033_CANNOT_DNC_RECORD:

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Run hrglobal.drv.
  2.  Worker job fails loading pyusfedtaxut.ldt.



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