Assignment Manager Gives Error "ORA-01400: cannot insert NULL into ("SIEBEL"."S_ORD_CRDT_ASGN"."START_DT")" When Trying To Assign Orders
(Doc ID 805265.1)
Last updated on FEBRUARY 04, 2024
Applies to:
Siebel Assignment Manager - Version 8.0.0.6 SIA [20423] and laterInformation in this document applies to any platform.
Symptoms
On invoking Assignment Manager using the existing out of the box "Order (Sales Credit Assignment)" Assignment object, the following error is observed in the Assignment log :
SBL-GEN-03006 Error when calling the function: DICInsRowExecStmt for Assignment.
Additional Message: pfNativeError: -99999; szSQLState: 22007; szErrorMsg: [XXX][CLI Driver] CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007
SQLError Statement 0 0000000349d24d38:0 2009-03-31 13:10:55 SQL Statement:
INSERT INTO SIEBEL.S_ORD_CRDT_ASGN ...
GenericLog GenericError 0 0000000349d24d38:0 2009-03-31 13:10:55 Message: Error: An ODBC error occurred,
Additional Message: pfNativeError: 1400; szSQLState: 23000; szErrorMsg: [1076673536][ODBC Oracle driver][Oracle]ORA-01400: cannot insert NULL into ("SIEBEL"."S_ORD_CRDT_ASGN"."START_DT")
This can be reproduced using the steps below:
1. In Administration - Assignment, create an assignment rule using the existing Assignment Object, "Order (Sales Credit Assignment)".
2. Define any Criteria as needed
3. Go to Position Candidates, define a position to be assigned.
4. Release Assignment rules
5. Run it
Changes
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 |
Changes |
Cause |
Solution |