My Oracle Support Banner

E1: CFR11: Enabling Auditing on a Table from Application P9500003 Fails with Application Still Displaying 'Auditing Disabled' and 'Error - ORA-01031: insufficient privileges' in jde.log (Doc ID 2781878.1)

Last updated on JUNE 07, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 to 9.1 [Release 8.98 to 9.1]
Information in this document applies to any platform.

Symptoms

In 8.98..x tools release when attempting to enable auditing on a table with Oracle Database from application P9500003 - Work With Audit Table Configurations, no error is thrown but process fails as the application still displays 'Auditing Disabled' against the A* object name. 

The following error is seen in the jde.log of the fat client where this operation is done. 


Steps

  1. The pre-requisite setup is done as mentioned in E1: CFR11: The Tutorial for Table Auditing for an Oracle Database (Doc ID 2298609.1
  2. Login to the Fat client in the environment where auditing is enabled.
  3. Enter "P9500003" in the fast path to run the "Work With Audit Table Configurations" application.
  4. Click on the "Find" button.  Then expand the "FXXX" tree node.  Then highlight the "AXXX" child node.  Then click on the "Enable DB Auditing" row exit button.
  5. Check the results 

Changes

 Auditing was enabled on a table .

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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