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 JULY 17, 2024

Applies to:

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 /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 (apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13), /apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payzzcncprg00274.ldt) to staging tables
Dumping LCT file /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 /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 /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 (/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.13), /apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_ca/payzzcncprg00365.ldt) to staging tables
Dumping LCT file /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 /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 /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 (/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 /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 /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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.