Undo Scaling Option Throws Error "ORA 01722: Invalid Number Returned By Program Unit ORDER_SETUP_SQL"
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 10.1.12 and later
Information in this document applies to any platform.
The error message "ORA 01722:invalid number returned by program unit ORDER_SETUP_SQLDELETE_ORDER" is thrown when user tries to undo the scaling process from the ordcalc form.
The error message shouldn't be displayed, and user can normally undo the scaling.
The issue can be reproduced at will with the following steps:
1. Scaling constraints are set up in supplier inventory management constraints information screen.
2. Create an Order. Add item into order.
3. Apply process in order header screen to scale the order.
4. Undo scaling by going 'Apply Process' again. Click on Undo Order scaling check box.
5. Error message pops up.
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