Error "INPGREPL FA200 INSERT ITM" when Running the 'Par Location Replenishment' Process (INPGCDMD) (Doc ID 1119498.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 8.9 to 9 [Release 8.9 to 9]
PeopleSoft Enterprise SCM Purchasing - Version 8.9 to 9 [Release 8.9 to 9]
PeopleSoft Enterprise SCM eProcurement - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

When the 'Cart Replenishment' process (INPGCDMD) (also called 'Par Replenishment' process) (navigation: Inventory, Replenish Par Locations, Create Par Replen Requests) is scheduled to run on a regular basis (say every 15 minutes), the following error is issued sometimes:

INPGREPL FA200 INSERT ITM

The error is a result of a duplicate key error which is issued during an INSERT statement into PS_PO_ITM_STG.

Subsequent runs of the INPGCDMD process run to success.

Cause

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