E1: CFR11: Unable to Enable Auditing On Any EnterpriseOne Table (Ex: F0006) Error: OCI0000178 - Unable to execute - SELECT * FROM SY920.F9500001 (Doc ID 3066208.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

Unable to enable auditing on any Enterpriseone table. While trying to enable auditing on F0006 table, below error is captured in the jde logs,

 Steps to Replicate:

1. Login to Fat Client

2. Enter P9500003 in the Fast Path, or enter GH9091 and then select the Audit Table Configuration menu.

3. On the Work with Audit Table Configuration form, click Add.

4. On the Audit Table Setup Director, click Next.

5. On the JD Edwards EnterpriseOne Table Selection form, in the Table Name field, enter F0006 table, and then click Next.

6. On the Audit Table Information form, make changes to the default values, and then click Next.

7. Do the required changes to the table in TDA mode

8. Enable audit via the "Enable Audit" option on the Row Exit.

This process fails to enable audit.

Cause

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