R12 E-Business Suite Users Are Unable To Upload a Concurrent Program LDT Datafile Into Target Instance Using FNDLOAD (Doc ID 2106107.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Oracle Concurrent Processing - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.1.3, Basic SysAdmin maintenance functions

 

 

Unable to upload a Concurrent Program LDT datafile using FNDLOAD at the command line.

When trying to migrate a concurrent program using the FNDLOAD utility, the following error is received uploading the LDT file:

ERROR
-----------------------

Uploading from the data file XXFIN_RICEF86_TREASURY_PROG.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/d01/oracle/DEV1/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.14), XXFIN_RICEF86_TREASURY_PROG.ldt) to stage tables
Dump LCT file /d01/oracle/DEV1/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.14) into FND_SEED_STAGE_CONFIG
Dump LDT file XXFIN_RICEF86_TREASURY_PROG.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE XXFIN_RICEF86_TREASURY_PROG XXFIN , PROGRAM XXFIN_RICEF86_TREASURY_PROG XXFIN ) into FND_SEED_STAGE_ENTITY
Upload from stage 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. Use FNDLOAD command to download the Concurrent Program details into a data LDT file from the source instance.
2. Transfer the data LDT file to the target instance.
3. Use FNDLOAD command to upload the Concurrent Program details from data LDT file into the target instance and the issue occurs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users cannot use the same concurrent programs in other instances, as their data is not successfully migrated.

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