My Portfolio

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 : Form Personalization is a feature in Oracle Apps that allows us to change the behavior of form based screens. 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       ...

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 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 ...