LAST_UPDATE_DATE on GL_BALANCES/GL_DAILY_BALANCES Shows Stale Data For Large Batches
Last updated on JANUARY 25, 2018
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
When posting journal batches, it appears that the application stores the last_updated timestamp in a variable. When the data is committed to the database, this "saved" variable is used. If the batch is large and the statement took 20+ minutes to complete, the last_updated timestamp contains a value that is 20+ minutes in the past.
Currently, the last_update_date on gl_balances/gl_daily_balances tables is the timestamp corresponding to statement from:
That is right before glpfdel() module.
Another situation, would be when the last_update_date is not updated but some period_aggregate amount values have changed.
The need is to have the last_update_date column in gl_balances, respectively gl_daily_balances assigned with a value of sysdate/systimestamp so as to reflect the correct timestamp at time of completing the posting request.
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