How To Check When and Who Last Changed Autonumbering Via UI

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The autonumber next value rolled back.

How can it be checked who changed it? Was it due to an direct database or upgrade activity?

Example: The last created project code is PRJ-123 
The next code that is expected to be generated is PRJ-124, however it is PRJ-001 (or an unused sequence number) less than 124.

Resolution

The issue is not due to upgrade activity.

The following query can be used to check the next number generated for an object.

SELECT a.id, a.object_code, a.ATTRIBUTE_CODE, b.SEGMENT_CODE, a.NEXT_VALUE, a.MAX_LENGTH, a.CREATED_DATE, a.CREATED_BY, 
a.LAST_UPDATED_DATE, a.LAST_UPDATED_BY
FROM
CMN_AUTONUM_SCHEMES a,
CMN_AUTONUM_SCHEME_SEGMENTS b,
SRM_RESOURCES c
WHERE a.id = b.SCHEME_ID AND c.USER_ID = b.LAST_UPDATED_BY
AND a.OBJECT_CODE = 'project'
AND a.ATTRIBUTE_CODE = 'unique_code'
--AND b.SEGMENT_CODE = 'NUMERIC'
--AND a.next_value LIKE to_char('%PRJ%')
ORDER BY b.LAST_UPDATED_DATE desc