Applying ESR 66188 -> 56572 oracle scripts generate unique constraint violations (Doc ID 1028523.1)

Last updated on OCTOBER 25, 2016

Applies to:

Sun B2B - Version: 4.5.0 and later
Information in this document applies to any platform.

Symptoms

When applying ESR 66188 -> 56572 (oracle), reecieve the following errors:

ERROR at line 1:
ORA-00001: unique constraint (EX_ADMIN.ES_BIZ_ATTRIB_HDR2) violated
insert into es_biz_attrib_alias values(es_biz_attrib_alias_sq.nextval, es_biz_attrib_hdr_sq.currval, 'HIPAA_VALIDATOR')
*
ERROR at line 1:
ORA-02291: integrity constraint (EX_ADMIN.ES_BIZ_ATTRIB_ALIAS_FK1) violated -
parent key not found
insert into es_biz_attrib_det values(es_biz_attrib_det_sq.nextval, es_biz_attrib_hdr_sq.currval, 'Y', 'YES')
*ERROR at line 1:
ORA-02291: integrity constraint (EX_ADMIN.ES_BIZ_ATTRIB_DET_FK1) violated -
parent key not found
insert into es_biz_attrib_det values(es_biz_attrib_det_sq.nextval, es_biz_attrib_hdr_sq.currval, 'N', 'NO')
*ERROR at line 1:
ORA-02291: integrity constraint (EX_ADMIN.ES_BIZ_ATTRIB_DET_FK1) violated -
parent key not found

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