How to set the customer number
Last updated on JULY 12, 2017
Applies to:Oracle Receivables - Version 220.127.116.11 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms