Monday Mar 07, 2016

EBS Financials February 2016 Recommended Patch Collections (RPCs) Released!

Oracle E-Business Suite (EBS) Financials Development has released February 2016 Recommended Patch Collections (RPCs) for the following products:
  • Assets
  • Cash Management
  • Collections (coming soon)
  • E-Business Tax
  • Calculation
  • Reporting Ledger
  • iReceivables
  • Loans
  • Payables
  • Receivables
  • Sub-Ledger Accounting
  • Payments
  • Internet Expenses
For details and the complete list of available RPCs for Oracle EBS Financials, please see Doc ID 954704.1, EBS: R12.1 Oracle Financials Recommended Patch Collection (RPC).

Thursday Oct 01, 2015

EBS General Ledger - Accounting Hub Reporting Cloud Service

Oracle Accounting Hub Reporting Cloud Service provides excellent reporting and analytics capabilities along with real-time access to information and latest accounting numbers. Drilldown to EBS balances, journals and subledger transactions is also available. 

The integration between the Accounting Hub Reporting Cloud Service and E-Business Suite Release12 continuously streams balances from EBS,

  • providing immediate access to updated financial data
  • supporting quick business decisions
  • offering enhanced reporting options with minimal effort, cost or risks
EBS General Ledger setups are loaded automatically to the Accounting Hub Reporting Cloud Service:
  • charts of accounts
  • calendars
  • hierarchies
  • ledgers
  • balances
Sample financial reports are already available!  

We encourage you to benefit and improve your business with Oracle ERP Cloud Service.

Check this Whitepaper today! 

Accounting Hub Reporting Cloud Service for E-Business Suite Customers (Doc ID 2034564.1)
Oracle ERP Cloud Welcome Note (Doc ID 1499539.1)

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

Tuesday Sep 30, 2014

Mexico Electronic Accounting - Need This Functionality in EBS?

On July 2014 was published The Second Resolution of Modifications to the Mexican Fiscal Code establishing, among other regulations, that taxpayers required to keep accounting books and records must use electronic systems and accounting programs that would be able to generate the files in XML format.

The mentioned provisions refer to: 

  • Chart of Accounts
  • Trial Balance
  • Accounting Policies

Need to meet these requirements regarding compliance and delivery of accounting information through electronic media? 

To understand better the implications of this legislative update and follow-up the formal Enhancement Request raised with Oracle, please visit these documents today!

E-Business Suite Release 12: Mexico Electronic Accounting, 2014 (Doc ID 1918417.1)

R12: Mexico Electronic Accounting : Does New Functionality Exist? (Doc ID 1921779.1)

Be the first one to know when the functionality becomes available! Bookmark this Enhancement Request now! 

Tuesday Jul 15, 2014

Need more information on Online Accruals in Procurement?

Visit the newly released White Paper on 'Oracle Online Accruals In Purchasing' Doc ID 1666593.1.  The document provides a broad overview of the Online Accrual and Online Accrual accounting process in Release 12.  It also provides explanations of common terms and concepts to include accrual, accrual accounting, types of purchase accruals in Oracle Applications and the modules involved.

This white paper is intended to aid users in verifying common setup steps and provide usage relating to accrual methods and processes.  The document takes users through a complete cycle of Online Accruals covering all relevant aspects.  The scope of this document is ideal for all users, consultants and support analysts of the Oracle Procurement Application, with a basic knowledge of Oracle Application setup steps and a firm understanding of accounting principles.

Visit Doc ID 1666593.1 today to review this valuable paper!

Wednesday Jun 11, 2014

Visit our Consolidated List of Mandatory Project Costing Code and Data Fixes

Projects Support has a published document with a consolidated listing of mandatory code and data fixes for Project Costing.  Generic Data Fix (GDF) patches are created by development to fix data issues caused by bugs/issues in the application code.  The GDF patches are released for download via My Oracle Support which are then referenced in My Oracle Support documents and by support to provide data fixes for known code fix issues.

