Wednesday Apr 02, 2014

Webcast: Understanding Event Based Revenue Management & Revenue Contingencies

Webcast_icon.jpgWebcast: Understanding Event Based Revenue Management & Revenue Contingencies

Date: April 16 , 2014 at 11:00 am ET, 9:00 am MT, 4:00 pm GMT, 8:30 pm IST

This one-hour session is recommended for technical and functional users who want to learn about the new Release 12 feature, Event Based Revenue Management and use it in their business. We will review concepts, setups, technical details and provide a demonstration..

Topics will include:

  • Overview of Event Based Revenue Management
  • Contingencies
  • Revenue Policy
  • Setups
  • Technical Details

Details & Registration: Doc ID 1614225.1

Thursday Oct 31, 2013

Webcast: Oracle Loans Overview - Features, Demonstration & Data Model

Webcast_icon.jpgWebcast: Oracle Loans Overview - Features, Demonstration & Data Model

Date:  November 13, 2013 at 10 am ET, 9 am CT, 8 am MT, 7 am PT

Come learn about Oracle Loans features & data model.  This one-hour session is recommended for technical and functional users who use or are planning to use Oracle Loans.

Topics will include:
  •     Definition and feature summary
  •     Key business concepts for Oracle Loans
  •     Direct Loans demonstration
  •     Introduction to the Loans data model
Bring your questions!


For more details on how to register, see Doc ID 1590843.1.

 Remember that you can access a full listing of all future webcasts as well as replays from Doc ID 7409661.1.

Thursday Oct 10, 2013

Webcast: Receivables Release 12 Late Charges Functionality


Webcast: Receivables Release 12 Late Charges Functionality

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

Have you got questions about the Receivables Late Charges functionality? This one-hour session is recommended for technical and functional users who use the Late Charges functionality in Oracle Receivables.

Topics will include:

  • Overview of Late Charges Functionality
  • Defining Organizational Late Charge Policy
  • Set up Customers & Sites for Late Charges
  • Generate Late Charges
  • Run Diagnostics


For more details and how to register see Doc ID 1581280.1

Tuesday Sep 03, 2013

AR Webcast: Tracking the Dataflow Through Important Receipts Tables


Webcast: Tracking the Dataflow Through Important Receipts Tables

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

Just where does all that Receipts data go?  Join us 11-Sep-13 to find out!  This one-hour session is recommended for technical and functional users who would like to gain insight into the technical data flow between important receipt related tables.

Topics will include:

  • Receipt Data Model
  • Flow of data between various receipt tables when different actions are performed


For more details and how to register see Doc ID 1574830.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

Tuesday Aug 20, 2013

AR: News Collection

Below is a listing of our recent blog postings on topics in the Accounts Receivables (AR) product area:

AR: Are you still on Release 12.0? Recommendations For A Smooth Month End Close In Oracle Receivables

Oracle Receivables highly recommends the following if you are running R12.0 application version.

1.  Upgrade to 12.0.6 if you are not on 12.0.6.

2.  Apply the latest consolidated patch for Receivables: Patch 12702898:R12.AR.A

3.  Run Import/Validate AAD following the following notes:

4.  Use the Subledger Period Close Exception Report to view all accounting events and journal entries that fail period close validation. This report helps in resolving exceptions quickly so that exceptions are not left to slow down the period-end close. It is automatically submitted by General Ledger when closing a GL period if there are unprocessed accounting events or non-transferred journal entries.
You can also generate the Subledger Period Close Exceptions Report through a concurrent request as follows:

Receivables Responsibility:
Nav: Control -> Requests -> Run
Execute the Subledger Period Close Exceptions Report

For more information on this report see Doc ID 793598.1: How to Use the Subledger Period Close Exceptions Report for Period Close Activity?

5.  Additional Patches on top of RUP patch listed below, these are current versions as of August 20, 2013.


Patch Number

Fixed File Version

