Insufficient Quantity Tool Runs To No Success With Duplicate Key Error

(Doc ID 2156723.1)

Last updated on JUNE 30, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other

Insufficient Quantity Tool runs to no success with duplicate key error

Navigation: Cost Accounting > Inventory and Mfg Accounting > Analyze Inventory Accounting > Insufficient Quantity Tool


ERROR
-----------------------

File: e:\pt85319b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_CM_DR1_LN_TMP13' with unique index 'PS_CM_DR1_LN_TMP13'. The duplicate key value is (2566200, CAT27, 000000000000004575, FIN, Mar 25 2015 11:47AM, 189




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Insufficient quantity tool



Changes

SQL
CM_ACCTG_LIBSetup DrTmp S ApplEng
CM_NEG_INV Setup ClearTmpS ApplEng

Appl Engine (Section)
CM_NEG_INV Setup

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