My Oracle Support Banner

Incomplete Journal Entry Posted_Date, Missing HH:MM:SS (Doc ID 2745547.1)

Last updated on JANUARY 20, 2021

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.


For some posted Journal Entries the system generated Posted_Date is incomplete.

For example only the MM/DD/YYYY (01/01/2019) is visible, but HH:MM:SS (09:09:19 PM) is missing in the tables

As the Journals posted date may be incomplete, what other date can be used to understand when transactions were posted in order to be able to retrieve incremental data from the last Posting?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.