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 11, 2022

Applies to:

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.