My Oracle Support Banner

Workflow Failing On Line Invoice Interface (Doc ID 286701.1)

Last updated on SEPTEMBER 17, 2020

Applies to:

Oracle Shipping Execution - Version 11.5.8 to 11.5.10.CU2 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.


When attempting to interface a shipped OM Sales Order Line to AR it errors out.

Have tried the retry workflow from Sys Admin - but get errors:

Invoice Interface - Line/Invoice Interface workflow process of :-

Error Message 3146: Commit happened in activity/function

Error Stack OE_Invoice_WF.Invoice_Interface(OEOL, 341539, 75942, RUN)
Wf_Engine_Util.Function_Call(OE_INVOICE_WF.INVOICE_INTERFACE, OEOL, 341539,
75942, RUN)

From the Exception Management in the Sales Order form (after applying patch 3731146)
the following message is obtained -

The Workflow Activities in Error screen is then displayed showing Invoice
Interface as the activity in error.  Hit 'OK', then error message appears saying:

'ORA-01422: exact fetch returns more than requested number of rows in Package
OE_Invoice_PUB Procedure Interface_Single_Line.'

Press 'OK' and a second screen appears saying :
'Workflow Activity Invoice Interface has failed.Please fix errors and retry.'


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.