Invoice Activity failing ORA-01403: no data found ORA-06512: at "APPS.OE_INVOICE_PUB" (Doc ID 1186658.1)

Symptoms

On : 12.0.6 version, Finance & Accounting

Invoice Interface activity , intermittently , fails with

ERROR
-----------------------
ORA-01403: no data found ORA-06512: at "APPS.OE_INVOICE_PUB", line 1156 ORA-01403: no data found in Package OE_Invoice_PUB Procedure Interface_Single_line

and the Line remains stuck at Fulfilled status.

However Retry Activities in Error retries the failing Invoice Interface activity successfully.


STEPS
-----------------------
The issue is not reproducible at will

HTMomse output shows

WORKFLOW LINE STATUS ERRORS
LIN_ID PROCESS_NAME ERROR_ACTIVITY_NAME RESULT ACT_STATUS
ERR_RETRY_ROLE ERR_RETRY_USER ERROR_NAME ERROR_MESSAGE ERROR_STACK
515399 Invoice Interface - Line Invoice
Interface Exception Error -20001 ORA-20001:
OE_Invoice_WF.Invoice_Interface(OEOL, 515399, 206951, RUN)
Wf_Engine_Util.Function_Call(OE_INVOICE_WF.INVOICE_INTERFACE, OEOL, 515399,
206951, RUN)

LINE PROCESSING MESSAGES
WARNING LINE HEADER_ID LINE_ID MSG_SOURCE ACTIVITY REQUEST_ID
DESCRIPTION MESSAGE_TEXT
2 11.1 77332 515399 W=Workflow Invoice Interface Workflow activity
Invoice Interface has failed. Please fix the errors and retry the activity
from the Order Form or the Workflow Monitor.
2 11.1 77332 515399 W=Workflow Invoice Interface ORA-01403: no data
found ORA-06512: at "APPS.OE_INVOICE_PUB", line 1156 ORA-01403: no data
found in Package OE_Invoice_PUB Procedure Interface_Single_line

Cause

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