Procurement - EBS (MOSC)

MOSC Banner

Getting Error PO through API . ORA-00001: unique constraint (PO.PO_LINES_U2) violated in Package po.

edited Mar 28, 2020 5:00AM in Procurement - EBS (MOSC) 6 commentsAnswered

Hello Expert,

Hope you guys can help me. we are customize concurrent PO Auto create from requisition using  API. after applied Patch 24601864 we are getting a weird error message when run The concurrent Auto create, it was working fine previously but now it is failing with the following error debug:

----------------------------------------------------------------------

ORA-00001: unique constraint (PO.PO_LINES_U2) violated in Package po.plsql.PO_LINES_DRAFT_PKG. Procedure merge_changes.10User-Defined Exception in Package po.plsql.PO_LINES_DRAFT_PVT. Procedure apply_changes.40 User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure apply_changes.10 User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure transfer_draft_to_txn.40 User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure transfer_draft_to_txn.10 User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure create_update_doc.60 User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure process.80 User-Defined Exception in Package po.plsql.PO_PDOI_PVT. Procedure start_process.120 User-Defined Exception at location 020 in Package PO_INTERFACE_S Procedure create_documents

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