Auto-generation of Customer Account Number with unique sequence generator
Has anyone customized the auto-generation of the Account Number to not use the seeded Oracle sequence, but instead use their own sequence to create alpha-numeric combinations?
(hz_cust_accounts.account_number generation).
If yes, have you found any gotchas based on how many different ways navigating in EBS may get you to a point where Oracle needs to generate the account number?
(API use to create account; interface tables create account; Oracle iStore-to-Quoting-Order Management account creation; manual customer account entry in standard form; Oracle Cloud Commerce integration; Oracle CPQ integreation)