Payables and Cash Management - EBS (MOSC)

MOSC Banner

update table ce_statement_lines_interface

edited Aug 20, 2021 7:45AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center