Projects - EBS (MOSC)

MOSC Banner

How to clean PA_TRANSACTION_CONTROLS

edited Mar 23, 2016 5:04AM in Projects - EBS (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center