Projects - EBS (MOSC)

MOSC Banner

Why are there sequence gaps in auto generated project numbers?

edited Apr 12, 2016 2:28PM in Projects - EBS (MOSC) 5 commentsAnswered

A question came up yesterday as to why there are gas in the sequence of project numbers that are automatically generated.  At first I thought, oh, Oracle must be using a sequence for generating the number and it must be aging out.   But after doing some digging it looks like the number is set in table pa_unique_indentifier_control and incremented by 1 when a new project is created.   Found this code below:

  SELECT NEXT_UNIQUE_IDENTIFIER

  INTO uniqueid

  FROM PA_UNIQUE_IDENTIFIER_CONTROL

  WHERE TABLE_NAME = x_table_name

  AND NEXT_UNIQUE_IDENTIFIER IS NOT NULL

  FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center