Error ORA-00001: unique constraint (WKSP_MYSCHEMA.SYS_C00165018598) violated is occured when I’m trying to insert some data to my table named workers.

While trying to build a prompt context in Oracle APEX, I can’t tell what’s wrong with my code below:

I have an external Oracle database. I’m trying to export table into Oracle APEX database. The problem is that the timestamp format from external database is like this 21/01/17 23:34:50,000000000 (note , just after 50), while Oracle APEX allows only ’23:34:50.000000000′ otherwise it throws error:

I am using oracle apex version 23.2.3. I have a dashboard in Oracle apex that contains multiple reports. One of which is quite large and uses several page items that contain subqueries. When I run the page through the debugger, I can see that one action written session state for item P200_LD_LAST_MONTH takes over half of the total execution time (total execution time ~ 25 seconds for larger pools of data).