Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Reset Record Number Sequence — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reset Record Number Sequence

Received Response
26
Views
5
Comments
edited Jan 3, 2020 10:43AM in Sales 5 comments

Content

Hi

Currently in the custom object the record numbering sequence is given as ABC-YY{0000} based on which if any record is created for the current year it is showing as ABC-209845.

But how do I reset the numbering sequence to start fresh for the current year as for example if the record is created from January 2020 the record number should have first two digits as year 20 (for the current year 2020) and the next four digits sequence should start from 0001. Hence the record number should appear as ABC-200001, ABC-20002, ABC-20003 .......

Kindly advise

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!