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
npatel29
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.

Report message to a moderator

- 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: 8976
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.

Report message to a moderator

Previous Topic: How to Add a Miscellaneous expenses On an Invoice With Match ?
Next Topic: Problems with HR_SIT_API.UPDATE_SIT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 03 13:49:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.