Home » Applications » Oracle Fusion Apps & E-Business Suite » Deleteing Data from TCA tables (EBS R12)
Deleteing Data from TCA tables [message #506354] Sun, 08 May 2011 20:50 Go to next message
Messages: 1
Registered: May 2011
Location: Brisbane Australia
Junior Member
As part of migration from SQL Server system, we are creating data in the EBS (TCA) tables using APIs. Is there a way to delete this data as well so we can re-run the migration in test environment multiple times.

Thanks in advance.
Re: Deleteing Data from TCA tables [message #506427 is a reply to message #506354] Mon, 09 May 2011 04:42 Go to previous message
John Watson
Messages: 8738
Registered: January 2010
Location: Global Village
Senior Member
It is difficult (probably impossible) to "delete" the results of your test, because of all the dependencies.
Probably the best way is to use Database Flashback: get the DB into the state you want at the start of a test run, and create a savepoint. then you can test and flashback as often as necessary.
Previous Topic: How to Add a Miscellaneous expenses On an Invoice With Match ?
Next Topic: Problems with HR_SIT_API.UPDATE_SIT
Goto Forum:

Current Time: Thu Aug 18 14:32:25 CDT 2022