After 11g Upgrade, Dunning Failing: ORA-01858: a non-numeric character was found
(Doc ID 1427063.1)
Last updated on JANUARY 11, 2021
Applies to:
Oracle Advanced Collections - Version 11.5.10.2 and laterInformation 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 |