Query to find Form Personalization-oracle Apps R12

2 comments

Query to find Form Personalization details by passing form name:


SELECT ffv.form_id          "Form ID",
       ffv.form_name        "Form Name",
       ffv.user_form_name   "User Form Name",
       ffv.description      "Form Description",
       ffcr.sequence        "Sequence",
       ffcr.description     "Personalization Rule Name"
  FROM fnd_form_vl             ffv,
       fnd_form_custom_rules   ffcr
 WHERE ffv.form_name = ffcr.form_name
 AND   ffv.form_name = :P_Form_Name
 ORDER BY ffv.form_name, ffcr.sequence;

Form Personalization Query

If You Enjoyed This, Take 5 Seconds To Share It

2 comments:

  1. AnonymousDecember 6, 2016 at 1:54 PM

    Thanks.Very Helpful query.

    ReplyDelete
  2. SunTec Business SolutionsJuly 6, 2021 at 2:27 PM

    hyper personalization in retail
    Banks have a dual challenge today – a demanding customer and a whole new set of competitors. User experiences in e-commerce and other industries with digital offerings are so seamlessly designed that today’s customer sees that as the norm.

    ReplyDelete