SQL Error '[Microsoft][SQL Server Native Client 11.0]Numeric value out of range (SQLSTATE 22003)' on Item/Product Availability Page
(Doc ID 2284765.1)
Last updated on NOVEMBER 29, 2019
Applies to:PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Users are getting a fatal SQL error
'[Microsoft][SQL Server Native Client 11.0]Numeric value out of range (SQLSTATE 22003)'
when attempting to search for a certain item on the Item/Product Availability Page.
The issue appears to be the field ATP_D_WO_VW.SCHED_NBR has only 3 digits long maximum, but it is pulling that field from IN_DEMAND. SCHED_LINE_NBR that has 6 digits long maximum.
As a result, when SCHED_NBR > 999, the following error shows up in the logs:
Return: 8601 - [Microsoft][SQL Server Native Client 11.0]Numeric value out of range (SQLSTATE 22003) 0
The issue can be reproduced at will with the following steps:
1) Navigate to Inventory > Manage Inventory > Review Inventory Balance Info >
2) Enter the SetID, Item ID and Business Unit of any item on ATP_D_WO_VW
having a SCHED_NBR > 999.
SetID = SHARE
Product ID = for example PRODUCT
Item ID = for example PRODUCT
Business Unit = US010 (Cycling Accessories - Inventory)
In rest all option are left default
3) As result no error appears
Then remove the flags and save both
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