1 Reply Latest reply: Jan 4, 2013 4:55 AM by Keith Jamieson RSS

    how to identify check constraint error

    959687
      {this is my error occurred like check constraint error
      122612 04:33:03:Code :ORA-02290: check constraint (OPS$CMS.CS_JEMQ_NODATA4JE_CT16) violated at XOPMASTERat sub exec block in pop_je2acct_othr}

      so please guide me how to identify the check constraint error where its exactly comeup with .. i found the constraint which is applied for this particular error and table name is ->tb_jem
      which is the constraint {CONSTRAINT CS_JEMQ_NODATA4JE_CT16
      CHECK (SHARES + TAX_AMT + REIMBURSE_AMT + BULKING_AMT + GL_AMT + REVENUE_AMT + SAR_CASH_AMOUNT + SAR_SHARES !=0) DISABLE,
        CHECK ("SETTLE_DT" IS NOT NULL) DISABLE,}