ORA-01722 Error When Opening Contract after UDA Was Configured and Enabled
(Doc ID 2333170.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Procurement Contracts - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Contract Terms Authoring
When attempting to add and use UDAs (User Defined Attributes), the following error occurs.
Error
'You have encountered an unexpected error. Please contact the System Administrator for assistance.
Stack trace shows the following:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT
orca.uda_template_id,
epv.object_id,
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 ,
fnd_objects fo
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
STEPS
-----------------------
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.
Changes
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 |