E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Customizing / Personalization of Record History (Who columns) in Forms

Ram KanalaJul 23 2019 — edited Feb 9 2021

Hi,

We have requirement to customize / personalize the WHO Column, specifically LAST_UPDATED_BY. As of now LAST_UPDATED_BY displaying the user name.

Instead customer would like to see user description against LAST UPDATED BY.

For eg:

select USER_NAME, DESCRIPTION from fnd_user

where 1=1

and user_name = 'AA313'

USER_NAME DESCRIPTION

AA313 Matthew Zeson

As of now:

Created By: AA313

Creation Date: 01-APR-2019 19:43:38

Table Name: OE_ORDER_HEADERS_V

Updated By: AA313

Update Date: 15-MAY-2019 19:57:54

System Logon: UNKNOWN

Terminal: Concurrent

Expected:

Created By: AA313

Creation Date: 01-APR-2019 19:43:38

Table Name: OE_ORDER_HEADERS_V

Updated By: Matthew Zeson

Update Date: 15-MAY-2019 19:57:54

System Logon: UNKNOWN

Terminal: Concurrent

Appreciate your inputs. Thank you!

Regards,

Ram

Added on Jul 23 2019

#general-ebs-discussion

6 comments

293 views