Thursday, May 20, 2010

How to delete "Object" in Oracle EBS ? (PREFACE)

After years of working with Oracle EBS, I am really piss off that I cannot delete some objects in the Oracle EBS. Yes, I understand the reason behind, and I'm fully support the decision on this limitation, e.g. you cannot delete Inventory or Engineering Item if this item have been utilized; or you cannot delete OE Transaction Type (or known as Order Type) if it has been used in Sales Orders. Once an object has been referenced, we should keep it in the system, for the sake of data integrity, completeness, auditing, etc. It is a no-brainer, common sense, undoubtedly argument, no room for discussion. period.

However, if an object is not referenced in anywhere, WHY I CANNOT DELETE IT ?

Accidentally we create something we don't want (typo, wrong naming conversion, business rule change, just for testing, trial-and-error, etc). This is human nature that we make mistakes, and sometimes it is beyond our control. However, we want to clean up the mess we created but Oracle don't allow us to do so.

Oracle simply say "You cannot delete XXX once it is created. You can end-date it, disable it, add 'do not use' in object name, tell users not to use it, charge penalty if it is used, give users warning letter if they use it...or whatever way to prevent it from being used by end users."

I WANT IT REMOVED FROM THE SYSTEM. I REALLY WANT TO.

In here I will post a series of blog (label with EBS Delete) to tell how to remove objects in Oracle EBS, even it is not allowed in the GUI or even in API.

Disclaimer: As shown in the Metalink everywhere - please try it in the development instance before deploy it to production. You should full understand the impact and solely responsible for what you do.

1 comment :

Anonymous said...

Belly.. Pimp You can delete each and every Product in Oracle EBS.. if Dont Know Watch the POGO...