How to clean PA_TRANSACTION_CONTROLS
Hi,
As a part of custom process in R12.2.4, we've created transaction controls by using a direct INSERT script, as there is no API.
But we found that some additional PA Transaction controls were also inserted into PA_TRANSACTION_CONTROLS, due to some code issue.
And now we need to clean them(delete). When I verified, I could not delete APIs, or any dependent tables or triggers etc.
So please let me know, if we can clean those unwanted records by just using a DELETE script.
Has anyone tried it? Is this a valid approach?
Thanks,
Siva