My Oracle Support Banner

How To Purge FND_LOBS "export" Records With No EXPIRATION_DATE (Doc ID 2768387.1)

Last updated on APRIL 13, 2021

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

There is old data in the FND_LOBS table with the PROGRAM_NAME of 'export' that do not have an EXPIRATION_DATE set.
When running "Purge Obsolete Generic File Manager Data" to clean up 'export' data, if run with "Expired" Parameter of "Yes", these records are not getting picked up and purged.

The records are old, and are no longer needed, so how to clean them up?

Changes

 

Cause

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
Symptoms
Changes
Cause
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.