Patch 18843706 Worker Failed With File Cspprg.ldt With Error "PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW'"

(Doc ID 2369193.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

Patch 18843706 worker failed with file cspprg.ldt with the following error


ERROR
-----------------------
Uploading from the data file /tchn4i/applmgr/1200/csp/12.0.0/patch/115/import/US/cspprg.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/tchn4i/applmgr/1200/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15), /tchn4i/applmgr/1200/csp/12.0.0/patch/115/import/US/cspprg.ldt) to staging tables
Dumping LCT file /tchn4i/applmgr/1200/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15) into FND_SEED_STAGE_CONFIG
Dumping LDT file /tchn4i/applmgr/1200/csp/12.0.0/patch/115/import/US/cspprg.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE TEST1 PER , PROGRAM CSPTRPKL_XML CSP ) 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. Using AD Online Patching Utility Apply Patch 18843706
2. See the ad worker log file



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