My Oracle Support Banner

After 11g Upgrade, Dunning Failing: ORA-01858: a non-numeric character was found (Doc ID 1427063.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Advanced Collections - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

You have recently upgraded your RDBMS to 11g and now find the work items to send dunning letters showing status = In Error.

Reviewing the Workflow, you see something like this:
Monitor Activity History screen
activity history for IEXSTFFM, 47118
Fulfillment Failed
Strategy send work item failed
system error

Your FND Debug taken while reproducing this issue shows something like this:
OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.OAException:
Exception: ORA-01858: a non-numeric character was found where a numeric was
expected ,In VO: null

GetXmlData: Exc_Error:ORA-29532: Java call terminated by uncaught Java
exception: java.lang.NullPointerException
iexvxmlb.pls:SEND_COPY: End GetXmlData...
iexvxmlb.pls:SEND_COPY: l_return_status=E
iexvxmlb.pls:SEND_COPY: error to get XML data
iexvxmlb.pls:SEND_COPY: Exc_Error:User-Defined Exception
"iextxmlb.pls:update_row:Exception errmsg=ORA-01403: no data found
ORA-06510: PL/SQL: unhandled user-defined exception"

Changes

Upgraded RDBMS to 11g

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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