Applying Patch 21900901 Fails With ORA-24816 When Running Bomprg.ldt And Pqpzzcncprg00025.ldt Files (Doc ID 2292382.1)

Last updated on AUGUST 04, 2017

Applies to:

Oracle Applications DBA - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On :  12.2.6 version, Upgrade related issues

The following Error is generated when applying Patch: 21900901, bomprg.ldt and pqpzzcncprg00025.ldt are failing.

The error occurred while executing the following statement:
  INSERT INTO FND_SEED_STAGE_ENTITY
Uploading from the data file /test0/48p/apptop/PREPROD/fs1/EBSapps/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpzzcncprg00025.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/test0/48p/apptop/PREPROD/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.7.12020000.7), /test0/48p/apptop/PREPROD/fs1/EBSapps/appl/pqp/12.0.0/patch/115
/import/US/loc_gb/pqpzzcncprg00025.ldt) to staging tables
Dumping LCT file /test0/48p/apptop/PREPROD/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.7.12020000.7) into FND_SEED_STAGE_CONFIG
Dumping LDT file /test0/48p/apptop/PREPROD/fs1/EBSapps/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpzzcncprg00025.ldt into FND_SEED_STAGE_ENTITY
A database error occurred:
  ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

The issue can be reproduced at will with the following steps:
1. Apply Patch 21900901 12.2.6: ORACLE E-BUSINESS SUITE 12.2.6 RELEASE UPDATE PACK

Changes

Upgrading to 12.2.6

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