My Oracle Support Banner

How to set the customer number (Doc ID 265315.1)

Last updated on MARCH 13, 2024

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

To view full details, 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 a vibrant support community of peers and Oracle experts.