Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

No items, feed is empty.

Sub Ledger Accounting – Technical Deep Dive

Posted on September 12th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

As you know, SLA is an intermediate step between subledger applications and GL. SLA creates the final accounting for subledger journal entries and transfers the accounting to GL.

This stores complete and balanced journal entry for each business event that requires accounting.

This can create more than one accounting representation for each transaction.

This also provides accounting information for reports and inquires. This provides the ability to drilldown to subledger journal entries from GL. There is also the
ability to drilldown to the underlying transactions in the related modules from the subledger journal lines

dgreybarrow SLA Table Diagram

Refer to table 1 below, will give a idea about the SLA tables.

SLA

XLA_EVENTS

This table contains subledger events for cost, revenue accounting. Accounting events will be created upon the baselining of a budget for GL validation.
Encumberance accounting events are created upon a successful funds check. One key column of this table is PROCESS_STATUS_CODE which have several meaning as:

  • 'I' stand for Invalid : This means Event in error in SLA
  • 'E' stand for Error : This means Event in error in SLA
  • 'U' stand for Unprocessed : This means Events generated in SLA
  • 'R' stand for Related Event : This means Related event in error
  • 'P' stand for Processed : This means Final Accounted
  • ā€˜Dā€™ stand for Draft : This means Draft Accounted

XLA_AE_HEADERS

This table Stores subledger journal entries. There is a one-to many relationship between accounting events and journal entry headers.

XLA_AE_LINES

This table table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.

XLA_DISTRIBUTION_LINKS

This table table stores the link between transactions and subledger journal entry lines. Determines whether supplicate subledger journal lines are merged and whether the accounted amounts are calculated by the SLA or passed through.

XLA_ACCOUNTING_ERRORS

This table table stores records for events which have errored during the accounting program. If an event is successfully accounted without issue then it will not have records in this table.

XLA_TRANSACTION_ENTITIES

This table table stores additional details for source transactions.Columns Source_id and source_id_char form the link between SLA and subledger (AR,AP, PA etc) base tables.

Releastionship between these table can be easily understood in this ER diagram.

SLA table Relationship

Moreover, you should not forgot the Key Concepts of SLA as:

  • Event Model : This gives definition of the subledger transaction types and lifecycle
  • Entity- This gives a classification of source of transaction
  • Event Class - This gives a classifies transaction types for accounting rule purposes
  • Event Type : This is for each transaction type, defines possible actions with accounting significance

Hope this Post will helps you to give more insights on SLA.

Related Posts

Posted in Subledger Accounting | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.