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

Last updated on JULY 12, 2017

Applies to:

Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 3-Aug-2015***

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

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 hundreds of Community platforms