How to Know Who Personalized The Oracle Form

If you want to know who personalized the form then you can check it in personalize form after opening that form you can check it in record history as shown in below screenshots

I have personalized the requisitions form by adding one condition at line level. Then I have identified that in personalization form we can see record history for each and every personalization.

Open requisition form and in that go to help menuàDiagnosticsàcustom codeàpersonalize

In that form we can see what personalization’s are made and after that we can see their record history to identify who made it.

Select the line and then go to help and select record history option as shown above by that we can see who personalized the form.

If you feel its long process to do so we can get the details by using the below SQL statement.

SELECT A.FORM_NAME,

       A.FUNCTION_NAME,

       A.TRIGGER_EVENT,

       A.TRIGGER_OBJECT,

       A.ENABLED,

       B.USER_NAME"CREATED BY",

       C.USER_NAME"UPDATED BY"

FROM FND_FORM_CUSTOM_RULES A, FND_USER B,FND_USER C

WHERE FORM_NAME = '&FORM_NAME' AND B.USER_ID = A.CREATED_BY AND A.LAST_UPDATED_BY = C.USER_ID;

Here form name entered is taken from above screenshot which is rounded with red color.

Now click ok button to execute the SQL.

As seen above we can get the details of who made personalization on the form and who updated the personalization also.