Null Value in Audit Table - FA

  Background:

1. 3 base tables ( FA_BOOKS, FA_ADDITIONS_B, FA_DISTRIBUTION_HISTORY) are set up for audit ----> The audit table (BASETABLENAME_A) for these 3 tables have been created by application.

2. Associated with the above tables _AC and _AV views are also created by application. ( What is signifance of these views. I am seeing there are multiple views are created with suffix as AV and different numbers )

 

Expectation  - The audit table (BASETABLENAME_A) columns should contain data changes explained as per note enclosed from Oracle.

 

Findings      

1. Table is showing only NULL values in audit columns

 

2. _AC is tracking data change