Troubleshooting
Problem
Attempts to pass OrderDate with milliseconds in createOrder API removes the milliseconds prior to saving it in database in IBM Sterling Order Management.
Symptom
To reproduce, create an order by passing the order date as OrderDate="2017-07-04T10:10:00.199-08:00".
As a result, milliseconds are removed from OrderDate and saved in the database without milliseconds as 2017-07-04T10:10:00. getOrderDetails API will not retrieve the order date with milliseconds in the API output.
Cause
This is working as designed.
Diagnosing The Problem
Database supports milliseconds, but Sterling Order Management logic does not seem to honor millisecond in API inputs or outputs.
Resolving The Problem
The product does not currently support storing dates with fractional seconds.
Was this topic helpful?
Document Information
Modified date:
11 February 2020
UID
ibm10718717