E1: CFR11: All the Columns Of Audited Table F554101T is not Listed in P9500003 Application But They Can be Viewed In A554101T Via Universal Table Browser (UTB) (Doc ID 2978298.1) (Doc ID 2978298.1)

Last updated on OCTOBER 09, 2023

Applies to:

Symptoms

Auditing is enabled successfully for few tables across multiple pathcodes. But for one table (F554101T), all the columns included in auditing table is not listed in P9500003 application. However these missing columns can be viewed in A554101T via Universal Table Browser (UTB). This issue is happening in the production environment/pathcode.

This table has auditing enabled in other environment/pathcodes as well.

User tried to re-enable auditing on F554101T by following the below steps, but it didn't help to resolve the issue.

Steps to Replicate:

1. Stop the production JAS instance services via Server Manager
2. Take Back up of F554101T, A554101T.
3. Disable Audit for F554101T via P9500003 application
4. Delete the records for F554101T from F9500001 and A554101T from F9860 and F9861 for PD920
5. Restart the production JAS instance and Enterprise server for PD920
6. Enable audit on F554101T
7. All Columns are visible in A554101T when viewed via UTB, but not in P9500003

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.