Credit Management Workflow: Credit Application Program (ARCMGTAP) is Completing with Error - ORA-08004: Sequence AR_CMGT_CF_DTLS_S.NEXTVAL Exceeds MAXVALUE (Doc ID 1614841.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Credit Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting the run a Credit Application (ARCMGTAP) to create case folders and all the workflows are failing with the following error:

AR_CMGT_WF_ENGINE.GATHER_DATA_POINTS(ARCMGTAP, 4745515, Unable to Generate Case Folder, Error while calling AR_CMGT_CONTROLS.POPULATE_CF_ADP_DETAILS for Data Point Id: 20212Error :Error While trying to populate Case folder Details ORA-08004: sequence AR_CMGT_CF_DTLS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated) Wf_Engine_Util.Function_Call(ar_cmgt_wf_engine.gather_data_points, ARCMGTAP, 4745515, 247176, RUN)

Steps to Reproduce:
Responsibility
: Credit Management Super User
Navigation
: Credit Application
Create a new Credit Application
View the workflow errors.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms