My Oracle Support Banner

Do We Need to Increase Max Value of INV.MTL_CATEGORY_SETS_S ? (Doc ID 2552680.1)

Last updated on AUGUST 14, 2021

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

MTL_CATEGORY_SETS_S information can checked using below SQL.
Likes SEQUENCE_NAME, MIN_VALUE, MAX_VALUE, LAST_NUMBER

When usage rate calculates, result is over 51%.
Example)
Usage rate = LAST_NUMBER / MAX_VALUE * 100
For MTL_CATEGORY_SETS_S case,
LAST_NUMBER : 1100000042
MAX_VALUE : 2147483647
So, usage rate is 51.22% = 1100000042 / 2147483647 * 100

Do we need to INCREASE MAX VALUE OF INV.MTL_CATEGORY_SETS_S for future?


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.