I am facing the following error in Oracle APEX:
ORA-20103: Member sequence 3 does not exist in Application collection MO_COLLECTION
Could you please help me understand the exact reason why this error occurs?
In my case, it seems that when the user modifies a line (for example changing quantity) but does not save the changes and directly clicks the Adjust and Transact button, the collection sequence is not updated and the process fails.
I would like to know:
- What is the exact cause of this error in Oracle APEX collections?
- Under what scenarios does the member sequence not exist error occur?
- What is the best way to handle or prevent this issue in the application (for example forcing save before processing, refreshing the collection, or handling it in PL/SQL)?
Any suggestions on the correct approach to overcome this issue would be very helpful.