Production Issue - IN_FUL_CONF failed with duplicate insert
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