EGL 9.2 : Field DATE_CODE In OPEN_ITEM_GL Record Is Blank

(Doc ID 1969708.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Online journal data in OPEN_ITEM_GL table has BLANK date_code value, whereas, spread sheet journals have DATE_CODE as 0.

DATE_CODE should be populated for both online and spreadsheet journals when they have open item key populated.

The issue can be reproduced at will with the following steps:
1. Create an Online journal with open items keys. Edit and post.
2. Create a Spreadsheet Journal with matching open item keys (as online journal). Edit and post.
3. Notice in OPEN_ITEM_GL table for online journal Date Code is blank vs. in spreadsheet journal Date Code is 0.
4. Run Open Items Recon process.
5. Create new online journal to offset previous online journal
6. Open Item Status – online journals now has balance 0.00, spreadsheet journal still have open balance.


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