Consolidated root cause code fix and generic data fix patches will be superceded whenever any new version is created.  These patches fix a number of critical code and data issues identified in the Project Costing flow.

This document contains a consolidated list of code and data fixes for Project Costing.  The note lists the following details:

  • Note ID
  • Component
  • Type (code or data)
  • Abstract
  • Patch

Visit DocID 1538822.1 today!

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)

Tuesday Mar 25, 2014

Understanding Encumbrance Accounting in R12

Encumbrance Accounting has always been one of those tricky areas to understand and it is often quite complex and time consuming to resolve issues that arise.  Having a detailed understanding of how Encumbrance Accounting works in General Ledger, Payables and Purchasing will get you on the right track faster.

Recently a new document was created that attempts to pull together all the information that relates to Encumbrance Accounting so that you can understand everything from what it is, to how the applications are setup to use it, to using diagnostic tools and checking patch levels when something doesn't work just how you expect it to.

Please review R12: MASTER TROUBLESHOOTING GUIDE (MTG) for Encumbrance Accounting Issues in Oracle PO and AP (Doc ID 1578275.1) available on MyOracleSupport which discusses the following topics:  

  • What is Encumbrance Accounting
  • How does Encumbrance Accounting work in Oracle?
  • Funds Reservation Statuses on PO Documents
  • Required Setups (GL, AP, PO)
  • Seeded Oracle Reports for Encumbrance Accounting
  • Recommended Patches
  • Diagnostic Tools 
  • Hot Topics
  • More Resources 

One of the additional resources referenced within the above document is R12 Encumbrances Accounting Bulletin (Doc ID 1583781.1).  This interactive document allows you to filter the knowledge based on a topic of choice and includes Encumbrance Transactions for both Accrue on Receipt and at Period End and shows you the transactions you would see and the values of DR and CR that would be inserted into the XLA tables at the various stages.  

Together these two fantastic documents should enlighten the reader and provide a detailed understanding of Encumbrance Accounting in Oracle Applications. 

Thursday Jan 16, 2014

Procurement Accounting - Don’t Delay, Be Proactive and Apply These Necessary Patches

Are you using procurement accounting processes?  Then don’t delay, be proactive and apply these necessary patches to avoid known issues.

So many known issues have been resolved by applying the collection of recommended patches in Doc ID 1594111.1.  Procurement, Costing, Payables and SLA Development teams have collaborated to give you this consolidated list.  Now I know you're thinking that it requires a lot of effort to apply big patches, but while a patch may contain several hundred files, the impact on your system is most likely far less.  Patches contain hard prerequisites that are intended to make a patch work on a very low code baseline, so there is a link to the Patch Wizard so you can perform an impact analysis.   So if you are using Procurement Accounting Flows (Encumbrance and Accruals) make sure and review the note where the steps are clear and to the point:

Don’t delay check out Doc ID 1594111.1 today!

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

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

Details & Registration: Doc ID 1598868.1

Thursday Sep 26, 2013

Webcast: Fundamentals of Oracle Financials Accounting Hub


Webcast: Fundamentals of Oracle Financials Accounting Hub

Date: October 10, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT

Curious about Oracle Financials Accounting Hub (FAH)? Join us live to discover the fundamentals and ask questions. This one-hour session is recommended for technical and functional users who would like to understand the basis of Oracle Financials Accounting Hub (FAH).


  • Introduction to Oracle Financials Accounting Hub
  • Financials Accounting Hub Setup
  • Troubleshooting.


For more details and how to register see Doc ID 1577621.1

Thursday Aug 22, 2013

Webcast: Using Subledger Accounting (SLA) to Override Accounting Created by Auto-Accounting


Webcast: Using Subledger Accounting (SLA) to Override Accounting Created by Auto-Accounting

Date: September 4, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT

