My Oracle Support Banner

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 FEBRUARY 12, 2019

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
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 PROG.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (<DIR>/afcpprog.lct(120.2.12010000.14), PROG.ldt) to stage tables
Dump LCT file <DIR>/afcpprog.lct(120.2.12010000.14) into FND_SEED_STAGE_CONFIG
Dump LDT file PROG.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE PROG, PROG ) 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.

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.