PNTABREG.ldt fails when Attempting to Apply Patch 3653484 (Doc ID 1315474.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Property Manager - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


When attempting to apply <Patch 3653484>,
pntabreg.ldt fails with the following error:

ERROR
-----------------------
Uploading from the data file /usr/local/oracle/apps1/gisappl/pn/11.5.0/patch/115/import/US/pntabreg.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/usr/local/oracle/apps1/gisappl/fnd/11.5.0/patch/115/import/afdict.lct(115.16), /usr/local/oracle/apps1/gisappl/pn/11.5.0/patch/115/import/US/pntabreg.ldt) to staging tables
Dumping LCT file /usr/local/oracle/apps1/gisappl/fnd/11.5.0/patch/115/import/afdict.lct(115.16) into FND_SEED_STAGE_CONFIG
Dumping LDT file /usr/local/oracle/apps1/gisappl/pn/11.5.0/patch/115/import/US/pntabreg.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_TABLE PN TABLES PN_ADDRESSES_ALL , FND_COLUMN ATTRIBUTE4 ) into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_COLUMN ATTRIBUTE5 , FND_FOREIGN_KEY PN_PAYMENT_TERMS_HISTORY_FK4 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for FND_COLUMN: APPLICATION_SHORT_NAME = PN, BUILDING_BLOCK_NAME = TABLES, TABLE_NAME = PN_VAR_CONSTRAINTS_ALL, COLUMN_NAME = CONSTR_CAT_CODE, ORA-12899: value too large for column "APPLSYS"."FND_COLUMNS"."DESCRIPTION" (actual: 246, maximum: 240)
Error loading seed data for FND_COLUMN: APPLICATION_SHORT_NAME = PN, BUILDING_BLOCK_NAME = TABLES, TABLE_NAME = PN_VAR_DEDUCTIONS_ALL, COLUMN_NAME = DEDUCTION_TYPE_CODE, ORA-12899: value too large for column "APPLSYS"."FND_COLUMNS"."DESCRIPTION" (actual: 246, maximum: 240)
Error loading seed data for FND_COLUMN: APPLICATION_SHORT_NAME = PN, BUILDING_BLOCK_NAME = TABLES, TABLE_NAME = PN_VAR_GRP_DATES_ALL, COLUMN_NAME = INV_END_DATE, ORA-12899: value too large for column "APPLSYS"."FND_COLUMNS"."DESCRIPTION" (actual: 244, maximum: 240)
Error loading seed data for FND_COLUMN: APPLICATION_SHORT_NAME = PN, BUILDING_BLOCK_NAME = TABLES, TABLE_NAME = PN_VAR_LINES_ALL, COLUMN_NAME = ITEM_CATEGORY_CODE, ORA-12899: value too large for column "APPLSYS"."FND_COLUMNS"."DESCRIPTION" (actual: 246, maximum: 240)
Error loading seed data for FND_COLUMN: APPLICATION_SHORT_NAME = PN, BUILDING_BLOCK_NAME = TABLES, TABLE_NAME = PN_VAR_RENTS_ALL, COLUMN_NAME = PURPOSE_CODE, ORA-12899: value too large for column "APPLSYS"."FND_COLUMNS"."DESCRIPTION" (actual: 246, maximum: 240)
Error loading seed data for FND_COLUMN: APPLICATION_SHORT_NAME = PN, BUILDING_BLOCK_NAME = TABLES, TABLE_NAME = PN_VAR_VOL_HIST_ALL, COLUMN_NAME = ACTUAL_GL_ACCOUNT_ID, ORA-12899: value too large for column "APPLSYS"."FND_COLUMNS"."DESCRIPTION" (actual: 241, maximum: 240)


Concurrent request completed
Current system time is Tue Apr 12 16:09:32 2011

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