ORA-01722 Error When Opening Contract after UDA Was Configured and Enabled

(Doc ID 2333170.1)

Last updated on DECEMBER 01, 2017

Applies to:

Oracle Procurement Contracts - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Contract Terms Authoring

When attempting to add and use UDAs, 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 is behaves as normal.

Changes

 

Cause

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