Monday, 17 August 2020

How to write condition in form Personalization in oracle apps

How to write condition in form Personalization in oracle apps

Hi friends, we are going to discuss about the how to write condition in form Personalization in oracle apps. We will share the detail steps to write the form personalization condition in oracle apps. Condition in form personalization helps to write the more dynamic personalization. In Form personalization , We do write the conditions if we want to enable or disable the form personalization dynamically. Once the condition got true in the form personalization then that personalization got active in the form but if the condition got false then form personalization got inactive and the action written under that form personalization never execute. condition helps to create more dynamic personalization. In this post ,We are sharing the working example to write the condition in form personalization in oracle apps. Please find below the complete details about how to write condition in form personalization in oracle apps.

Example of write condition in form Personalization

We have an business requirement , we want to make the Invoice description field required through form personalization but we want to make the Invoice description field required only for single Organization ID '85'. We don't want to make the Invoice description field as an required field.

Another Requirement , This Invoice description field should only required to Invoice Type ='Standard'. 

For this we will write the below conditions in the Form Personalization. 

Detail Steps to write condition in form Personalization in oracle apps

Here below is the detail explained steps to write condition in form personalization.

Step 1:- Here below is the Form Personalization created below to required the Invoice description required field.

Condition : 
:INV_SUM_FOLDER.INVOICE_TYPE='Standard'
and fnd_profile.value('org_id')=85


Step 2:- 
In the Form Personalization Actions Tab , We need to create/perform the below steps to required the Invoice description required field.


How to write condition in form Personalization in oracle apps
How to write condition in form Personalization in oracle apps

Object Type : Item.
Target Object : INV_SUM_FOLDER.DESCRIPTION.
Property Name : REQUIRED.
Value : TRUE.


How to write condition in form Personalization in oracle apps
How to write condition in form Personalization in oracle apps

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *