Sourcing Assignments Form - Error APP-MRP--22172 - Assignment Already Exists - But SQL Shows It Does Not Exist (Doc ID 2241731.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Goal

Unable to enter new sourcing assignment because the user is getting a message saying "This assignment combination (assignment type, organization, item/category, source type) already exists. Please select another.

Trying to add Item Level Assignment

SQL to check for this item in the Assignment Set shows no rows exist

 

Customer version of the form is MRPFDSRA.fmb -- 120.5.12010000.2
 

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