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.
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.
- The pre-requisite setup is done as mentioned in E1: CFR11: The Tutorial for Table Auditing for an Oracle Database (Doc ID 2298609.1)
- Login to the Fat client in the environment where auditing is enabled.
- Enter "P9500003" in the fast path to run the "Work With Audit Table Configurations" application.
- 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.
- Check the results
Auditing was enabled on a table .
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