My Oracle Support Banner

ORA-01722: Invalid Number During AAI 806 Upgrade From AAI 804 (Doc ID 2632408.1)

Last updated on JANUARY 31, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Information in this document applies to any platform.

Goal

AAI UPGRADE DURING BD804 TO 806 RESULTED IN ORA-01722: INVALID NUMBER ERROR

OFSAAIUpdate.log shows following error:-

Log [2020-01-22 12:56:58.026] [OFSAAIUPDATE] [ERROR] - Exception while executing the query - update AAI_WF_APP_PACKAGE_B a set a.v_definition_page_url = 'solution/abc_qtnr/QtnrRedirectFrmPMFInbox.jsp?appCode={appId}&appId={appId}&qtnrId={WF_OBJECT_ID}&usrLocale={WF_LOCALE}&stdMode=true' where a.v_app_package_id = 11
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
 

Solution

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
Goal
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.