Easy methods to Allow Audit Path On Tables in E Enterprise suite R12.2

Not too long ago I got here throughout a
requirement from a buyer the place they needed to allow audit path on EBS
Software. Right now I’ll present learn how to allow it.

Step 1.

For instance, I shall be enabling
auditing on desk AP_CHECKS_ALL

    Navigate to Accountability: System Administrator

  Navigation:   Profile > System

    Question Profile:
‘AuditTrail:Activate’. Click on FIND

    Set it to ‘Sure’ at Website degree.

Step 2.

We shall be enabling Audit
Installations for username. On this case will probably be AP.

Navigate: System Admin > Safety > Audit Path >Set up

Allow Audit Set up for AP

Be aware:-

It is very important hold
“Audit Enabled” for a sure
schema which has been enabled by default.

By default auditing is enabled
for the next schemas. If any of the next schema will not be enabled, it’s
suggested to allow them.

APPLSYS
GL
FA
AP
AR
INV
PO
CE
GMA
GMD
GME
GMF
GMI
GML
GMP
WSH
FV
APPLSYSPUB
ZX

Step 3.

Outline Audit tables and
desired columns.

Earlier than enabling the auditing
on columns, please verify the constraints.

The next are limitations.

A. Most columns 99 for a
given desk. Finest practices are 50 columns or much less because of the quantity of knowledge
that audit path generates.

B. No LONG, RAW, or LONG RAW columns

C. Your audit group should
embody all columns that make up the first key for a desk; these columns
are added to your audit
group robotically.

D. Upon getting added a
column to an audit group, you can not take away it.

E. Audit Path requires two
database connections. In case your working platform doesn’t robotically
help two database connections
(e.g., VMS or MPE/XL), then add the surroundings variable ‘FDATDB=’ to your
surroundings file.

F. As a result of the construction of
the audited desk could change between product variations, Audit Path does NOT
help upgrading present
shadow tables or audited knowledge. Earlier than an improve, it’s best to archive the
shadow tables and carry out all obligatory reporting on the audited
knowledge.

Navigation: System Admin > Safety > Audit Path > Tables

Question for consumer desk identify ‘AP_CHECKS_ALL’ and add
columns on which you wish to allow path do the identical for desk AP_CHECKS_ALL

Step 4:- Outline an Audit Group
and related tables

Navigation: System Admin > Safety > Audit Path
>Teams

Create Audit group for desk outlined
in step 3.

Right here we created an audit group
AP_GROUP_1 and added desk identify AP_CHECKS_ALL and Save. As soon as added , the group state turns into enabled.