My Oracle Support Banner

Patch 18843706 Failed On 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 MAY 05, 2021

Applies to:

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

Symptoms

On : 12.1.3 , Patch Application Issues

While applying Patch 18843706 a worker failed with the following error while running the file cspprg.ldt:

ERROR
-----------------------
Uploading from the data file /<DIR>/csp/12.0.0/patch/115/import/US/cspprg.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/<DIR>/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15), /<DIR>/csp/12.0.0/patch/115/import/US/cspprg.ldt) to staging tables
Dumping LCT file /<DIR>/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15) into FND_SEED_STAGE_CONFIG
Dumping LDT file /<DIR>/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



Changes

 

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
Changes
Cause
Solution
References


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