Supply Chain Management - PSFT (MOSC)

MOSC Banner

Production Issue - IN_FUL_CONF failed with duplicate insert

edited May 16, 2015 12:03AM in Supply Chain Management - PSFT (MOSC) 1 commentAnswered
Production issue - we are on PeopleSoft 9.0, PeopleTools 8.50.24

Material Stock Request entered for quantity that was stored in Owned and Non Owned Locations
Order reserved, pick plan created, material picking feedback performed.

IN_FUL_CONF job failed with a duplicate insert into 'PS_IN_DP_DMD_TAO6'

PS_DEMAND_PHYS_INV is being joined with PS_IN_DP_SHP_TAO6 then trying to insert into PS_IN_DP_DMD_TAO6
PS_DEMAND_PHYS_INV contains a Seq no that makes the owned and non owned locations unique in that table.

The keys on PS_IN_DP_DMD_TAO do not include the seq number - thus the duplicate insert

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center