You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!