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:
Oracle Transportation Management - Version 6.3.6 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |