Adding Records In Table SC_RULE_CONTRACT Via CSV Doesn't Auto Generate SC_RULE_CONTRACT_SEQ_NO With Error ORA-01400: cannot insert NULL into ("GLOGOWNER"."SC_RULE_CONTRACT"."SC_RULE_CONTRACT_SEQ_NO") (Doc ID 2093877.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle Transportation Management - Version 6.3.6 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When uploading the CSV table SC_RULE_CONTRACT with transaction code "Insert" to the OTM database via the Integration Manager, an error is generated " error cannot insert NULL into ("GLOGOWNER"."SC_RULE_CONTRACT"."SC_RULE_CONTRACT_SEQ_NO")". The CSV SC_RULE_CONTRACT_SEQ_NO column values are left blank.

EXPECTED BEHAVIOR
-----------------------
It is expected that the sequence number will auto-generate when inserting new rows into a table that requires a sequence number. OTM should automatically generate the next value of the sequence.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to Business Process Automation -> Integration -> Integration Manager-> Upload an XML/CSV Transmission

2. Select the CSV file to upload to the database. The CSV file should contain table data for the SC_RULE_CONTRACT table and no values under the SC_RULE_CONTRACT_SEQ_NO column.

3. The error ORA-01400: cannot insert NULL into ("GLOGOWNER"."SC_RULE_CONTRACT"."SC_RULE_CONTRACT_SEQ_NO") is thrown.

ERROR
-----------------------

 

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