Unable To Create Contract Using Oks_import_header_pub.Create_Contract_Header (Doc ID 1989408.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

On 12.2.4 find that it is not possible to create contract using   oks_import_header_pub.Create_Contract_Header
  

Error:
  The following Error message displays in the SQL application:
  The error message is
  l_return_status U
  U
  1
  FND
  ORA-06503: PL/SQL: Function returned without value in Package
  OKS_IMPORT_HEADER_PUB Procedure CREATE_CONTRACT_HEADER
  

Steps to Reproduce:

Use oks_import_header_pub.Create_Contract_Header  API as prescribed in pdf: Oracle Service Contracts, Public Application Programming Interfaces (APIs)  see <Note 1941609.1>


  Workaround:
  A. Service contracts Headers can be created from OKSAUDET form with the   same parameters.
  B. We found that Sales credit type IDs of single digits do not have the   issue.

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