BR100- Audit Setup

7/23/2019 BR100- Audit Setup

http://slidepdf.com/reader/full/br100-audit-setup 1/18

AIM

BR.100 ORACLE AUDIT SETUP

TABCORP

CR 109 Oracle Audit Setup

Author Sa!"ee# Thaira!i

Creatio! Date $9%0&%$00'

La(t Updated 1%10%$01)

Docu*e!t Re+ BR100,Audit-Setup

er(io! 1.0

Approved by:



BR.100

Name Position Signature Date

Patrick O'Doherty Erp Technical

Solutions

Architect

CR 109 Oracle Audit Setup/ile Re+ 00$&'2.doc

Co*pa!3 Co!4de!tial , /or i!ter!al u(e o!l3

Oracle Audit Setup 5 De4!e Audit /ield( ii o+ 12



BR.100

Process Review Summary Template

DELIVERABLE NAME: BR100 Oracle Audit Setup

PROJECT AREA: Cha!e Re"ue#t#

DOC$MENT VERSION: 1%0

DATE S$BMITTED:REVIE&ED B': RESPONSE RECEIVED B':

•

DOC$MENT VERSION: 1%0

DATE S$BMITTED:REVIE&ED B': RESPONSE RECEIVED B':

• •

DOC$MENT VERSION:

DATE S$BMITTED:

REVIE&ED B':

SI(NAT$RE:

DATE SI(NED O)):



Oracle Audit Setup 5 De4!e Audit /ield( iii o+ 12



BR.100

Document Control

Change Record

Date Author Version

Change Reference

$9,Ma3,0'

Sa!"ee# Thaira!i 1.0 6o Pre#iou( Docu*e!t

Reviewers

Name Position

Patrick O'Doherty ERP Tech!ical Solutio! Architect

Distribution

CopyNo

Name !ocation

1 Li7rar3 Ma(ter Pro"ect Li7rar3

$ Pro"ect Ma!a8er



Oracle Audit Setup 5 De4!e Audit /ield( i# o+ 12



BR.100

CopyNo

Name !ocation

Note To "olders#

I+ 3ou recei#e a! electro!ic cop3 o+ thi( docu*e!t a!d pri!t it out plea(e :rite 3our !a*e o! the e;ui#ale!t o+ theco#er pa8e +or docu*e!t co!trol purpo(e(.

I+ 3ou recei#e a hard cop3 o+ thi( docu*e!t plea(e :rite 3our !a*e o! the +ro!t co#er +or docu*e!t co!trol purpo(e(.



Oracle Audit Setup 5 De4!e Audit /ield( # o+ 12



BR.100

Co!te!t(

Proce(( Re#ie: Su**ar3 Te*plate...........................................................iii

Docu*e!t Co!trol......................................................................................i#

Applicatio! Setup Co!trol Sheet 5 Oracle Audit Setup................................'

Oracle Audit Setup 5 Setup Pro4le Optio!(.................................................2

Oracle Audit Setup 5 I!(tall Applicatio!(................ .............. .......... .......... .9

Oracle Audit Setup 5 De4!e Audit <roup(................................................10

Oracle Audit Setup 5 De4!e Audit /ield(................................................ ..1

Oracle Audit Setup 5 Ru! the Audit Trail Update Ta7le( Report.................1'

Ope! a!d Clo(ed I((ue( +or thi( Deli#era7le.............................................12

Ope! I((ue(.........................................................................................12

Clo(ed I((ue(.......................................................................................12



Oracle Audit Setup 5 De4!e Audit /ield( #i o+ 12



Application Setup Control Sheet $ %racle Audit Setup

&nvironment Name# 'achine# Type (de)nition*e+ecution* or both,#

-or./lowSub -or.0ow Name

Setup Tas. Responsibility Due Date 1AResponsibility

1ADueDate

SignatureApproval

%racle Audit Setup Setup Pro)le %ptions

2nstall Applications

De)ne Audit 3roups=

De)ne Audit /ields

Run the Audit Trail 4pdateTables Report

/ile Re+ 00$&'2.docCo*pa!3 Co!4de!tial , /or i!ter!al u(e o!l3

Oracle Audit Setup 5 De4!e Audit /ield( ' o+ 12



%racle Audit Setup $ Setup Pro)le %ptions

System Administrator Pro)le System>Cu(to*er Short 6a*e? Proce((

>Proce(( 6a*e?

Bu(i!e(( Area >Bu(i!e(( Area?

Date >Date?

Co!trol 6u*7er >Co!trol 6u*7er?

Priorit3@ M L >Priorit3 @ M L?

Proce(( O:!er >Proce((

O:!er?

Pro)le %ption nameAuditTrailActi#ate

Site e(


Oracle Audit Setup 5 De4!e Audit /ield( 2 o+ 12



%racle Audit Setup $ 2nstall Applications

System Administrator Security AuditTrail $5 2nstall>Cu(to*er Short 6a*e? Proce((

>Proce(( 6a*e?


Date >Date?



Proce(( O:!er >Proce(( O:!er?

%racle4serName

R Description Oracle u*a!Re(ource( Accou!t

Audit&nables

Checed

%racle4serName

PO Description Oracle Purcha(i!8Accou!t

Audit&nables

Checed

%racle4serName AP Description Oracle Pa3a7le(Accou!t Audit&nables Checed





%racle Audit Setup $ De)ne Audit 3roups

System Administrator Security AuditTrail 3roups>Cu(to*er Short 6a*e? Proce((

>Proce(( 6a*e?


Date >Date?


Priorit3@ M L >Priorit3 @ M

L?

Proce(( O:!er >Proce(( O:!er?

"R Audit 3roup

Application Name u*a! Re(ource(

Audit 3roup TC R Audit Trail

3roup State E!a7le Re;ue(ted @De+ault

Description Audit Trail <roup +or R%Pa3roll Ite*(

Audit Trables

4ser Table Name PA-PERSO6AL-PAME6T-METODS-/

Table Name PA-PERSO6AL-PAME6T-METODS-/

Application Pa3roll

Description Per(o!al pa3*e!t *ethod detail( +or

a! e*plo3ee.

4ser Table Name PER-ASSI<6ME6TS-/

Table Name PER-ASSI<6ME6TS-/

Application u*a! Re(ource(

Description E*plo3ee a!d applica!t a((i8!*e!tdetail(.

4ser Table Name PER-PEOPLE-/





Table Name PER-PEOPLE-/


Description DateTraced ta7le holdi!8 per(o!ali!+or*atio! +or e*plo3ee( applica!t(a!d other people.

4ser Table Name PER-PA-PROPOSALS

Table Name PER-PA-PROPOSALS


Description Salar3 propo(al( a!d per+or*a!cere#ie: i!+or*atio! +or e*plo3eea((i8!*e!t(.





Vendor Audit 3roup

Application Name Purcha(i!8

Audit 3roup TC e!dor Audit Trail

3roup State E!a7le Re;ue(ted @De+ault

Description Ta7corp Audit TRail o! e!dor Detail(.

Audit Tables

4ser Table Name PO-E6DORS

Table Name PO-E6DORS

Application Purcha(i!8

Description Supplier(

4ser Table Name AP-BA6-ACCOU6T-USES

Table Name AP-BA6-ACCOU6T-USES

Application Pa3a7le(

Description I!+or*atio! a7out 7a! accou!t u(e73 Oracle Pa3a7le( a!d OracleRecei#a7le( applicatio!(


Oracle Audit Setup 5 De4!e Audit /ield( 1$ o+ 12



%racle Audit Setup $ De)ne Audit /ields

System Administrator Security AuditTrail Tables>Cu(to*er Short 6a*e? Proce((

>Proce(( 6a*e?


Date >Da



Proce(( O:

>Pro

1uery the tables as below and enter the columns names for Audit

4ser Table Name PER-PEOPLE-/

Table Name PER-ALL-PEOPLE-/


Description DateTraced ta7le holdi!8 per(o!ali!+or*atio! +or e*plo3ee( applica!t(a!d other people.

Audit Columns

Column Name Column Type Primary 6ey

PERSO6-ID 6u*7er Checed

E//ECTIE-START-DATE Date Checed

E//ECTIE-E6D-DATE Date Checed

/ULL-6AME archar$ U!checed





4ser Table Name PER-ASSI<6ME6TS-/

Table Name PER-ALL-ASSI<6ME6TS-/


Description E*plo3ee a!d applica!t a((i8!*e!tdetail(.

Audit Columns


ASSI<6ME6T-ID 6u*7er Checed



<RADE-ID 6u*7er U!checed

PERSO6-ID 6u*7er U!checed





4ser Table Name PER-PA-PROPOSALS

Table Name PER-PA-PROPOSALS


Description Salar3 propo(al( a!d per+or*a!cere#ie: i!+or*atio! +or e*plo3eea((i8!*e!t(.

Audit Columns


ASSI<6ME6T-ID 6u*7er U!checed

PA-PROPOSAL-ID 6u*7er Checed

PROPOSED-SALAR-6 6u*7er U!checed



Application Pa3roll

Description Per(o!al pa3*e!t *ethod detail( +or

a! e*plo3ee.

Audit Columns


PERSO6AL-PAME6T-METOD-ID

6u*7er Checed



EFTER6AL-ACCOU6T-ID 6u*7er U!checed


Oracle Audit Setup 5 De4!e Audit /ield( 1& o+ 12



4ser Table Name PO-E6DORS

Table Name PO-E6DORS

Application Purcha(i!8

Description Supplier(

Audit Columns


E6DOR-ID 6u*7er Checed

E6DOR-6AME archar$ U!checed

4ser Table Name AP-BA6-ACCOU6T-USES

Table Name AP-BA6-ACCOU6T-USES

Application Pa3a7le(

Description I!+or*atio! a7out 7a! accou!t u(e73 Oracle Pa3a7le( a!d OracleRecei#a7le( applicatio!(

Audit Columns


BA6-ACCOU6T-USES-ID 6u*7er Checed

EFTER6AL-BA6-ACCOU6 T-ID

6u*7er U!checed

E6DOR-ID 6u*7er U!checed

E6DOR-SITE-ID 6u*7er U!checed


Oracle Audit Setup 5 De4!e Audit /ield( 1) o+ 12



%racle Audit Setup $ Run the Audit Trail 4pdate Tables Report

System Administrator Re7uest Run

Report Name AuditTrail Update Ta7le(

Parameter 6o!e

After the report is completed Successfully * 1uery the 3roups and con)rm the3roup State is &nabled

System Administrator Re7uest Run

Application Name u*a! Re(ource(

Audit 3roup TC R Audit Trail

3roup State E!a7led

Description Audit Trail <roup +or R%Pa3roll Ite*(

1uery the 3roups created above and con)rm the 3roup Status is &nabled


Oracle Audit Setup 5 De4!e Audit /ield( 1' o+ 12



%pen and Closed 2ssues for this Deliverable

%pen 2ssues

2D 2ssue Resolution Responsibility Target Date 2mpact Date

Closed 2ssues

2D 2ssue Resolution Responsibility Target Date 2mpact Date


Documents

BR100- Audit Setup