Allow Duplicate Positions (AllowDupPostn) Parameter

You can assign duplicate positions by setting the Allow Duplicate Positions parameter when you run an assignment request. By default, the Allow Duplicate Positions parameter is set to FALSE. When you set this parameter to TRUE, Assignment Manager attempts to insert duplicate positions, that is, positions with the same ID in the team table, given those positions do not violate the user key constraints of the table.

You must also set the PositionTeamDenorm user property for the assignment object. The PositionTeamDenorm assignment object user property specifies which destination columns are part of the user key. Assignment Manager checks whether positions with the same ID that pass violate the uniqueness of these key columns. If Assignment Manager detects a violation, only the first position encountered is inserted into the team table, and the other position is ignored. Otherwise, Assignment Manager inserts both positions into the team table.

For example, if there is a violation of the user key when adding positions to the account team, then only the first duplicate position encountered is inserted into the S_ACCNT_POSTN table. For an example of using the PositionTeamDenorm assignment object user property, see Example of Copying Additional Columns to the Team Table.