My Oracle Support Banner

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

Last updated on MARCH 22, 2019

Applies to:

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


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.

Column 'ETL_DEFN_WID' cannot accept NULL value error

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


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.