This project default specifies whether a duplicate RLI is allowed without uniqueness.
This project default is used on R.30.01 on the Line Items tab.
If this project default is set to N (default), an additional uniqueness check is not performed after duplicating a requisition line item. If the project default is set to Y, an additional 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
-
Module(s) affected by this setting: R3001
-
Default value: N
-
List of Values: N/Y