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 JULY 20, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.