Unable To Activate Contract Expert Rules Using System-defined Variables (Doc ID 2221508.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Contract Expert

When attempting to activate contract expert rules using system-defined variables that use any system-defined variables. They repeatedly go back into Draft status after trying to activate.
The following error occurs in the concurrent program:

Error

Other Error in build_statement_rule ORA-06502: PL/SQL: numeric or value error
  
Unexpected Error in build_and_insert_rule User-Defined Exception
  
After Populating cz_imp_rules
x_return_status: U
Rule Import Run Id : 675130
  
x_return_status: U
errbuf : ORA-06502: PL/SQL: numeric or value error in Package OKC_XPRT_IMPORT_RULES_PVT Procedure build_statement_rule

Steps:

The issue can be reproduced at will with the following steps:
Contract Expert --> Rules --> Select the Rule and Activate

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