My Oracle Support Banner

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 SIA [20423] and later
Information in this document applies to any platform.


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:

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




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.