ORA-01722 Error When Opening Contract after UDA Was Configured and Enabled (Doc ID 2333170.1)

Last updated on JANUARY 03, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.