BICS Data Sync 2.2: Unable to create and save an Execution Parameter for Jobs (Doc ID 2186079.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Symptoms

On : N/A version, Visual Analyzer

BICS Data Sync 2.2 parameter issue

Unable to set up an incremental load using the last updated time in a column.

While adding an Execution Parameter (Jobs->Jobs->Execution Parameter->New)
fill in Name, Data Type, Load Type but when next click the Value box following error is thrown.
ERROR
-----------------------
Column 'ETL_DEFN_WID' cannot accept NULL value error





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Jobs->Jobs->Execution Parameter->New
2. fill in Name, Data Type, Load Type
3. click the Value box

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are unable to create and save an Execution Parameter for Jobs.

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