1. Implementing Service Center with the Classic User Experience
  2. Why are some service request reference numbers missing from the sequence?

Why are some service request reference numbers missing from the sequence?

Service request (SR) reference numbers aren't guaranteed to be in sequence. That's because they're generated as soon as the user clicks the Create Service Request button on the Service Requests page.

If the user decides to cancel the SR, then that SR reference number is lost because the same number isn't used again by the application.

SR reference numbers could be missing because of the following reasons:

  • The SR reference numbers are based on a document sequence which has a cache size of 1000. So whenever a database server is restarted, it pulls the next 1000 numbers, even if the last set of 1000 numbers weren't all used up.

  • If you have a couple of missing SR reference numbers within the set of 1000 numbers, the reason could be any of the following:

    • The SR was deleted.

    • An error occurred when the SR was being created.

    • The SR was canceled midway while creating it.