I need to see when an iban changed in oracle ebs system. Is there a specific log table for that?
SELECT * FROM iby_ext_bank_accounts
I checked this table but ı couldnt find
There is no auditing enabled by default in Oracle EBS for this table. If Audit Trail functionality has been setup for this table, there will be a Shadow Table named iby_ext_bank_accounts_a. Check that table to see if it contains the IBAN column.
Otherwise, please refer to Enabling Oracle E-Business Suite Audit Trail for steps to enable auditing on this application table. Audit Trail will create the Shadow Table and audit triggers to capture changes on the columns defined for auditing.
The Oracle support note E-Business Suite Applications Auditing FAQ For Understanding Data Auditing in Oracle Applications Tables using Audit Trail [ID 69660.1] has more additional information on using the Audit Trail functionality.