STG_FIF_GL_PURGE_JOB Is Not Truncating Old Data
(Doc ID 2847242.1)
Last updated on FEBRUARY 11, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.
STG_FIF_GL_PURGE_JOB is not truncating old data.
STG_FIF_GL_PURGE job is not purging old data. It is expected to keep 14 days of old data per standard oracle configuration.
Steps To Validate:
STG_FIF_GL_PURGE job is set up run in cycle 1, which currently kicks off at 6:00 AM EST.
1 -- Make sure STG_FIF_GL_DATA has ReSA GL data which is older than 14 days
2 -- run STG_FIF_GL_PURGE_JOB
3 -- Notice old data is still retained in the table
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