Tuesday Mar 03, 2015

R12: Important Enhancement: ON-THE-FLY SLA Upgrade of Historical SLA Distributions--BATCH MODE!

Previous Announcement

In September of 2014 we announced the release of an important new enhancement in Oracle Payables that would allow you to transparently upgrade upstream 11i transactions from periods which had not been upgraded for Subledger Accounting (SLA), and which would negatively affect the accounting of dependent downstream transactions--without needing to apply the SLA Hot Patch or run the SLA: Upgrade Historical Subledger Transaction Accounting program.

The details and important benefits of that critical release and how it works can be found in detail in this blog post from back in Nov-14.

The only limitation to the functionality released back then was that it was only available when accounting transactions in "Online Mode". Now we are happy to announce that the second phase of this enhancement is also available.

Release of Phase 2

On 06-Feb-2015, the "Batch Mode" version of this enhancement was released via patch 20427746.  This patch introduces an entirely new concurrent process: "Payables Upgrade SLA Distributions for Historical Referenced Transactions". This process should be run in tandem with the "Create Accounting" program. It can be run independently prior to running "Create Accounting", or they can be run together as a request set.

Payables Upgrade SLA Distributions for Historical Referenced Transactions Concurrent Program

The parameters of the new program are similar to those used by the "Create Accounting" process to identify unaccounted events to process.

  •  Ledger
  •  Process Category
  •  Start Date
  •  End Date
  •  Batch Size
When run, the new program will identify all of the historical upstream transactions which would affect your unaccounted events, and upgrade them on the fly as required to prevent any errors when the "Create Accounting" program subsequently runs.

The original note describing the online version of the enhancement "R12: Important Enhancement ON-THE-FLY Upgrade of Historical SLA Distributions" (Doc ID 1938253.1) has been updated to provide additional information about the batch mode version of this enhancement.

If you have any questions or comments on this new functionality please post in the dedicated Payables Community thread

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).

Tuesday Nov 04, 2014

R12 : Important Enhancement ON-THE-FLY Upgrade of Historical SLA Distributions

In Oracle Payables, a payment has a functional dependency on invoice, i.e. the payment needs to be accounted to same liability account as the invoice has been accounted for. In such a scenario, invoice is referred to as the upstream transaction and the payment as the downstream transaction.

In a business flow prior entry application, the upstream accounting is mandatory for the downstream transaction accounting to go through. The accounting journals must be created in each ledger (primary, ALC and secondary) for all upstream transactions to have the accounting to be created in all the related ledgers of primary ledger for the downstream transaction.

Similar dependencies are there for other transactions also like Invoice Cancellation, Prepayment Application, Payment Cancellation, Payment unclearing etc.

Business flow failures generally have the error:

  • Error 0 : This line cannot be accounted until the accounting event for the application Payables that it references has been fully accounted.

Old Method:

In order to resolve this situation, users needs to identify and account all upstream transactions before accounting the downstream transactions.  This was more complex for transactions that referenced one or more 11i transactions as the upstream transaction and in some cases it was mandatory to have Hot Patch applied or SLA: Upgrade Historical Subledger Transaction Accounting Program ran to cover the period related to the upstream transaction.  This was required even for accounting a single downstream transaction.

New Method:

With the exciting enhancement delivered via Patch 19568225, downstream transactions failing business flow for an upgraded upstream transaction can be successfully accounted using ON-LINE accounting of the downstream transaction.

With on-the-fly upgrade, a new profile option SLA: On-the-fly Upgrade of Historical Subledger Accounting Distributions is introduced which when set to Yes will cause a dedicated procedure to identify the few upstream transactions missing XDL and populate them on the fly, prior to accounting the downstream transaction, and this is transparent to the user. Thus the volume of transactions which "require" upgrade is reduced from a huge number (across multiple years and applications) to just a few upstream transactions which are related to the current downstream transaction.

