we have a custom object defined in maximo with audit enabled on it and we use it in workorder application on a new custom tab.
one workorder can have more than one row of this new object something like related records.
Lets say custom object as NEWOBJ and audit enabled as A_NEWOBJ.
in Applictaion designer, changeby and changedate of NEWOBJ is mapped to eauditusername and eaudittimestamp of A_NEWOBJ.
and in dbconfig a relationship is defined from NEWOBJ to A_NEWOBJ as
newobjid=:newobjid and rowstamp=(select max(to_number(rowstamp)) from a_newobj where newobjid=:newobjid)
But the eauditusername and timestamp of one newobj row is getting stamped to another newobj record which is giving a wrong impression that the person who did not make any changes on that newobj record is getting stamped as eauditusername on audit table .
can anyone help me identify the issue or the approach ?
Join CommunityInvite ColleaguesLearn More