GLXJEENT: Enter Journal Fails When Selecting the Category with Error: ORA- 06512 : in APPS.GL_AUTOREVERSE_OPTIONS_PKG
Last updated on MAY 29, 2017
Applies to:Oracle General Ledger - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
Form:GLXJEENT.FMB - Enter Journals/Encumbrances
When selecting the category, while creating new manual journal in General Ledger ( Journals > Enter),
the following error occurs.
"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 "
The issue can be reproduced at will with the following steps:
1. Responsibility: General ledger
2. Journals -> Enter -> New journal
3. Select Category
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms