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

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

Thursday Sep 26, 2013

Webcast: Fundamentals of Oracle Financials Accounting Hub

Webcast.jpg

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

TOPICS WILL INCLUDE:

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

REGISTER.jpg


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

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.

TOPICS WILL INCLUDE:

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

REGISTER.jpg


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.

 

Friday May 24, 2013

Are You Using Encumbrance Accounting in 12.1.3 Procurement?

Are you using Encumbrance accounting in 12.1.3 Procurement?  If so, this could potentially impact you!

So what’s the issue? After applying March 2013 RUP Patch 15843459, when attempting to cancel a Purchase Order line with backing requisition, without cancelling the requisition, the following error occurs.

Error after patching

So what’s the fix? To resolve this issue apply Patch 16781315:R12.PO.B. For more information see Doc ID 1553897.1.

.

Thursday Aug 30, 2012

Oracle Payables Accounting Information Centres

Payables Accounting Information Centers

Do you have error when trying to create accounting in Payables ?

Do you have questions about Payables Accounting ?

The following new Information centers include solutions to many of the issues and answers to your questions.

         Overview  Hot Topics Resources

Information Center: Oracle Payables Accounting R12 ( Doc ID 1476284.2)


Under Hot Topics:

Include details about: Recommended patches, new solution documents, GDF patches, Announcements, links to Communities.

Under Resources:

Popular Troubleshooting documents, Accounting Documentation,

popular Knowledge documents, links to other info centers.

 Use  

Information Center: Using Oracle Payables Accounting (Doc ID 1478842.2)

Include product documentation, Reconciliation, Upgrade, Performance, Undo Accounting, Trace and FND Debug, and Diagnostics.

Troubleshoot

Information Center: Troubleshooting Oracle Payables Accounting (Doc ID 1478863.2)

Include Troubleshooting documents, Period close, GL Transfer, Trial Balance, Budget, Health Check.

Do you have other questions..............?


Post your question to the Oracle Payables Community

1. Log into My Oracle Support.
2. Click on the 'Community' link at the top of the page.
3. Click in 'Find a Community' field and enter Payables 
4. Double click on Payables in the list.

OR 

 Click Here

Thursday Mar 22, 2012

Upcoming Webcast: Cost Management Intercompany Accounting for Internal Order and Drop Shipment

ADVISOR WEBCAST: Cost Management Intercompany Accounting for Internal Order and Drop Shipment
PRODUCT FAMILY: Cost Management

April 10, 2012 at 11 am ET, 9 am MT, 8 am PT

This one-hour advisor webcast discusses Intercompany Accounting for Internal Order and Drop Shipments. This session is recommended for technical and functional users who work on the costing part of the Internal Order and Drop Shipment cycles.

TOPICS WILL INCLUDE:
  • Understand the various setups involved in Intercompany Accounting
  • Understand the accounting entries generated for different setups in Intercompany Accounting

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
« April 2014
SunMonTueWedThuFriSat
  
1
5
6
12
13
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today