Error When Importing Contracts Using MktImport/ImportPublicService Webservice

(Doc ID 2324710.1)

Last updated on NOVEMBER 10, 2017

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Webservice

How to import contracts using mktImport/ImportPublicService webservice(submitimportactivity) ?

When trying to import contracts using mktImport/ImportPublicService webservice(submitimportactivity) getting the file from UCM server by providing the ContentId in the request payload, the import finishes with error.

The same file if imported directly from application: Manage file import activities gets imported without error.
 

ERROR
-----------------------
Record 1: Rejected - Error on table OKC_IMP_CONTRACT_HEADERS, column START_DATE.
ORA-01821: date format not recognized

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import contracts using the webservice

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