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) (Doc ID 1965631.1)

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.

Goal

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:

Application Program Failed
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?

Solution

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