ARXCUDCI - Customer Account Numbering Is Skipping Next Sequence Value For Potential Duplicate Address (Doc ID 1403113.1)

Last updated on JULY 12, 2017

Applies to:

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

Goal

In 11.5.10.2, automatic numbering for customer accounts is used and the sequence is set to no cache.  However, when creating a new customer account with a new address that is a potential duplicate of existing addresses, the next value in the sequence is being skipped.

Query the customer accounts in HZ table and note the next account number was skipped.

The skipping only occurs when there is a potential duplicate and when users are creating a customer account address for a new customer account, not an existing customer account.
This can be reproduced every time.

The sequence is set as follows:

 

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