Receipt Application and Adjustments Fail Create Accounting Shows Error Number 95353 "Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Distribution GL Account owned by Oracle." (Doc ID 2992787.1)

Last updated on APRIL 22, 2024

Applies to:

Symptoms

When running Create Accounting, the Subledger Accounting Program Report shows error for both Receipt application and or Adjustments against the same transaction.

STEPS
Responsibility: Receivables Manager
1. Create invoice
2. Run Create Accounting to post the invoice
3. Create Receipt against the invoice
4. Create multiple Adjustments against the invoice
5. Run Create Accounting, both the receipt and adjustment fail with the same error

Review of table RA_CUST_TRX_LINE_GL_DIST_ALL identifies that at the time the invoice was generated, the account code_combination_id (ccid) used related to Collected Tax account was not valid:
example:

When the receipt is applied, tha AR_DISTRIBUTIONS_ALL table generates with deferred tax and the following accounting:

When the adjustment is applied, the AR_DISTRIBUTIONS_ALL table generates with deferred tax and the following accounting:

Cause

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