update table ce_statement_lines_interface
Dear All,
im trying to update this table for customization purpose but it gives an error, can you please check
update CE.ce_statement_lines_interface set statement_number = PH_statement_number , line_Number = k where bank_account_num = p_account_number and statement_number = PHL_statement_number;
since there s no API i'm using the direct update and since it is an interface, i guesse there is no problem
max we can purge all data
but it gives an error : Exception: -1 - ORA-00001: unique constraint (CE.CE_STATEMENT_LNS_INTERFACE_U1) violated
can you please check..
thank you in advance