GLXJEENT: Enter Journal Fails When Selecting the Category with Error: ORA- 06512 : in APPS.GL_AUTOREVERSE_OPTIONS_PKG (Doc ID 752978.1)

Last updated on MAY 29, 2017

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Form:GLXJEENT.FMB - Enter Journals/Encumbrances


Symptoms


When selecting the category, while creating new manual journal in General Ledger ( Journals > Enter),
the following error occurs.

ERROR


"The procedure HEADER.accrual_rev_change_sign_flag has produce an exception.
The procedure HEADER.user_je_category_name has produced an exception (WHEN-VALIDATE-ITEM )

ORA- 014003 : No data Found
ORA- 06512 : in "APPS.GL_AUTOREVERSE_OPTIONS_PKG" line 23
ORA- 06512 : in "APPS.GL_AUTOREVERSE_OPTIONS_PKG" line 336

FRM-40735: The trigger WHEN-VALIDATE-ITEM has produce an exception ORA- 014003 "

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility: General ledger
2. Journals -> Enter -> New journal
3. Select Category

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