My Oracle Support Banner

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:

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


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


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

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