Key benefits of this enhancement:

  • Prior to the enhancement, even if there is a single upstream transaction in payables which is missing distribution links, users would be required to apply the hot patch for the entire non-upgraded date range, till the period containing the upstream transaction. e.g. consider the earliest upgraded period is JAN-14. If user pays an upgraded invoice from 11i which has a GL date as JAN-2000, then when using hot patch or the On-Demand distribution links upgrade users would need to upgrade the transactions for around 13 years of invoices and payment both. Hence, accounting a single transaction required upgrade for all of the transactions for over 13 years, which due to data volume and complexities of upgrade be very time consuming.

  • Also, hot patch required that all the data be upgraded for 'all' applications (not just payables), which adds to the time and complexity of upgrade.

  • Also, even if there is a single transaction in the overall time duration which when upgraded (to create XLA_DISTRIBUTION_LINKS records for the upstream transactions) which would cause the Hot patch or On Demand XDL upgrade to error out (XLA_DISTRIBUTION_LINKS_U1 violation), the entire concurrent process would fail. Scanning the entire time duration for corruptions causing failure in XDL population, fixing the same, and restarting the upgrade is often complicated and requires development intervention over bugs, which causes delays with accounting the downstream transactions. 

Please review R12: Important Enhancement ON-THE-FLY Upgrade of Historical SLA Distributions (Doc ID 1938253.1) for full details.

If you have any questions or comments on this new functionality please post in the dedicated Payables Community thread.

Monday Jun 02, 2014

How To Check If a Transaction Related to Oracle Asset Tracking Has Been Accounted in SLA

In Oracle Asset Tracking (OAT), we often see situations where a pending transaction has failed to be processed by the OAT programs. Typical situations can be:
  • a pending transaction errors with "Unable to derive accounts from sub ledger accounting for the material transaction"
  • a transaction is not picked by OAT programs.


The Create Accounting program log file will show error messages and possible corrective actions to solve the error.  But as this is usually a scheduled program, often any errors that are reported are missed by users.

To aid OAT users to identify if a transaction has failed and accounting has not been created, we have now created a SQL script which can be run for any pending transaction:

How To Check If a Transaction Related to Oracle Asset Tracking Has Been Accounted in SLA ? (Doc ID 1673414.1)
Using the script in this note, the user can pass the material transaction ID for the related transaction and the script will check if SLA accounting entries have been created for this specific transaction or not.

If the SLA accounting entries have not been created, the script will prompt the user to run Create Accounting program.  After Create Accounting has been run, the user can run the script again to confirm that accounting has been created.

Monday May 19, 2014

Payables Subledger Accounting Explained!

Subledger Accounting can be complex but if you follow the advice in our white paper you will be on the road to success!

Subledger Accounting (SLA) is a rule-based accounting engine that centralizes accounting for Oracle E-Business Suite products in R12. Subledger Accounting is not a separate product in itself. 

Together with the new ledger support, Subledger Accounting enables support of multiple accounting requirements concurrently in a single instance. Different accounting regulations can be satisfied by maintaining and applying different sets of rules to different sets of transactions, or accounting for the same transaction with multiple methods. Subledger accounting options define how journal entries are generated from subledger transactions at the subledger application level. 

Note: SLA replaces the different accounting engines available in 11i e.g., the AP accounting engine, FA accounting engine, Global Accounting Engine (AX), and so forth. 

This white paper that was recently updated is very comprehensive and describes the setup of the Payables Subledger Accounting feature that is available in Release 12.  It includes a step by step guide on how to configure the SLA feature for business transactions. 

Payables SLA allows users to personalize their accounting setup according to business needs and this updated white paper now includes 8 test cases together with setup demonstration and results.

Find out all about SLA setup and configuration by reviewing the white paper: 

Subledger Accounting Setup for Oracle Payables (with examples) (Doc ID 1612433.1)

Wednesday Jan 15, 2014

Webcast: Oracle Subledger Accounting (SLA): Accounting Flow, Transfer & Drilldown

Webcast_icon.jpgWebcast:  Oracle Subledger Accounting (SLA): Accounting Flow, Transfer & Drilldown


Date: January 29, 2014 at 11:00 am ET, 9:00 am MT, 4:00 pm GMT, 9:30 pm IST


This one-hour session is recommended for technical and functional users who are familiar with the basics of Subledger Accounting (SLA) and its setup and want a better understanding of the Release 12 accounting process. We will discuss General Ledger (GL) transfer and drilldown and touch upon common errors and their resolution.

