How To Resolve the Error "ORA-12899: value too large for column "SYSADM"."PS_ISSUE_HDR_INV"."ORDER_NO" (actual: 30, maximum: 10)" when Running the 'Cart Replenishment' Process (INPGCDMD)
Last updated on AUGUST 04, 2016
Applies to:PeopleSoft Enterprise SCM Inventory - Version 8.9 and later
Information in this document applies to any platform.
The 'Cart Replenishment' process (INPGCDMD) (also called 'Par Replenishment' process) (navigation: Inventory, Replenish Par Locations, Create Par Replen Requests) is failing with the following error:
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 12899
Error Message : ORA-12899: value too large for column "SYSADM"."PS_ISSUE_HDR_INV"."ORDER_NO" (actual: 30, maximum: 10)
Stored Stmt : INPGPROC_U_ISSHDR
SQL Statement : INSERT INTO PS_ISSUE_HDR_INV (BUSINESS_UNIT, ORDER_NO, DEMAND_SOURCE, SOURCE_BUS_UNIT, REQUEST_TYPE, INTERNAL_FLG, FULFILL_FLAG) VALUES (:1, :2, 'IN', :3, 'I', 'Y', 'N')
SEVERE ERROR IN PGM:(11380,3) PI(21260964) Program(INPGPROC)
PTPSQLRT error in Inventory Par Location Replenishment background processing: INPGPROC MC000 - HDR INSERT.
How to resolve it?
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