Transcript Sub-Ledger Accounting in Release 12

Sub Ledger Accounting
Technical perspective
Aug 15, 2008 03:00 PM – 03:40 PM
Presented By
Venkat Vesangi
[email protected]
1
Agenda
Introduction to Sub Ledger Accounting ( SLA )
New features of SLA Versus 11 i
Configuration steps
Technical Architecture
Reports and Processes
Issues and Troubleshooting
Questions and Answers
2
Introduction to SLA
 Sandwiched between most of Transaction Applications
and General Ledger
 Renders Accounting Services to Transaction
Applications
 Gateway to General Ledger
 Cooking Pot for Accounting Entries
 Common Accounting Data Model
 Rule based Accounting Engine
 Stores Complete and Balanced Journal Entry for a Sub
Ledger Transaction that requires Accounting
 Stores Sub Ledger Balances
3
Features of SLA Vs 11 i
 Bi Directional Drill Downs
 Multiple Accounting Representation for single
Business Event
 Resolves conflicts between Corporate and
Local Accounting Requirements
 Draft and Online Accounting
 Centralized Accounting Rules
 Detailed Accounting Entries
4
Features of SLA Vs 11 i
5
Features of SLA Vs 11 i
 Sub Ledgers and GL is tied out as shown
6
Features of SLA Vs 11 i
 Multiple Accounting Representation
7
Features of SLA Vs 11 i
 Transfer Mode to GL
8
Configuration
 Sub Ledger Journal Entry Consists of 3
Components
Line Type, Line Description and Account derivation rule
9
Configuration

Accounting Methods Builder ( AMB )
Used to create and Modify Sub ledger Journal line set ups and application
accounting Definitions. AMB includes the following features
• Accounting options that determine different characteristics of the journal entry
• Descriptions that appear on the sub ledger journal header and lines which provide
additional information about the journal entry. For example, a sub ledger journal
entry created for a Payables invoice can show the supplier name and invoice
number.
• Account derivation rules to construct the accounts for a sub ledger journal entry
line. Users define various rules in the AMB to determine how a journal entry account
is derived. Users can derive accounts segment by segment or as a complete
Accounting Flexfield.
• Conditions that determine when sub ledger journal entry accounts and lines are
created. Some accounts can be used to create a journal entry only in certain
circumstances. For example, an asset account can only be used when the Assets
flag for an invoice distribution is enabled through the Oracle Payables Invoices
window
10
Configuration
 Relationship between various AMB
Components are shone here
11
Configuration
 Subledger Accounting Method Set Up
12
Configuration
 System Options
13
Configuration
 System Options
14
Configuration
 Accounting Options ( Create Accounting )
15
Technical Architecture
SLA Tables Structure
TRANSACTIONS
ACCOUNTING
Transaction ( AR )
Headers
( RA_CUSTOMER_TRX_ALL
&
AR_CASH_RECEIPTS_ALL
&
AR_ADJUSTMENTS_ALL )
Entities
Accounting Events
( XLA_TRANSACTION_ENTITIES )
( XLA_EVENTS )
Accounting Headers
( XLA_AE_HEADERS )
LEDGER
TABLES
GL_IMPORT_REFERENCES
Accounting Lines
( XLA_AE_LINES )
Distributions
(
RA_CUST_TRX_LINE_GL_DIST
_ALL
&
AR_DISTRIBUTIONS_ALL )
Distribution Links
( XLA_DISTRIBUTION_LINKS )
16
Reports and Processes

Create Accounting
This is one step process for transferring accounting entries to GL from Sub
ledgers like AR, AP…. .
This Master Process Submits
1. Accounting Program. This creates Journals and generates output detailing the
Transfer/Error details of events depending on input Parameters
2. Journal Import. This transfers Journals to GL. May also post depending on
Input Parameters
3. Subledger Accounting Balances Update

Transfer Journal Entries to GL
The Transfer Journal Entries to GL program enables you to transfer any eligible
journal entries to General Ledger, including those from previous batch runs that
have not yet been transferred to General Ledger. This one also picks up online
final accounted Transactions not transferred to GL
This Master Process Submits
1. Journal Import. This transfers Journals to GL. May also post depending on
Input Parameters
17
Reports and Processes

Subledger Accounting provides the following
reports
1. Journal Entries Report
2. Account Analysis Report
3. Third Party Balances.
4. Multiperiod Accounting Reports
5. Period Close Exceptions Report
18
Issue and Troubleshooting
 Diagnostic Framework Business Process flow
19
Issue and Troubleshooting
 Run Transaction Objects Diagnostics Request
as shown below
20
Questions and Answers
Questions and Open Discussions
Contact Information
Venkat Vesangi
Email: [email protected]
Phone: 630-778-1180
Presentation Copy
www.astcorporation.com/papers/ncoaug
21