My Oracle Support Banner

"Import Clauses" Program failed with Error :"OKC_ART_INVALID_VARIABLE_CODE (ARTICLE_TITLE=Clause_XXXXXX)" (Doc ID 2618130.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Service Contracts - Version 12.2.8 and later
Information in this document applies to any platform.


On : 12.2.8 version, Search Related

When attempting to create Contract Clauses without Variable code using ‘Import Clauses’ Program.
the following error occurs.

fnd.plsql.fnd_file.PUT_LINE sid:769270352: OKC_ART_INVALID_VARIABLE_CODE (ARTICLE_TITLE=Clause_XXXXXX)
fnd.plsql.fnd_file.PUT_LINE sid:769270352:
fnd.plsql.fnd_file.PUT_LINE "sid:769270352: Program Error: An unexpected error was encountered.
OKC " : 500: Leaving Articles_Import because of EXCEPTION: ORA-06502: PL/SQL: numeric or value error: NULL index table key value

The issue can be reproduced at will with the following steps:
1. Contract terms Lib Admin responsibility
2 .Run ‘Import Clauses’ Program.


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

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