My Oracle Support Banner

Getting an 'ORA-06502: PL/SQL: Numeric Or Value Error' Using the OKS_IMPORT_HEADER_PUB.CREATE_CONTRACT_HEADER API (Doc ID 2564746.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Symptoms

When attempting to create a Service Contract using the API, the following error is thrown.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error in Package OKS_IMPORT_HEADER_PUB Procedure CREATE_CONTRACT_HEADER

Note: In the FND Debug Messages, the error appeared shortly after this message "Calling the procedure insert_oks_grpings to assign the contract to the groups".

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


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