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

Last updated on MAY 20, 2024

Applies to:

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

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