Monday, 21 May 2012

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

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

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

What is Subledger Accounting(SLA):
Oracle Subledger Accounting is a rule based engine for Generating accountingentries based on subledger transactions from all oracle applications.

Subledger acounting 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
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 subledgers 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 utilising 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.

Subledger Accounting Methods (SLAM):
The Subledger accounting method is required if using Oracle Subledger accounting.
A subledger level secondary ledger requires a subledger 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 Subledger Accounting Methods:
1. Accrual with Encumbrance Accounting
2. Cash with Encumburance Accounting
3. Standard Accrual (Default)
4. Standard Cash
5. US Federal Accounting.

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

  1. All upgraded, non-publicsector 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
What is Accounting Setup Manager (ASM):
It is one of the main feature of the Ledger Architecutre introduced 
in R12, which replaces teh Set of books from using a web based 

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 organizationthat 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 transaltion 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 Perdios 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.

No comments:

Post a Comment