Unable To Generate Account Derivatiion Rule For On Account Receipt To Use Bill To Site

(Doc ID 2190349.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Unable to Create Custom Account Derivation Rule for On Account Receipt in using Bill To Site Receivable code combination (CCID)
The default On Account CCID is defined on the Bank but need this to pull the value from the Bill To site.
Followed the Oracle SLA guidelines by defining a new ADR to derive the CCID from the Customers Bill To Site Receivables Account and attached that to the JLD for Receipt Class and Receipt On Account Application JLT.

When create accounting is run, it error with:

Subledger Accounting was unable to derive an accounting code combination using the account derivation rule 'XXX UNAPP CUST RCV ACC' 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.



What setup is missing?
 

Solution

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