Dbms_fga.add_policy audit
I have enabled audit on the table FND_USER using dbms_fga.add_policy for description and email_address columns using below signature
DBMS_FGA.ADD_POLICY( OBJECT_SCHEMA => 'APPLSYS', OBJECT_NAME => 'FND_USER', POLICY_NAME => 'XX_FND_USER_POL', AUDIT_CONDITION => 'APPS.XX_PRIVACY_LOGGIN_DISABLE=0', AUDIT_COLUMN => 'EMAIL_ADDRESS, DESCRIPTION', ENABLE => TRUE, STATEMENT_TYPES => 'SELECT,INSERT,UPDATE,DELETE');
to my understanding both columns should appear in the table all_audit_policies in audit_column. but for me only email address is showing. however auditing is happening on both. can someone explain this?
i checked the article https://docs.oracle.com/database/121/ARPLS/d_fga.htm#ARPLS66348