sqloracle-databaseoracle11goracle-ebsoracle-sql-data-modeler

Is there a table in Oracle Ebs that keeps the change log of the iban information?


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


Solution

  • 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.

    1. Set Audit Trail: Activate profile option to True
    2. Select or create the Audit Installation
    3. Select or create the Audit Group and set to Enabled Requested
    4. Use the Audit Tables window to select the additional column(s) to audit
    5. Run the Audit Trail Update Tables Report to activate changes

    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.