My Oracle Support Banner

GMF_TRANSACTION_VALUATION_S is almost maxing out (Doc ID 2656759.1)

Last updated on MAY 28, 2021

Applies to:

Oracle Process Manufacturing Financials - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On :  12.0.6 version, Other Financial Issues

ACTUAL BEHAVIOR  
---------------
The GMF_TRANSACTION_VALUATION_S  is almost maxing out



EXPECTED BEHAVIOR
-----------------------
Not to max out the sequence number

SEQUENCE_OWNER       SEQUENCE_NAME       MIN_VALUE  MAX_VALUE LAST_NUMBER PCNT_REACHED
------------------------------ ------------------------------ ---------- ---------- ----------- ------------
GMF       GMF_TRANSACTION_VALUATION_S       1 2147483647  2044691140   95.2133509

STEPS
-----------------------

1. Check the table GMF_TRANSACTION_VALUATION_S  and it is almost maxing out

Proactively monitoring for Sequences that are at verge of maxing out in production system.

Mentioned sequence has cycle_flag N and is at 2044691140 with max set at 2147483647.

    Customer Visible  

 

 

 

 

Changes

 

Need confirmation if sequence can be reset/reinitialized?

Cause

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
Symptoms
Changes
Cause
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.