Purge Stock Orders Fails When ORDER_LINE_NUMBER Higher Than 999
Last updated on APRIL 17, 2017
Applies to:Oracle Retail Warehouse Management System - Version 10.4 to 10.4.6 [Release 10 to 10.4]
Oracle Retail Warehouse Management System - Version 12.0 to 12.0.10 [Release 12.0]
Oracle Retail Warehouse Management System - Version 13.2 to 13.2.5 [Release 13.2]
Oracle Retail Warehouse Management System - Version 14.0 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.
When an order is purged that has more than 999 lines on it, a message is being written to the error log table indicating there a value is larger than the specified precision allows for this column. This happens while updating the ERROR_MESSAGE_TO_UPLOAD table.
Steps To Reproduce
- Create an order that has more than 999 lines on it.
- Purge the stock order such that there would be a message written to the error_message_to_upload table.
- Check the error_log table for error: “ORA-01438: value larger than specified precision allows for this column”.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms