My Oracle Support Banner

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

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Project Foundation - Version 12.2.8 and later
Information in this document applies to any platform.

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

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


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