Accounting Program Package 10381819:R12.AR.A ARPXLEXB.pls 120.77.12000000.105
Rules .ldt 16355924:R12.AR.A ARXLAAAD.ldt 120.47.12000000.84
Accounting Generation Package 15960521:R12.AR.A ARPDDB.pls 120.51.12000000.133
Xransfer to General Ledger 12965313:R12.XLA.A xlaaptrn.pkb 120.61.12000000.33
Rounding issues for RA CUST TRX LINE GL DIST ALL TABLE 14575753:R12.AR.A ARPLCREB.pls 120.31.12000000.29
Revenue Recognition 14102661:R12.AR.A
ARPLARLB.pls 120.42.12000000.17
Aging 7 Bucket Report 16308319:R12.AR.A ARXAGMW.rdf 120.54.12000000.67
Rounding Applications table 10176632:R12.AR.A ARRECACB.pls 120.44.12000000.52
AR Reconciliation Report 14085187:R12.AR.A ARRECONB.pls 120.22.12000000.20
AR to GL Reconciliation Report 14376360:R12.AR.A ARGLRECB.pls 120.21.12000000.43

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.


Monday Aug 12, 2013

AR: News Collection

Below is a listing of our recent blog postings on topics in the Accounts Receivables (AR) product area:

Friday Aug 09, 2013

AR: Why Can't I Inactivate Parties in Accounts Receivable?

Are you confused by Parties versus Customers in Receivables?  Are you wondering how to  inactivate a customer/party using AR forms and screens? 

Back in Release 11.5 the customer was maintained through the Customer Standard form, which was owned by Accounts Receivables.  As the data model became more complex,  the Trading Community Architecture (TCA) product and data model was created.   All applications within the E-Business suite that require interaction with a customer integrate with TCA.  Customer information is no longer stored in the individual applications but rather in a central repository/registry maintained within TCA.

For an insight into the terminology of TCA, check out the following blog entry 

Understanding the Customer Form in Release 12 from an AR Perspective!!

From a current AR perspective, when you create a new customer, you are actually creating a Customer Account.  However, because the data is now kept within TCA, the structure of data must adhere to the rules defined within TCA.  One of these rules is, You can define a Party without creating Customer Accounts for it, but a Customer Account always has to be tied to one and only one Party. In compliance with this rule, when you create a Customer Account in AR, the code automatically takes care of creating the Party associated to the Customer Account for you.

At the AR level, you will only transact at the Customer Account level and never the Party level.  This is why in the Customer form owned by AR, you will not have access to manipulate the status of the Party.  To change the status of a Party you would have to access the data via applications such as: Telesales or Customers Online.  You will still be able to inactivate the customer status in the Create Customer screen, but the related party will still be active until you also change this in these applications.

 In order to understand the specifics of these relationships, we would like to advise you of the following MOS documents which will provide you with specific information and troubleshooting tips 

Customer Form, Party Issue: How To Inactivate / Reactivate a Party? Doc ID 883461.1

Customer Form, Address/Sites: Troubleshooting, How To, Known Issues and Patches Doc ID 1437866.1

Oracle Receivables: Overview of the Customer Form in Release 12 Doc ID 1436547.1

Friday Jul 05, 2013

AR:New Look Information Centers

Have you seen the revamped Information Centers? If not, take a few minutes to check them out. Information Centers provide a one-stop portal into all that is new and latest for your functionality of choice. The format of these documents has been changed to make it even easier to search and find content. Additionally, ICs now reference bugs and enhancement requests, so you can easily identify what is going on in that area.

Below is an example of the AR Customer Workbench Information Center:

Doc ID 1478539.1

For a full listing of Receivables Information Centers, check out DocID 1473872.2.

You can also view a full listing of Information Centers across EBS by viewing DocID 444.1 and selecting the appropriate tab.

If you missed the webcast discussing Information Centers in Oracle Receivables, you can replay the recording by accessing in the Archived 2013 tab in DocID 1455839.1.

Thursday Jun 27, 2013

Tax Deducted At Source (TDS) for India Localizations

Do you have questions about TDS (Tax deducted at source) for India Localizations or want to know the latest information about this functionality?

See Doc ID 1546099.1 TDS Tax Deduction at Source for India - Master Troubleshooting Guide. The document includes sections with the following information:

Documentation and Setup of Tax Deduction at Source – this section contains a presentation with the configuration steps for the TDS feature

Resolving errors – this section contains recommended patches and documents with solutions for specific errors

Frequently asked questions  – See also our new FAQ Doc ID 1549522.1 for frequently asked questions about TDS.

Wednesday Feb 13, 2013

Autoinvoice has a New Proactive Tool: AutoInvoice Post-Process Validation Report

The Proactive Services Delivery Accounts Receivables team is pleased to announce the availability of the New AutoInvoice Post-Process Validation Report.