Learn how Subledger Accounting(SLA) allows you to select accounting combinations from a variety of sources. Get an overview of the components of SLA and how they can be used to influence the accounting created by the sub-ledgers. This one-hour session is recommended for technical and functional users of Receivables, Payables, Fixed Assets and the other subledgers who would like more information on using SLA to override accounting created by AutoAccounting in Release 12. We will discuss Journal Line Types, Account Derivation Rules, Mapping Sets, Journal Descriptions and the use of Descriptive Flexfields. Illustrative examples showing account replacement will also be provided.


  • Use of Journal Line Types
  • Account Derivation Rules
  • Mapping Sets
  • Journal Descriptions
  • Use of Descriptive Flexfields
  • Examples showing account replacement:
    • for negative revenue lines with a fixed accounting combination
    • for freight lines with fixed accounting based on the Transaction Line Descriptive Flexfield
    • for exchange gain and loss based on the Transaction Type Receivable Account or Remittance Bank Cash Account.


For more details and how to register see Doc ID 1564394.1

Friday Aug 16, 2013

AR: Learn The Impact Of System Options Checkbox "Create Detailed Distributions"

The Create Detailed Distributions check box in the Receivables system options form was created as part of the "Merge Distributions Enhancement" (Bug: 7559194: LINE LEVEL DISTRIBUTIONS NOT NEEDED FOR HEADER LEVEL CASH APPLICATION/ADJUSTMENT).  Distributions were getting created at the level of granularity of an invoice line.  This would result in a large number of distributions/meta data being passed to the Sub ledger Accounting Module.

When the checkbox is checked, Receivables will create detailed invoice line level distributions.  These detailed distributions allow the system to create line level applications for receipts and adjustments.

You should CHECK this checkbox if any of the conditions below are true:

1. If the Primary or Secondary ledgers associated with the operating unit is using one of the following subledger accounting representations:

  • The Multifund Receivable accounting representation, where receivable accounting lines for an invoice are created at the level of invoice line.
    Note: Release 12 seeds Subledger accounting methods: Multi-Fund Accrual - Account Method and Multi-Fund Accrual - Balancing Method
  • The Cash Basis accounting representation, where accounting is created only at the time of receipt of cash.
    Note: Release 12 seeds Subledger accounting methods: Encumbrance Cash and Standard Cash

2. If you want to apply receipts or adjustments to invoice lines using Line level Cash Application feature or Line Level Adjustment feature.

3. If you want to derive account code fully or partially from the invoice lines when accounting for adjustments or receipt applications.

Keep in mind that checking this box could cause performance issues.  There will be a larger volume of distribution records, which could potentially cause performance issues during the Submit Accounting or Create Accounting process for Receipt Applications.  There are two patches that will aid in performance issues (Patch 16198666 and Patch 16060007) See Doc ID 1534178.1 and Doc ID 1481222.1 for more details in preventing any performance related issues.

When the checkbox is UNCHECKED, Oracle Receivables will create summarized distributions. The receivable distributions for adjustments and applications are not maintained at the invoice line level, instead a summarized receivable distribution is created at the invoice header level. Adjustments and receipt applications are not pro-rated across the invoice lines. This is same way the receivable distributions are created in Release 11i.

Following is the impact of having the checkbox UNCHECKED:

  • When you create Batch Sources (Navigation: Setup > Transactions > Sources), in the Batch Source tab, the checkbox Generate Line Level Balances will be disabled.
  • When you create Receipt Applications (Navigation: Receipt > Receipts) in the Applications form, the Apply in Detail button will be disabled.
  • When you create Adjustments against transactions (Navigation: Transactions > Transactions, Toolbar Menu Actions > Adjust) in the Account, IDs tab, the Line column will be disabled.
  • When using the Receipt or Adjustment APIs, you cannot create line level applications.

For an explanation on the validation that takes place when checking and unchecking the box see Doc ID 1081657.1.


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



« July 2016