How To Purge Project Accounting (PA) Data From The FND_LOBS Table? (Doc ID 2707272.1)

Last updated on SEPTEMBER 20, 2024

Applies to:

Goal

Data needs to be purged from the FND_LOBS table, many of the records are with expiration date as NULL.
There are also records related to Project Accounting (PA).

ENTITY_NAME                                  SIZE_BYTES          COUNT(*)
----------------------------------------   ----------             ----------
PA_PROGRESS_REPORTS                  1.43219              25865
PA_BUDGET_VERSIONS                     2.93434              6446
PA_PROJECTS                                 2.23964              2621
 

How can this data be purged?

Solution

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