I thought of raising this question this forum instead of the DB forum as I would like to identify all Insert/Update statements for a particular PeopleSoft application table.
We are facing this peculiar issue in production and Oracle GSC is unable to replicate and hence provide very little assistance.
The table that is in question is PS_PAY_MISC_DST for which I need to find out all the Inserts/Updates that were made on this table to be able to isolate the problem. SYSDBA access rights are available with me.
I say the problem is peculiar because we cannot replicate it in any of SDLC environments and neither can Oracle GSC replicate it in Demo. But the issue still persists and happens every month end.
You could apply insert/update audit on the table
Or even better fine grained auditing (much more detailed) :
Unfortunately option to audit the table is not available as this is production . I was wondering if the SQL statements could be retrieved from the V$ tables.
I am not sure as to which V$ tables will be involved.
I completely agree with your point on fga, but under the current situation I have been asked to present a justification to have FGA applied in production, and they would go through the SDLC to have this applied.
I was hoping to skip that route completely and was hoping gather the Insert/Update statements on that table.