APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02054, ORA-02051 on MERGE across a DB Link

Jeffrey KempOct 10 2017 — edited Oct 12 2017

I'm building a maintenance form in APEX that inserts/updates/deletes a table across a database link. My single-record edit form works fine but when I try to MERGE (after using the APEX Data Load feature to load data from a CSV file) I get the following error:

Error processing request.

ORA-02054: transaction 6.6.99765 in-doubt
ORA-02051: another session or branch in same transaction failed or finalized

ORA-02063: preceding line from EBS_AR_IFACE_LINK

ORA-20876: Stop APEX Engine

This error appears whether I use an actual MERGE statement, or if I use a loop with an update / insert.

Any ideas on what I should try?

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

Oracle Application Express 4.2.2.00.11

This post has been answered by Jeffrey Kemp on Oct 11 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2017

Added on Oct 10 2017

#apex, #apex-discussions

1 comment

1,307 views