Using Auto_Sequence Function in Item Rule
Hi All,
We have a use case to generate "Row number" starting with 10 and increment by 10 for multi row EFF for an each item. So we have put the below assignment rule to fulfill the same:
Target Attribute: Row#
Primary IF: True
THEN Expression: True
Return Value: auto_sequence("SeqNum", 10, 10)
The above logic is working fine for first item but when we are testing it for next item then the sequence is giving next value from previous row but not starting from 10 for new item as per below Oracle link.
Is there any similar use case at your end and how you overcome it this situation. please advise.
Tagged:
0