AIM

BR.100 ORACLE SUBLEDGER ACCOUNTING ARCHITECTURE SETUP <Company Long Name> <Subject>

Author: Creation Date: Last Updated: Document Ref: Version:

<Author> May 14, 2007 May 14, 2007 <Document Reference Number> DRAFT 1A

Approvals: <Approver 1> <Approver 2>

BR.100 Oracle Subledger Accounting Architecture Setup May 14, 2007

Doc Ref: <Document Reference Number>

Document Control
Change Record
1

Date 14-May07

Author <Author>

Versio n Draft 1a

Change Reference No Previous Document

Reviewers

Name

Position

Distribution

Copy No. 1 2 3 4

Name Library Master

Location Project Library Project Manager

Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

<Subject> File Ref: 142390721.doc

(v. DRAFT 1A )

Document Control

ii

BR.100 Oracle Subledger Accounting Architecture Setup May 14, 2007

Doc Ref: <Document Reference Number>

Contents

Document Control.......................................................................................ii Oracle Payables: Journal Entry Setups........................................................1 Oracle Payables: SLA Journal Entry Descriptions........................................3 Oracle Payables: Mapping Sets...................................................................4 Oracle Payables: Account Derivation Rules................................................5 Oracle Payables: Invoice Journal Line Definition.........................................6 Oracle Payables: Application Accounting Definition...................................7 Oracle Payables: Subledger Accounting Methods.......................................8 Oracle Payables: Subledger Applications....................................................9 Oracle Payables: AMB Event Model...........................................................10 Oracle Payables: Accounting Event Class Options....................................12 Oracle Payables: SLA Custom Sources......................................................14 Open and Closed Issues for this Deliverable.............................................15 Open Issues......................................................................................... 15 Closed Issues.......................................................................................15

<Subject> File Ref: 142390721.doc

(v. DRAFT 1A )

Document Control

ii

Doc Ref:

Oracle Payables: Journal Entry Setups Oracle Payables > Accounting Setups > Subledger Accounting Setup > Accounting Methods Builder >
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Journal Line Types>

Event Class Line Type Code Name Description Balance Type Actual Side Debit Switch Debit/Credit Chart of Accounts Transaction Business Flow Method Class Multiperiod Transfer to GL
Document Control ii

Owner Accounting Class Rounding Class Enabled Budget Encumbrance

Credit Merge Matching Lines

Gain/Loss Subledger Gain/Loss

File Ref: 142390721.doc

(v. )

Doc Ref:

