For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi,
We have enabled the external and internal bank account auditing last year and we would like to know only the changed bank account number and bank branch details from the account audit tables.
I'm currently referring this table - IBY_EXT_BANK_ACCOUNTS_ , but I see some rows with bank account numbers with NULL bank branch ID and some rows with branch IDs and null account numbers displayed with Audit action type as 'Update' along with AUDIT_CHANGE_BIT_MAP_ as 0.
Could you help me understand this audit table and guide how to extract the bank account number and bank branch changes alone, please?
Regards,
Sathya Kannan
You may also want to see if you can use the following Audit Report showing changes to the Supplier Master:
Path is Tools / Audit Reports
Enter a date range
Enter a Product of "Supplier Model".
Report shows who made the change and what the change was.
We have been using the report to help our audits - the report seems accurate so far.
Phil
Thanks Phil, We haven't enabled the Supplier model audit policy for Supplier bank accounts.
You may also want to see if you can use the following Audit Report showing changes to the Supplier Master:
Path is Tools / Audit Reports
Enter a date range
Enter a Product of "Supplier Model".
Report shows who made the change and what the change was.
We have been using the report to help our audits - the report seems accurate so far.
Phil