Tuesday Nov 11, 2014

Subledger Accounting for Payroll

Are you thinking about using Oracle Subledger Accounting (SLA) for your Payroll EBS application?

Oracle Subledger Accounting was released in R12 and has the following benefits:
  • Enables corporations to comply with corporate, local and managerial accounting and audit requirements via increased control, visibility and efficiency
  • Streamlines the books closure by providing a common posting engine, so that all subledger products and non-Oracle products can transfer controlled and summarized data to the General Ledger using a standard methodology and auditable, reviewable process
  • Constitutes a single source of truth for all accounting, reconciliation and analytical reporting, by storing journal entries in a common data model

Did you know that Payroll requires some manual setup in order to use SLA?  This is necessary to make sure that YOUR Chart of Accounts is being used to create the accounting, and that the Payroll costing is going to the correct cost code combinations per YOUR business rules. The Payroll setup & usage for SLA is done via the seeded 'Global SLA/Payroll Manager' responsibility.

The mandatory setup steps are explained in the following notes, which you can access via My Oracle Support:

  • Performing a Manual Upgrade to Enable Subledger Accounting (SLA) for Oracle HRMS Release 12 (Doc ID 399632.1)
  • Oracle Payroll - Sub Ledger Accounting Integration - An Oracle White Paper (Doc ID 1091213.1)

If you have any questions or issues with the SLA/Payroll functionality, please search for answers on My Oracle Support, or log a new service request with the Payroll support team and include the diagnostic information from the following note: R12.0.6+ Subledger Accounting (XLA) Setup Diagnostics Test (Doc ID 942252.1).

Friday Aug 29, 2014

Subledger Accounting: Proration Types in Multi Period Accounting

Looking for an overview and explanation of different Proration Types in Multi Period Accounting (MPA) feature in R12?

Multi Period Accounting (MPA) enables users to create accounting for a single accounting event for more than one GL period.  This functionality is primarily used to recognize revenue or a prepaid expense across multiple GL periods.

Within Multi Period Accounting, application provides different ways to Prorate the amounts.

  • First Period
  • Days In Period
  • Total Days In Period
  • 360 Days

The Amount prorated depends on the Proration Type.

R12: Subledger Accounting: White Paper Explaining Different Proration Types in Multi Period Accounting (Doc ID 1915795.1)
explains the proration type in detail and includes a step by step guide on how to configure the MPA feature for a business transaction.

Thursday Feb 14, 2013

Reasons why I Run Create Accounting on a Daily Basis

Implementation of accounting best practices can significantly reduce your company’s workload while improving accuracy and ensuring data quality.  The Create Accounting program processes eligible accounting events to create subledger journal entries. 

The Create Accounting program:

  1. Validates and creates subledger journal entries
  2. Transfers the final journal entries in the current batch run to General Ledger and starts the General Ledger posting process
  3. Generates the Subledger Accounting Program Report, which documents the results of the Create Accounting program

In Receivables we recommend that you run Create Accounting daily! Here’s why..............!

  • The Create Accounting concurrent program is run with the 'as-of' GL_DATE so running daily will allow all invalid items to be caught early and resolved before the period needs to be closed. This prevents the panic at Period Close, when you find out there is just one invalid transaction preventing the entire period from being successfully closed.

For  example, for Dec-1-2012 you may have an orphan credit memo event which shows in the Subledger Period Close Exception Report.  When you try to close the period on Dec-31-2012, this corrupted credit memo will prevent period close.  If you had run the Create Accounting process more frequently, this invalid data would have been identified and you could have found the resolution prior to the Period Close.

  • Running the Create Accounting concurrent program daily will allow for quicker processing.  Having the program process 100 transactions per day is a lot easier then having it process 3000 transactions on the final day of the month, especially with the performance impact of all the additional Period Close reporting and processing that has to be completed.  Another option is having each user run online create accounting as soon as the transaction is completed.
  • Yet another benefit of running Create Accounting more frequently, is the ability to reconcile your AR and GL data in smaller and more targeted tranches of data.  This is yet another Period Close process that can be started earlier in the period, in order to decrease the pressure on yourselves at the end of the period.
So you can see, running Create Accounting on a daily basis can really help you balance out your workload!

Monday Jul 11, 2011

The Basics of OPM Subledger Accounting

ADVISOR WEBCAST: The Basics of OPM Subledger Accounting

PRODUCT FAMILY: Oracle Process Manufacturing

July 20, 2011 at 8 am PT, 9 am MT, 11 am ET

This session will provide the basic overview, integration, common errors, and first steps in troubleshooting in Oracle Process Manufacturing Subledger Accounting. This one-hour session is recommended for functional users, technical users, and customers interested in learning more about the basics of OPM Subledger Accounting.

  • Overview: common setups and basic process flow
  • Integration: How it is different from discrete costing integration with SLA
  • Common errors and first steps in troubleshooting
    • When is it an OPM Preprocessor issue?
    • When is it a Create Accounting issue?
    • Available tools: Transactions Diagnostics and SLA Journal Def Report

A short, live demonstration (only if applicable) and question and answer period will be included. Oracle Advisor Webcasts are dedicated to building your awareness around our products and services. This session does not replace offerings from Oracle Global Support Services.

Click here to register for this session


The above webcast is a service of the E-Business Suite Communities in My Oracle Support.

For more information on other webcasts, please reference the Oracle Advisor Webcast Schedule.

Click here to visit the E-Business Communities in My Oracle Support

Note that all links require access to My Oracle Support.


Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« August 2016