ORA-01722 Error When Opening Contract after UDA Was Configured and Enabled
Last updated on FEBRUARY 23, 2018
Applies to:Oracle Procurement Contracts - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Contract Terms Authoring
When attempting to add and use UDAs, the following error occurs.
'You have encountered an unexpected error. Please contact the System Administrator for assistance.
Stack trace shows the following:
JBO-27122: SQL error during statement preparation. Statement: SELECT
epv.page_id as uda_page_id,
epv.internal_name as tab_code,
epv.display_name as tab_name,
epv.SEQUENCE as tab_sequence
FROM okc_rep_contracts_all orca,
ego_pages_v epv ,
WHERE orca.contract_id = :1
AND epv.classification_code = orca.uda_template_id
AND epv.object_id = fo.object_id
AND fo.obj_name LIKE 'OKC_REP_CONTRACTS_UDA'
ORDER BY epv.SEQUENCE
Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
The issue can be reproduced at will with the following steps:
1. Single row and single column UDA was configured and setup was performed per instructions specified in documentation.
Configured and enabled for Repository Contracts and the error is seen when opening any Contract
Note: Once UDA config is disabled application is behaves as normal.
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