Press a button in Forms Personalisation

Mimic/automate the press of a push button in the PO Summary form

Create a when-new-form-instance personalization and create following actions

1)

Type: Builtin

Builtin Type: DO_KEY

Argument: ENTER_QUERY

Create a WHEN NEW ITEM INSTANCE personalisation and create the following actions

1)

Type: Builtin

Builtin Type: GO_ITEM

Argument: PO_HEADERS.SEGMENT1

2)

Type: Property

Object Type: Item

Target Object: PO_HEADERS.SEGMENT1

Property Name: VALUE

Value :==:'PO_HEADER_ID'

3)

Type: Builtin

Builtin Type: DO_KEY

Argument: EXECUTE_QUERY

Here in the below mentioned step

Type: Property

Object Type: Item

Target Object: PO_HEADERS.SEGMENT1

Property Name: VALUE

Value =:253253

If I hard code the value 253253(which is the header_id for PO_NUMBER 10031791) in the field 'value' then the PO_NUMBER form works as expected(PO Form opens up in queried mode and all the data of the PO_NUMBER is pre-populated)

Refer: https://community.oracle.com/thread/2518602?start=0&tstart=0

Form Personalization with Examples

Form Personalization with Examples

Form Personalization:

1. Form Personalization is a feature in Oracle Apps that allows us to change the behavior of form based screens.
2. It can be moved easily through FNDLOAD from one instance to another, It can be restricted at   Site/User/Responsibility Level.

What can be done through Form Personalization?

1.        Zoom from One form to another.

2.        Pass data from one form to another through global variables.

3.        Enable/Disable/Hide fields dynamically.

4.        Launch URL directly from oracle form.

5.        Call PL/SQL procedure.

Components of Form Personalization:

 

 

How To make a Field Mandatory in the Form:

 

Go for Any Perticular Form If you want to personalize, Open that form

 

 

 

Go as specified Navigation in Help ->Diagnostics-> Custom Code -> Personalize

 

 

 

Once Open That let we create 10.1 Seq For Make Field Mandatory (Make sure that This should be Enabled). 

 

Condition->Trigger Event we are selection as WHEN-NEW-FORM-INSTANCE.

 

 

 

Object_type:Item(Column)

Target_Object :MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT_MIP(Which field you want to make it mandatory select that column as target Object).

Property_Name:Required

 

 

 

 

 How to perform calculations in the field:

 

 

 

 

Calculations will be done through per each Record so we selected as WHEN-NEW-RECORD-INSTANCE

 

Let we calculate this in attirbute_13 in PO_LINES

 

 

 

Meaning of Special fields in Form Personalization:

•      Menu(1-15) will be in tools

•       Populate tools menu (SPECIAL 1-15)

•       Populate reports menu (SPECIAL 16-30)

•       Populate actions menu (SPECIAL 31-45)

•       It is recommended to use Menu before Tools

Various components used In Form Personalization:

Trigger Event  - These are predefined event. Based on the value chosen the function will execute only when that particular event triggers on the form.

Processing Mode - Query mode or Not in Query mode or   Both

Context   - At what level like user or Responsibility level

Menu      -    this is used to call one form from another. it is used to implement the zoom functionality. There are 45 menu entries which are used to call                      one form from current form.

Built In    -   It allows you to call Oracle standard built-in and Functions

 

Launch a URL

 

 

How to hide a field

 

 

 

 

 

Oracle Forms Personalization TOOLTIP_FOREGROUND_COLOR Property.

Oracle Forms Personalization TOOLTIP_FOREGROUND_COLOR Property.

We will try to change the foreground color of the below tooltips from white to Green.

– Open the Forms Personalization window by clicking on the Help -> Diagnostics -> Custom Code -> Personalize menu option.
o Seq – 10
o Description – 
o Level – Function
o Enabled – Yes

– Condition:
o Trigger Event – WHEN-NEW-ITEM-INSTANCE
o Trigger Object – B_RESOURCES.ITEM_FLEX_VALUES
o Processing Mode – Not in Enter-Query Mode

– Actions:
o Seq – 10
o Type – Property
o Description – 
o Language – All
o Enabled – Yes
o Object Type – Item
o Target Object- B_RESOURCES.ITEM_FLEX_VALUES
o Property Name: TOOLTIP_FOREGROUND_COLOR
o Value – r0g255b0

Save the record.

The tooltips now appears in Green.

Changing the color of an Item in Forms using Forms Personalization

Changing the color of an Item in Forms using Forms Personalization

On request here are the steps to change the Font colors of an item using Forms Personalization.
I am using Item Screen for an example and displaying Item number in Red Color.
This is how form looks before customization. Note that Item number is displayed in its default color.

Now lets change the color. Select Help->Diagnostics->Custom Code->Personalize to open the forms personalization screen.
At this point of time there is no condition specified and the Item number is displayed in red in all the cases. So the trigger is written in WHEN-NEW_FORMS-INSTANCE

Click on Actions tab and enter as shown in the screen shot

Save your changes and re-open and query for an item


Note the change in the font color of Item Number.

The Foreground color used in above example is r255g0b0, which can be explained as follows

Any Color is made using combination of Red(r), Green(g) and Blue(b) color with a value ranging from 0 to 255. To create a red color give the value of r to maximum 255 and leave g and b to zero.
Similarly green color can be defined as r0g255b0