ORA-01722 Error When Opening Contract after UDA Was Configured and Enabled
(Doc ID 2333170.1)
Last updated on JULY 14, 2020
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 (User Defined Attributes), 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 behaves as normal.
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