Receipt Accounting Error - 95353 Subledger Accounting Was Unable To Derive An Accounting Code Combination Using The Account Derivation Rule Remit Bank Unapplied Account (Doc ID 2168299.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Receivables - Version 12.1.1 and later
Oracle Cash Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Subledger Accounting Uptake for Receivables


The following error is occurring when attempting create accounting of a Receipt with newly created bank account:
ERROR
-----------------------
95353 Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Remit Bank Unapplied account 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.

Verified that the remittance bank account in receipt method has a valid  unapplied receipt gl account.
Also check the setup using the following SQL:

SELECT a.receipt_method_id
, a.remit_bank_acct_use_id
 , a.org_id
 , a.cash_ccid
 , a.unapplied_ccid
FROM ar_receipt_method_accounts_all a
       , ar_cash_receipts_all b
WHERE a.remit_bank_acct_use_id = b.remit_bank_acct_use_id
AND a.receipt_method_id = b.receipt_method_id
AND a.org_id = b.org_id
AND b.cash_receipt_id = &the_cash_receipt_id;

 

It returns a valid code combination id for unapplied receipt.

 

Changes

 The receipt is created with newly added bank account.

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