To gain a basic understanding of SLA, its setup and data model, join us on 22-Jan-14 for the Oracle Subledger Accounting (SLA) Basics: Overview, Setup & Data Model webcast or after 23-Jan-14, access the recording via the Archived 2013 Tab in Doc ID 1455839.1.

Topics will include:

  • Application Accounting Definition (AAD) package & accounting process
  • General Ledger transfer
  • Drilldown to upgraded & new data
  • Common errors & resolutions

REGISTER.jpg
Details & Registration: Doc ID 1598862.1

Wednesday Jan 08, 2014

Webcast: Oracle Subledger Accounting (SLA) Basics: Overview, Setup & Data Model

Webcast_icon.jpgWebcast:  Oracle Subledger Accounting (SLA) Basics: Overview, Setup & Data Model


Date: January 22, 2014 at 11:00 am ET, 9:00 am MT, 4:00 pm GMT, 9:30 pm IST


Get a basic overview of Subledger Accounting (SLA) and its setup. Learn about the SLA data model and how to customize the Application Accounting Definition. This one-hour session is recommended for technical and functional users looking for an overview of SLA setup and customization of SLA Rules. The session is also helpful if you have recently (or plan to) upgraded to Release 12 and want a basic understanding of the accounting process using SLA.

For a closer look at the SLA accounting flow, transfer and drilldown, join us on 29-Jan-14 for the Oracle Subledger Accounting (SLA): Accounting Flow, Transfer & Drilldown webcast.

Topics will include:

  •    Overview of Subledger Accounting
  •     Subledger Accounting setup & rules
  •     Application Accounting Definition (AAD) customization & import
  •     Sample accounting flow
  •     SLA Data model

REGISTER.jpg
Details & Registration: Doc ID 1598868.1

Tuesday Apr 17, 2012

Reminder: Upcoming Webcast April 18th: “Supporting References” In Release 12 - SLA


PRODUCT FAMILY: Receivables, Payables, General Ledger

April 18, 2012 at 14:00 UK / 15:00 CET / 06:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

"Supporting References” enables users to enter additional information for the “Journal Entry Header” and “Journal Entry Lines” that can be used for analytical purposes. This functionality was earlier known as “Analytical Criteria”. In 11i, additional data was interfaced to GL on the journals using “Descriptive Flexfields” whereas using this feature in R12, customers can create customized sources as ‘Supporting References’ and pass values into those sources from Subledgers like AP / AR / PA, etc.

TOPICS WILL INCLUDE:
  • Supporting References
  • Business information about a subledger journal entry at the header or line level
  • Establishing a subledger balance for a particular source value or combination of source values for a particular account
  • To assist with reconciliation of account balances
  • Financial and managerial analysis
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.

Current Schedule can be found on Note 740966.1
Post Presentation Recordings can be found on Note 740964.1

Sunday Mar 25, 2012

Upcoming Webcast: “Supporting References” In Release 12 - SLA

ADVISOR WEBCAST: “Supporting References” In Release 12 - SLA
PRODUCT FAMILY: Receivables, Payables, General Ledger

April 18, 2012 at 14:00 UK / 15:00 CET / 06:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

"Supporting References” enables users to enter additional information for the “Journal Entry Header” and “Journal Entry Lines” that can be used for analytical purposes. This functionality was earlier known as “Analytical Criteria”. In 11i, additional data was interfaced to GL on the journals using “Descriptive Flexfields” whereas using this feature in R12, customers can create customized sources as ‘Supporting References’ and pass values into those sources from Subledgers like AP / AR / PA, etc.

TOPICS WILL INCLUDE:
  • Supporting References
  • Business information about a subledger journal entry at the header or line level
  • Establishing a subledger balance for a particular source value or combination of source values for a particular account
  • To assist with reconciliation of account balances
  • Financial and managerial analysis
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.

Current Schedule can be found on Note 740966.1
Post Presentation Recordings can be found on Note 740964.1
About

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

Twitter

Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
7
9
10
11
16
17
18
22
23
24
25
26
27
28
29
30
31
      
Today