Auto-Adjusting Sequential Number in Multi-Row Attribute Group

Summary:

We are working on adding a new field to an existing multi-row attribute group in Oracle Cloud PDH. This field functions as a sequential record number (e.g., 1, 2, 3, etc.), which needs to update dynamically when new rows are inserted and adjust when deletions occur.
For example, if record number 3 is deleted from a set of four rows, the fourth row should automatically take on number 3, ensuring sequential order remains intact. To maintain accuracy, our team is exploring an integration process to auto-correct these numbers every 15 minutes.
One key constraint is avoiding the use of database sequences to generate the numbers. We are considering utilizing a custom object that stores numbers 1 to 20, allowing an assignment rule to fetch values from this predefined set.