This project default specifies whether a duplicate requisition line item is allowed without uniqueness. It is used on the Setup > Line Items Configuration Manager page in the Line Items tab.
-
Module(s) affected by this setting: Requisitions > Maintain Requisitions > Requisition Line Items.
-
List of Values: Y and N (default).
-
If set to Y, an additional uniqueness check is done. The additional uniqueness check is as follows (:xxx means screen values):
rli.r_id = :rli.r_id
rli.ident = :rli.ident
rli.qty_unit_id = :rli.qty_unit_id
nvl(rli.ity_id, 0) = nvl(:rli.ity_id, 0)
rli.tag_number = :rli.tag_number
rli.attr_group1 = :rli.attr_group1
rli.attr_group2 = :rli.attr_group2
rli.attr_group3 = :rli.attr_group3
rli.attr_group4 = :rli.attr_group4
rli.attr_group5 = :rli.attr_group5
rli.rli_id != :rli.rli_id
-
If set to N, an additional uniqueness check is not performed after duplicating a requisition line item.
-