Friday, January 16, 2009

R12 : SLA, SLAM, ASM, Ledger Sets, Data Access Sets

What is Sub ledger Accounting(SLA):

Oracle Sub ledger Accounting (SLA) is a rule based engine for Generating accounting entries based on sub ledger transactions from all oracle applications. It is a rule-based accounting engine that defines how journal entries are generated for sub-ledger transactions in Oracle applications.  SLA also supports 3rd-party applications that generate accounting information that will need to be transferred to the general ledger

Sub ledger accounting is a set of services for R12 that significantly enhance accounting support across the E-Business suite.


R12 introduces some of the changes that will be fully developed in Fusion, so close attention
to the impact of these changes is worthwhile. Sub-ledger accounting may be one of these key
changes.
When Release 12 was first released, there was a lot of publicity about the move from the Set
of Books concept to Ledgers being so fundamental, however experience suggests that the
introduction of sub-ledger accounting (SLA) probably has even more impact. For those not familiar with SLA, it is a new product in Release 12 and a major change, (although it may be almost transparent to many end-users). 


It is both the rules and the engine that generates the accounting representation of your transactions, and it offers some  wonderful opportunities to meet very specific accounting requirements in supportable ways. Participating sub ledgers include Payables, Receivables, Projects, Assets, Cash Management , Purchasing, Cost Management and Process Manufacturing.

In terms of its mechanics, SLA is a new schema into which all accounting entries are processed before being interfaced to the General Ledger - and so it alters the way reconciliation and month-end processes run. This simple statement is both fundamental and important - because many of the skills we have learnt over years to address accounting issues at period end may have to be modified.
Do not underestimate this change and do invest the time to simulate month-end processes
during Testing (CRP and UAT) . Companies should move from utilizing Account Generators in Release 12 to representing their accounting rules in the Sub-ledger Accounting Engine. SLA rules that are in place in Release 12 will be protected in an upgrade to Fusion.



Sub ledger Accounting Methods (SLAM):

The Sub ledger accounting method is required if using Oracle Sub ledger accounting.
A sub ledger level secondary ledger requires a sub ledger accounting method for both the primary ledger and the secondary ledgers.

The accounting method can be changed at any time, it will only affect new journals,additional accounting methods may be defined. This is done in subledger Accounting.

There are 5 Sub ledger Accounting Methods:
1. Accrual with Encumbrance Accounting
2. Cash with Encumbrance Accounting
3. Standard Accrual (Default)
4. Standard Cash
5. US Federal Accounting.

All upgraded ledgers in Release 12 will have a sub ledger accounting method assigned during the upgrade. Any reporting currencies assigned to the ledger inherit the subledger accounting method from the source ledger. The sub ledger accounting method enables Oracle General Ledger to integrate with Oracle subledgers using Subledger Accounting.

  1. All upgraded, non-public sector ledgers will have a subledger accounting method assigned called Standard Accrual or Standard Cash.
  2. All upgraded public sector ledgers will have a subledger accounting method assigned called Encumbrance Accrual or Encumbrance Cash.
  3. For US Federal customers, all upgraded ledgers will have the US Federal Accounting subledger accounting method assigned to them.
What is a subledger:
Subledger are applications to manager operational transactions with financials impact. Subledger stores accounting at transaction level of details. Subledger post summarized activity information to a GL Periodically to maintain centralized account balance for the
company.


What is Accounting Setup Manager (ASM):

It is one of the main feature of the Ledger Architecture introduced in R12, which replaces the Set of books from using a web based interface.

Accounting Setup Steps:




Accounting Setup Manager(ASM) is the central place where all the
accounting setup is defined and maintained for:
- Legal Enties.
- Operating Units
- Ledgers.
- Reporting Currencies
- Subledger Accouting.
-Inter and Intra Balancing Segments.
- Sequencing (Accounting and Reporting)
- Other Accounting options like retained earning account, suspense
account, currency conversion types etc.

Accounting Setup Manager Benefits:
  • Centralized Accounting Setup for Financials
    –Define all of your accounting-related setup in a central location
    –Reduce setup errors
    –Have clear view of implementation
  • Increased Efficiency
    –Access accounting setup information more quickly now that it appears centrally in one location.
  • Simplified Processes
  • Improved Efficiency
  • Strengthens business’s corporate legal structure
  • Streamlined on-going maintenance
  • User friendly interface
  • Facilitates internal control management.
    What is a ledger:
    The Ledger represents an accounting representation for an organization that is accountable in a self- contained way. The ledger represent the core of a company's Financial records where every transaction flow thrugh. " A Legal Entity accounts for itself in a ledger"

    Primary Ledger :
    ===========
    -Main , Record keeping ledger
    - Defined by 4C's.
    - Chart of Accounts
    - Accounting Calendar
    - Primary Currency
    - Subledger aCcounting Method - New 4th C (Also Called Convension)

    There are 3 types of ledgers: Primary , secondary and reporting currency ledgers.

    1. Primary Ledger (PL): it is the main ledger and has the most details of information. It can have more than one secondary ledger assigned.

    2. Secondary Ledger(SL): it is optional and differs in one or more of the 4C's from the PL.It provides an additional accounting representation of the PL to comply with legal requirements.
    The SL can only be assigned to one PL.

    3. Reporting Currency(RC): Used when the only element that differ from the PL is the Currency. it is stored in the tables as a ledger but does not need to be setup as a ledger via ASM.

    Primary and secondary ledgers can have RC's assigned. if a RC has not been assigned to a PL or SL, when a translation is run in a ledger the reporting currency is automatically added
    to the ledger setup.

    The Secondary and reporting currency ledgers stores additional accounting representations of the information present in the primary ledger. There are different level of detail in which this information is stored, which are called Conversion levels.


    Ledger Sets:
    Ledger Sets enables you to group multiple ledgers that share the same COA and Calendar Combination. Essentially, Ledger Sets allow you to treat multiple ledger as one. for example you can open and close periods for multiple ledgers in a ledger set in a single submission by submitting the new Open and Close Periods Program from the Submit Request Form.

    Data Access Sets:
    Data Access Sets enable you to specify read only or read and write access for a legal entity, ledger, Balancing Segment Value or Management segment Value.

Oracle R12

R12 is the latest and most advanced version of the E-Business Suite.

R12 is Defined as Global Business Release Focusing on working , Thinking and Managing Global Organization.

Requirements:
============
•Improve support for shared service operations.
•Ease access to aggregated data for management reporting.
•Ensure accurate accounting, tax and currency treatment of transactions.

Results:
=======
•A single responsibility to access and transact on multiple organizations .
•A single ledger to manage multiple currencies.
•Ledger sets to manage accounting processes across ledgers.
•Centralized rules engines for tax, accounting and inter company.
•A separate and simple payment creation and delivery solution.
•Centralized trading partners (suppliers, banks, first party legal entities).
•Simplified reporting via XML Publisher.
•Netting across trading partners.

Centralized Financials Architecture:
==========================



TOP Changes in Oracle Release 12:
===========================
1.Multiple Ledgers- From Set of Books to Ledgers and Ledger Sets.
2.Legal Entities and Accounting Setup.
3.From Product Accounting to Subledger Accounting. (SLA)
4. Shared Service Access Controls - From Multi-Org to Multi-Access-
MOAC (Multi Org Access Control) - Role based access to Operating Unit.
5.Oracle Payments and Banking - Centralized Bank Model- Centralized Payment Processing (Shared Services Disbursements and Receipts)
6.From Multi-Tax Codes to E-Business Tax(EB Tax).
7. Intercompany using Advanced Global Intercompany (AGIS).


Changes between 11i and R12 high level details: