CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

How to disable and remove audit tables in an environment without disabling CFR Pat 11

Hi,

We have CFR Part11 enabled in our Dev (DV) environment. We want to disable table audit for the current tables getting audited and remove them but keeping the environment audit information intact(enabled) so that we can create table audit again in future in the same environment.

The steps I can see is:

  1. Disable auditing in DV at table level using P9500003
  2. Dropping audit Views.
  3. Dropping audit triggers.
  4. Renaming base tables.
  5. Dropping CFR11 shadow columns.

Am I missing anything?

Thanks,

Jyotirmoy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center