Dear All,
I am new to Oracle APEX and recently we have started to use in built Oracle APEX incident tracker application. While create any new record for LOV, I observe that the new record is generated using a random primary key. In the application, the existing records are using primary key as 1, 2, 3, and 4. After adding the new record, the new generated ID is 232129609488858405336478237955567032594. I am not sure how this is generated. I want to have new primary key as a increment value by 1. I could not find the WWV_FLOW_DML package/function to see how this operation is carried out. Is there any way to control the value of primary key column?
The fields to capture values are created as Static Content with text boxes in Content Body region and the process is using Automatic Row Processing (DML) [Legacy]. Primary key field has been used in the Content region but it is hidden.
Thanks,
Suhel