I have a simple table with a LST_UPD_DTE_TIME column. In Apex, it is called P3_LST_UPD_DTE_TIME. On my update button, I have created a Dynamic trigger action that triggers when the UM_ID column is not null. When True, it executes this PL/SQL:
:P3_LST_UPD_DTE_TIME:=sysdate;
I get this error:
Error: ERR-1002 Unable to find item ID for item "LST_UPD_DTE_TIME" in application "125".
Please advise, why isn't this working? It seems simple enough. Is there a better place to write PL/SQL to update a database column upon Submission?