My Oracle Support Banner

oklcat17.ldt Errors With ORA-04088: error during execution of trigger 'APPS.GL_AUTOREVERSE_OPTIONS_AI' (Doc ID 2659765.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Lease and Finance Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms



When attempting to apply Patch 24690690 ORACLE E-BUSINESS SUITE 12.2.7 RELEASE UPDATE PACK the following error occurs:

ERROR
-----------------------
FNDLOAD APPS/***** 0 Y UPLOAD @SQLGL:patch/115/import/glmlscat.lct @OKL:patch/115/import/US/oklcat17.ldt

Error details:-
Uploading from the data file <DIRECTORY_PATH>/patch/115/import/US/oklcat17.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (<DIRECTORY_PATH>/patch/115/import/glmlscat.lct(120.4.12020000.3), <DIRECTORY_PATH>/patch/115/import/US/oklcat17.ldt) to staging tables
Dumping LCT file <DIRECTORY_PATH>/patch/115/import/glmlscat.lct(120.4.12020000.3) into FND_SEED_STAGE_CONFIG
Dumping LDT file <DIRECTORY_PATH>/patch/115/import/US/oklcat17.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (GL_JE_CATEGORIES Lease Funding , GL_JE_CATEGORIES Lease Funding ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = Lease Funding, ORA-01722: invalid number
ORA-06512: at "APPS.GL_AUTOREVERSE_OPTIONS_AIP", line 16
ORA-06512: at "APPS.GL_AUTOREVERSE_OPTIONS_AI", line 1
ORA-04088: error during execution of trigger 'APPS.GL_AUTOREVERSE_OPTIONS_AI'
ORA-06512: at "APPS.GL_AUTOREVERSE_OPTIONS_PKG", line 237
ORA-06512: at "APPS.GL_JE_CATEGORIES_PKG", line 278
ORA-06512: at "APPS.GL_JE_CATEGORIES_PKG", line 397
ORA-06512: at "APPS.GL_JE_CATEGORIES_PKG", line 648
ORA-01403: no data foundv


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 24690690 to upgrade to 12.2.7, or possibly any patch with oklcat17.ldt



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


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