Core Concurrent Processing - EBS (MOSC)

MOSC Banner

When run the "Audit Trail Update Tables" program on custom tables, whether it is necessary to grant

edited Feb 2, 2015 8:54PM in Core Concurrent Processing - EBS (MOSC) 1 commentAnswered ✓

I have enabled the audit trail on custom table, when ran the cocurrent program AuditTrail Update Tables, get below error.....

Fatal error in fdasql, quitting...

ORA-24344: success with compilation error

Fatal error in fdactr, quitting...

Fatal error in fdactr, quitting...

However, when add the below grant manually......it works fine....that mean it will create all objects without any issues....

GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON NAPPCUST.NAPP_CUSTOM_TABLE_PURGE__A TO APPS;

So want to know:

==============

When run the "Audit Trail Update Tables" program on custom tables, whether it is necessary

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