How to purge/delete customer information for Oracle Receivables?

At this time there is no functionality available to purge/delete customer information from Oracle Receivables and hence Oracle support can not provide a script to delete the customers incorrectly loaded or the customer that will never be used. Customer information is stored in about 20 to 25 tables. It is not supported solution to delete the record from the database by any unsupported means.

The only option you have is to inactivate those customers and addresses. You can use TCA APIs to do so.

The other workaround option is difficult but you can try. It is to merge all those unwanted customers into a dummy customer with 'Delete After Merge' checked.

--> And that one works, for us !!!!. Be sure to backup and check the backup

Archiving and Purching

We know have almost 10 years of administration in our Oracle EBS Installation. It is time to start purging know. I will blog about my steps in the process. I think this will become a issue for every company. Storage is cheap in hardware but costy in maintaining and supporting.