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 18.104.22.168 and later
Information in this document applies to any platform.
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
Strategy send work item failed
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
iexvxmlb.pls:SEND_COPY: End GetXmlData...
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"
Upgraded RDBMS to 11g
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