Skip to main content

Hi Experts,

I want to map one field(field01) to another field(field02), requirement is one field is updateable (user can update) same field with same value non updateable, data should copy from field01 to field02 for tracking previous value. please suggest how to do this?

As I understand you need to copy/update a value of a field when update another field.

You can try it from the database end (Update_ method in particular package)
as below
IF (oldrec_.field01 != newrec_.field01)

     newrec_.field02 =newrec_.field01;

END IF;

Pease let me know if I’ve not understood your requirement as you expect. 

Best Regards
-Kelum


Hi Kelum Pradeep Kumara,

Requirement is, In module of Time Management we get daily attendance data from machines(integration), sometimes employee deputed some other location for official work so he will come office after timing and he punch attendance but late, after approval competent authority Time office update his time as actual he was on location. I want to keep both records(suppose office time is 08:00 but due to official work i came late and punch on 09:00 Time office can modify this time as 08:00 but 09:00 also is in my record/field). 


Reply