Patch 24760000 US & CANADA END OF YEAR 2016 STATUTORY UPDATE I FOR R12.1 Failed on File payzzcncprg00274.ldt, payzzcncprg00365.ldt, payzzcncprg00034.ldt With ORA-06550 & PLS-00306 (Doc ID 2189246.1)

Last updated on OCTOBER 12, 2016

Applies to:

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

Symptoms

When attempting to apply patch 24760000(US & CANADA END OF YEAR 2016 STATUTORY UPDATE I FOR R12.1)
the following error occurs.

ERROR
-----------------------
Uploading from the data file /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00274.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/nfs/ptch/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13), /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00274.ldt) to staging tables
Dumping LCT file /nfs/ptch/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13) into FND_SEED_STAGE_CONFIG
Dumping LDT file /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00274.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE PYUGEN PAY , INCOMPATABILITY PAYLEGDEL PAY ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error parsing the generated plsql wrapper statement ORA-06550: line 782, column 9:
PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW'
ORA-06550: line 782, column 9:
PL/SQL: Statement ignored


Uploading from the data file /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_ca/payzzcncprg00365.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/nfs/ptch/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13), /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_ca/payzzcncprg00365.ldt) to staging tables
Dumping LCT file /nfs/ptch/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13) into FND_SEED_STAGE_CONFIG
Dumping LDT file /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_ca/payzzcncprg00365.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE PYCAYEER PAY , INCOMPATABILITY PAYLEGDEL PAY ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error parsing the generated plsql wrapper statement ORA-06550: line 782, column 9:
PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW'
ORA-06550: line 782, column 9:
PL/SQL: Statement ignored

Uploading from the data file /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00034.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/nfs/ptch/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13), /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00034.ldt) to staging tables
Dumping LCT file /nfs/ptch/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13) into FND_SEED_STAGE_CONFIG
Dumping LDT file /nfs/ptch/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00034.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE PYUGEN PAY , INCOMPATABILITY PAYLEGDEL PAY ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error parsing the generated plsql wrapper statement ORA-06550: line 782, column 9:
PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW'
ORA-06550: line 782, column 9:
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applying patch 24760000

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