<Operators> Seq ( Source

Segment

Operator

Value Type

Independe nt Value

Value

Segment

And/O r

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: SLA Journal Entry Descriptions Oracle Payments > Accounting Setups> SLA Setup > AMB > Journal Entry Setups > Journal Entry Descriptions
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number> <Journal Entry Descriptions> Journal Description Code Journal Description Name Transaction Charts of Accounts Description Owner Enabled Priority <Conditions> Seq ( Source

<Priority (H, M, L)>

<Process Owner>

Journal Entry Description

Segment

Operator

Value Type

Independe nt Value

Value

Segment

And/O r

<Details> Seq Value Type

Constant

Source

Segment

Display Account Description

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Mapping Sets Oracle Payables> Setup > Subledger Accounting Setup > Transaction Accounting Builder Setup> Accounting Derivation Rules
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number> <Mapping Sets> Mapping Set Code Mapping Set Name Description Enabled Lookup Application Lookup Type

<Priority (H, M, L)>

<Process Owner>

Value Set

Accounting Chart of Accounts Flexfield Segement Value Set <Mapping Set Values> Value Type Input Value Output Value Start Date End Date Enable d

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Account Derivation Rules Oracle Payables> Setup > Subledger Accounting Setup > Transaction Accounting Builder Setup> Accounting Derivation Rules
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Accounting Derivation Rules>

Application Rule Code Rule Name Description Owner Enabled

<Chart of Accounts>
Transaction Accounting <Output Type> Flexfield Segment Value <Priorities> Priority <Conditions> Seq ( Source Value Type Value Input Source Segment

Segment

Operator

Value Type

Independe nt Value

Value

Segment

And/O r

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Invoice Journal Line Definition Oracle Payables> Setup > Subledger Accounting Setup > Transaction Accounting Builder Setup> Accounting Derivation Rules
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number> <Journal Line Definitions> Event Class Definition Code Definition Name Description Transaction <Line Assignments> Journal Line Type Accounting

<Priority (H, M, L)>

<Process Owner>

Event Type Owner Enabled Budgetary Control

Owner

Inherit Description

Line Description

Owner

Active

<Account Derivation Rules> Segment Inher it

Rule Name

Own er

Description

Side

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Application Accounting Definition Oracle Payables> Accounting Setups > SLA Setup > AMB > Methods and Definitions > Application Accounting Definitions
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Application Accounting Definitions> Definition Code Definition Name Description Transaction Accounting

Owner Version Enabled

<Event Class and Event Type Assignments> Event Class Event Type

Validation Status

Create Accounting

Locke d

<Journal Lines Definition Assignments> Journal Lines Defintion Name

Owner

Description

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Subledger Accounting Methods Oracle Payables> Accounting Setups > SLA Setup > AMB > Methods and Definitions > Subledger Accounting Methods
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number> <Subledger Accounting Methods> Method Code Method Name Description Transaction

<Priority (H, M, L)>

<Process Owner>

Owner Enable d Accounting

<Accounting Definition Assignments> Application Name

Owner

Start Date

End Date

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Subledger Applications Oracle Payables >Accounting Setups > Subledger Accounting Setup > Subledger Applications
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Subledger Applications>
Application Name

<Drilldown Options>
Drilldown Procedure

<Transaction Security Options>

Policy Function Use Security

<Subledger Accounting Options>

Journal Source Third Party Con trol Account Type Subject to Valuation Method Calculate Reporting Currency Accounts

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: AMB Event Model Oracle Payables>Accounting Setups > Subledger Accounting Setup > Accounting Methods Builder > Events > Events Model
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Entities>
Application

<Entities>
Entity Code Entity Name Description Gapless Event Processing Enabled

<System Transaction Identifiers>

Entity Name

<Identifier Mapping>
Entity Table Column Identifier Column

<Event Classes and Types>

Entity Name Event Class Code Event Class Name Description Enabled

<Event Class Predecessors>

File Ref: 142390721.doc (v. ) Document Control ii

Doc Ref:

Event Class Name

Event Class Code

Description

Entity

<Event Types>
Event Type Code Event Type Name Description Accounting Tax Enabled

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: Accounting Event Class Options Oracle Payables> Subledger Accounting Setup > Accounting Methods Builder > Events > Accounting Event Class Options
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Accounting Event Class Options>

Application Entity Event Class Process Category Calculated Accounted Amounts Default Journal Category Transation View

Actual

Budget

Encumbrance

Calculated Gains or Loss Amounts

Sequence Object Name Application

User Identifier Name Object Type Object Name

View Colum Name Always Populated Join Condition Always Populated Always Populated

Application Name

Object Name

Join Condition

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Oracle Payables: SLA Custom Sources Oracle Payments > Oracle Payments Setup > Funds Disbursement Setup > Payment Method > Defaulting Rules
<Customer Short Name> Process: <Process Name>
Control Number: Business Area: Date:

<Business Area>
Priority(H, M, L):

<Date>
Process Owner:

<Control Number>

<Priority (H, M, L)>

<Process Owner>

<Custom Sources>
Custom Source Code Custom Source Name Description PL/SQL Function Name Enabled

<Return Data Options>

Data Type Segment Lookup Application Value Set Lookup Type Accounting Flexfield

<Parameters>
Seq Type Name Source Description

File Ref: 142390721.doc

(v. )

Document Control

ii

Doc Ref:

Open and Closed Issues for this Deliverable

Open Issues
ID Issue Resolution Responsibility Target Date Impact Date

Closed Issues
ID Issue Resolution Responsibility Target Date Impact Date

File Ref: 142390721.doc

(v. )

Document Control

ii