1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How know who make an Personalize Page

Discussion in 'Oracle Apps Technical' started by tomloera, Jun 19, 2012.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi friends;

    Can help me?

    How could I know who made a personalization of the page in version R12
    There is some way in the application or via a sql script?

    Best Regards
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Tomloera,

    I have tried using Requisitions form as of your requirement, 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. But this is not convenient way to know. So I have developed SQL to identify the person who personalized the form. Here is the SQL:

    Code (Text):
    SELECT A.FORM_NAME,
           A.FUNCTION_NAME,
           A.TRIGGER_EVENT,
           A.TRIGGER_OBJECT,
           A.ENABLED,
           B.USER_NAME
    FROM FND_FORM_CUSTOM_RULES A, FND_USER B
    WHERE FORM_NAME = '&FORM_NAME' AND B.USER_ID=A.CREATED_BY;

    This is the form name for requisitions form :  POXRQERQ  (This is identified in personalization form). So pass this form name when it asks while running the above SQL.

     
    I will provide you the output screenshot tomorrow. Hope this query matches your requirement. Please get back here after checking the above SQL.
     
  3. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hello Bharat;

    Thanks by your information is very good

    Question, you know if in this table have the html personalizations? or only the forms personalization?

    Because, I want indetify who make a personalization in the Customer Search and this here in the html forms

    Thanks a lot by your help friend
    Regards
    Tom
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    tomloera likes this.
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi tom,

    Have you got the solution.
     
    tomloera likes this.
  6. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi Bharat;

    Thanks a lot by your information is good and i can fix my problem

    Best Regards
    Tom
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi tom,

    Have you got the solution for jsp pages. I have provided only for form level customization creation person. But you asked about personalized person name on jsp page. Please provide solution for that if you got it.