R12 GLXJEENT Journal Entry Find Journals Errors with FRM-40738 GET_GROUP_CHAR_CELL Cannot Be Null (Doc ID 565598.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 12.0.4 and later
Information in this document applies to any platform.
FORM:GLXJEENT.FMB - Enter Journals/Encumbrances

Symptoms

When attempting to query records on the Find Journals form, where there are 4 original journals and 4 reversal journals, the following error occurs.

ERROR - FRM-40738 Arguement 2 to builtin GET_GROUP_CHAR_CELL cannot be null

STEPS
The issue can be reproduced at will with the following steps:
1. Navigate to the enter journals form.
2. On the find window, do not enter any search criteria and click find
3. The error is displayed.
4. After acknowledging the message 4 times the 4 original journals are displayed, but the 4 reversal journals are not displayed.
It seems the message is displayed once for each journal that is not displayed.

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