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 NOVEMBER 08, 2022
Applies to:Oracle General Ledger - Version 220.127.116.11 to 18.104.22.168 [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
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