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 Name WFENG_COMMIT_INSIDE
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,
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!