Patch 4681056 : 11.5.10.2 : ORA-02293: cannot validate (REC.REC_INVOICE_TYPES_C8) - check constraint

Hi Ellen,Welcome to the new EBS Patching community.

This thread will address your issue on this patch


old   3: USING INDEX TABLESPACE &3
new   3: USING INDEX TABLESPACE APPS_TS_TX_IDX

Table altered.


Table altered.


Table altered.

ALTER TABLE REC_INVOICE_TYPES DROP CONSTRAINT REC_INVOICE_TYPES_C8
                                              *
ERROR at line 1:
ORA-02443: Cannot drop constraint  - nonexistent constraint


ALTER TABLE REC_INVOICE_TYPES ADD CONSTRAINT REC_INVOICE_TYPES_C8 CHECK (contab_flag in ('S','N','R'))
                                             *
ERROR at line 1:
ORA-02293: cannot validate (REC.REC_INVOICE_TYPES_C8) - check constraint
violated