Oracle 12.1
I have many entries in the sys.aud$ table with a returncode of 904 (invalid identifier) and the action is 47 (PL/SQL Execute). There is many entries for one particular table.
I've attempted to use fine grain auditing for this table. However, that only captures insert,update,delete,selects.
though the errors are showing up in the standard audit logs the only statement I see in the FGA logs in an INSERT statement that works successfully.
short of turning on AUDIT_TRAIL=DB,EXTENDED is there a way to find the SQL text that is causing the 904 errors?
Thanks,
Gerry.