My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2019

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)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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