Receivables Source Sold To Customer Account Identifier (SOLD_TO_CUSTOMER_ID) Not Working

(Doc ID 1503344.1)

Last updated on NOVEMBER 07, 2012

Applies to:

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

Symptoms

Sign into Accounts Receivable application.

Create Account Derivation Rule (ADR) for invoice revenue using source Sold To Customer Account Identifier (SOLD_TO_CUSTOMER_ID).
Run create accounting which completes successfully but the intended account is not generated.

Reviewed the Transaction Objects Diagnostic Output which shows the AR_SOLD_TO_CUSTOMERS_S_V view is null.
This means the source is not passing the sold to customer id.

This only happens with invoices. This is not happening with credit memos, which uses a different but very similar source: Credit Memo Sold To Customer Account  Identifier (CM_SOLD_CUST_ACCOUNT_ID)

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