I have entry from users they enter the values of

I’ve a problem using timestamp type in oracle facet query.
I created this table

in my Oracle APEX application i have a report and a form (that updates/creates for that table), i created a dynamic action that refreshes the report after the dialog box is closed (something not new to me and i do it quite frequently).

I am learning Oracle Architecture for APEX setup. I posted similar post but I believe I did not explain myself well for that and I am trying to post it with different explanation.