Create Accounting Issue: In Multi-Fund (MFAR) Create Accounting Fails for Adjustments, Credit Memos and Receipt Applications Due to Incorrect Value in Reference Columns (Doc ID 1289547.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.
EXECUTABLE:XLAACCPB - Create Accounting
EXECUTABLE:ARACCPB - Submit Accounting

Symptoms

Following are manifestations of the error:

  1. Zero amount adjustments fail to account with MFAR accounting definitions with error:

    The applied-to sources provided for this line are invalid or incomplete. Either the transaction line may not be applied to a previous transaction, or your journal line definition is incorrectly defined to support business flow functionality.This line cannot be accounted until the accounting event that it references has been fully accounted.  Please ensure the accounting events for the transaction with the following identifiers for the application Receivables have been accounted:customer_trx_id: xxx

  2. When adjustments, credit memos or receipt applications are created in a Multi-Fund Accounting environment against invoices that were created prior to R12 upgrade, Create Accounting fails with:

    Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Transaction Distribution GL Account with reference owned by Oracle. Please review the account derivation rule and make sure it derives a valid accounting flexfield combination for the source values passed for the transaction.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms