My Oracle Support Banner

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.

Goal

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

Solution

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
Goal
Solution
References


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