Sub Ledger Accounting - Technical perspective

Posted on October 7th, 2008 by Sanjit Anand | Print This Post | Email This Post

SLA(Sub Ledger Accounting) -Characteristics

• All SLA data is stored in SLA and is imported to GL from SLA.
• A protocol exists to ensure all subledgers are transferring data into SLA consistently
• Creates the final accounting for Subledger Journal Entries (JEs) and transfers the accounting to GL
• During reconciliation subledgers to GL, all reconciliation reports point to the SLA tables
• Concurrent program used to transfer data into SLA and import to GL.
• SLA Can Fill In Individual Segments or Entire AFF
• SLA Can Create Multiple Representations of Each Subledger Transactions
• Stores a complete and balanced Subledger JE in a common model for each “business event” that requires accounting

Process & Program for Subleder Accounting: Transfer to GL Process

Oracle EBS’s accounting process is basically a 2 step process:

1. Step 1. Create Accounting
2. Step 2. Transfer Journal Entries to GL

Create Accounting :This is one step process for transferring accounting entries to GL from Sub ledgers like AR, AP,FA,CM…

• You need to submit this concurrent programs
  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

• You need to submit this concurrent programs
  1. Journal Import. This transfers Journals to GL. May also post depending on Input Parameters

SLA Technical

As discussed in earlier post, all subledger table is tighten with SLA specific table. Here is one of the example of AR.

New Functionality in Release 12

Sub ledger Accounting Inquiry : where you can view Detailed Transaction and Full Journal Entry ,which can be exported to Excel. The form will display data under these three tabs:

Accounting Modes

In SLA Accounting created in two mode either Draft or Final mode, the difference between these two is ;

• Draft: where you can Review Report and Correct errors
• Final: where you can directly transfer to GL and Post in GL

There is one Profile Option which you need to set …‘SLA: Disable Journal Import’ set to No by default.

Important SLA Reports

Subledger Accounting provides the following reports

1. Journal Entries Report
   • Seeded data extract provides over 100 columns of data
2. Account Analysis Report
   • Seeded come with data extract over 100 columns of data.
   • This is based out of XML Publisher.
3. Third Party Balances.
4. Multiperiod Accounting Reports
5. Open Account Balances (Trial Balance) :This report displays balances created by subledger transactions and detail transactions supporting the balance. A variety of seeded BI Publisher Templates are included to provide multiple representations/ summary levels of the data.
   • Open Balance Definitions are configurable.
   • Seeded data extracts provide over 90 columns of data.
   • Default templates are based out of Group by Account, Applied Transaction Detail
   • To Run an Open Account Balances Listing, check out old post .
     • Create Open Account Balances Listing Definitions
     • Run Request: Open Account Balances Data Manager (automatically run as part of GL Posting)
     • Run Request: Open Account Balances Listing, select applicable parameters
6. Period Close Exceptions Report -Review the subledger period close exceptions report when closing the GL period.You can define ‘roles and responsibilities’ for exceptions.

Will listout some other reporting requirement for Month end reconciliation in another post.

SLA Objects

There are more than 2,100 objects have been added to the E-Business Suite database due to SLA.

select object_type,count(*) from dba_objects
where object_namelike ‘%XLA%’
group by object_type;

SLA Diagnostics

SLA Diagnostics provides features to review the SLA journal entries created. This helps you to:

• review the source values available in the transaction objects during implementation/testing.
• analyze issues related to the generation of subledgerjournal entries

You can enable this features by:

• Setting Profile Option-SLA: Enable Diagnostics to Yes
• Enter Transactions
• Run Request: Create Accounting
• Run Request: Transaction Objects Diagnostics

Fig :Diagnostic Framework Business Process flow

You can run Transaction Objects Diagnostics Request directly from Oracle as shown below:

Similar Post

• R12 SLA: Analyzing Subledger Accounting
• R12 SLA: Transaction Account Builder
• R12 SLA: From Product Accounting to Subledger Accounting
• R12 SLA: Accounting Methods Builder