Hi,
I have a form. The underlying table was built for automatic loading, therefore some fields need to be computed and not input by the user.
Now I need to make this form for it.
I am not able to use a trigger for the computed fields as the values come from APEX (for example a value depends on :APP_USER value).
I need to preload the field P5_UTILIZATOR_K (which has the source set to "Database column") and I tried a "Before regions" process for it. (The "Automated Row Fetch" process is before my preload process).
The process fills the field but the field shows empty. If I try to fill another field of source type "Static assignment" then the value shows up.
How can I achieve to successfully fill the value of the field with PL/SQL and still have the "Automated Row Fetch" process work with it?
Thanks,
Serban