My Oracle Support Banner

Order Lines Stuck In Fulfilled, OE_Invoice_WF.Invoice_Interface 'Error ORA-02290: check constraint' (Doc ID 330020.1)

Last updated on JANUARY 31, 2018

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

Order lines are stuck in fulfilled status.

The error in workflow is:

Error Name :-20001
Error Message: ORA-20001:
Error Stack:
OE_Invoice_WF.Invoice_Interface(OEOL, 8116625, 166041, RUN)
Wf_Engine_Util.Function_Call(OE_INVOICE_WF.INVOICE_INTERFACE, OEOL, 8116625,


The retry_invoice.sql output shows this error:

L_MSG_DATA=OEXPINVB() Others Error ORA-02290: check constraint (AR.RA_INTERFACE_LINES_C1)
violated in Package OE_Invoice_PUB Procedure Insert_Line

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.