This new report lists down all the Interface Line Records that resulted in Validation Errors and provides insight into the cause of the issue and recommendations to fix it, along with links to Knowledge Articles applicable.

The report can perform many additional validations, such as checking for the System Options and Profile Options setup for optimal performance, listing of orphan Interface Salescredits/ Distributions/ Errors tables and more.

Start resolving your AutoInvoice issues today! Read more on this proactive tool in:
  • Doc ID 1523525.1: AutoInvoice Post-Processor Validation Report: Overview and Installation Instructions
  • Doc ID 1524708.1: How to register the AutoInvoice Post-Process Validation Report as a Concurrent Program

Monday Feb 04, 2013

Upcoming Accounts Receivables Advisor Webcasts - Don't Miss Them!


Announcing the Forthcoming Schedule of Receivables Advisor Webcasts

Don't miss the coming AR Advisor Webcasts.  

These one-hour sessions are suitable for both functional and technical users, who want to learn more about new and existing functionality, and also who need to find information in a hurry to service your business needs

 Date Time Webcast Title Registration
 06-Feb-2013  11:00 am EST  Using Oracle Receivables Search Helpers & AutoInvoice Debugging Process Flow  Doc ID 1519630.1
 13-Feb-2013  11:00 am EST  Overview and Usage of Oracle Receivables Information Centers  Doc ID 1519628.1
 27-Feb-2013  11:00 am EST  Oracle Receivables Receipts Workbench - How To Enter A Claim  Doc ID 1519629.1
 07-Mar-2013  11:00 am EST  How Social Media Helps You to Keep Your Finger on the Oracle Pulse!  Doc ID 1519632.1
 20-Mar-2013  11:00 am EST  Oracle Trading Community - Importing DnB Data Using Bulk Import  Doc ID 1519631.1


Current Advisor Webcast Schedule and Archived Downloads can be found in DocID 740966.1

Wednesday Jan 30, 2013

Why didn’t Tax get Calculated on My Invoice?

The most frequent question we get in EBS Financials support............Why won't my tax calculate?   In Release 12, many factors can influence tax applicability and prevent a tax from being levied on an invoice.  Frequently this is a setup issue - either an unintended consequence of a setting, or even a setting that has not been saved correctly.  We thought it would be helpful to run through some of the troubleshooting steps we follow when trying to diagnose your tax calculation issues!

  • Tax Regime
Navigation: Tax Managers > Parties > Party Tax Profile
  • Tax

Navigation: Tax Managers > Parties > Party Tax Profile > Main Tab 

  • Tax Status
Navigation: Tax Managers > Tax Configuration > Tax Statuses
  • Tax Rate and Jurisdiction
    • Dates on the transaction must fall within those on the Rate and Jurisdiction
    • Tax Rate must be defined as a child to the tax status derived in the prior section
  • Tax Rules
    • Users are strongly encouraged to apply the latest tax rule engine patch referenced in Document 1301356.1 to avoid known issues with rule evaluations in EBTax.
    • When implementing E-Business Tax you must specify a default rules before taxes can be enabled. Make certain that the default for 'Determine Tax Applicability' is set to Applicable or that you have a rule defined and enabled that makes the tax applicable for your specific transaction.
  • Configuration Owner Tax Options

Navigation: Tax Managers > Defaults and Controls tab 

  • Intercompany (AGIS) 
    • Intercompany transactions presently do not pass a ship-to address.  Make sure that your tax rules for intercompany transactions are flexible enough to derive the proper tax rate without reliance on ship-to
  • Transaction
    • If your tax considers ship-from in Receivables, make certain you specify a warehouse on your transaction line 
    • Make certain the address on your transaction and for your Legal Entity and Operating unit are valid

This includes detailed screen shots of the setup

    • To assist in finding these records, the following document can be leveraged
This document details many of the diagnostics that can be run to get transactional data from different EBS products as well as setup information from E-Business Tax
  • Additional Considerations

E-Business tax has the flexibility to specify complex tax rules at a wide variety of levels.  Rules can consider fiscal classifications set at the party or product level, transaction classifications codes and many additional factors.  Troubleshooting expert tax rules will be addressed soon in a separate note.  Until the note is published we suggest that you read and review the examples in the following document:

DocID 1108463.1, How Tax Determining Factors Work in R12 E-Business Tax


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



« April 2014