Baseline Award Budget Fails ORA-00001: unique constraint (GMS.GMS_BALANCES_U1) violated (Doc ID 1337204.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Grants Accounting - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

GMSBUDSB module: GMS: Submit/Baseline Award Budget completes with error status.
When trying to baseline an Award Budget the Concurrent program GMS: Submit/Baseline Award Budget completes in error.

Stage:800;ORA-00001: unique constraint (GMS.GMS_BALANCES_U1) violated
Update balance failed while baselining the budget.
GMS_BUDGET_PUB.BASELINE_BUDGET - Error occurred in gms_sweeper.upd_act_enc_bal
GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to Y on previous baselined budget version
GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to N on newly baselined budget version id
GMS_BUDGET_PUB.BASELINE_BUDGET - Updating budget to submitted status
Award Budget Submit/Baseline process failed.
GMS_BUDGET_PUB.BASELINE_BUDGET - In when others exception
GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Exception :-20001-ORA-20001:

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