How to set the customer number (Doc ID 265315.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Goal

How can the customer number be set to a specific number in ar.HZ_ACCOUNT_NUM_S after upgrade or at a fresh install so that customer numbers being assigned in the application are not duplicate of numbers in the legacy system. Currently, system defaults to 1000 when an upgrade from 10.7 or 11 to 11i occurs. It also sets to 1000 for a fresh install and then looks for "gaps" in the numbering sequence to fill in. You can use this same note to adjust/Reset the Customer Number sequence in Release 12 as well.

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