Call Oracle form through OAF personalization (Button) with form parameter

Step1- Set OAF personalization profile.

Profile Name	Value
FND: Personalization Region Link Enabled	Yes
Personalize Self-Service Defn	Yes
Disable Self-Service Personal	No

Step2- Create New Item(Button) on OAF page

Step3- Enter mandatory fields

Step4- Destination URI field value-

form:<responsibilityApplicationShortName>:<responsibilityKey>:<securityGroupKey>:<FORM_NAME>:param1={#<PARAMETER1>}

Ex– form:FND:FNDWF_USER_WEB:STANDARD:ATCPOINDDUPPRDTLS:param1={#RequisitionHeaderId}

Step5- Save it

Go to Notification page and click on “Project PR Details” button, It will open oracle form and display values based on parameter.

Trigger firing sequence in D2K (Oracle Forms)

Posted by Amar Alam at 06:48 Labels: D2k15 commentsTrigger Firing sequence:This is most important thing to understand in Oracle D2K Forms When you open a form following triggers are executed

First Logon Triggers are fired:1.PRE-LOGON
2.ON-LOGON
3.POST-LOGON

After that Pre Triggers:4. PRE-FORM
5. PRE-BLOCK
6. PRE-TEXT

After that WHEN-NEW Triggers:
7. WHEN-NEW-FORM-INSTANCE
8. WHEN-NEW-BLOCK-INSTANCE
9. WHEN-NEW-ITEM-INSTANCE

After that ITEM Level Triggers:After this focus is on the first item of the Block. If you type some data and press the tab key following trigger will fire in sequence
10.KEY-NEXT-ITEM (This trigger is present on the item level).
11.POST-CHANGE (This trigger is present on the item level).
12.WHEN-VALIDATE-ITEM (This trigger is present on the item level).
13.POST-TEXT-ITEM (This trigger is present on the item level).
14.WHEN-NEW-ITEM-INSTANCE (Block Level Trigger).

Now focus will go the next item present on the form.
If there are no further items present on the screen them if we enter data and press tab key then only KEY-NEXT-ITEM is fired. Now suppose we close the form then the item level triggers are fired.

POST TRIGGERS :

15.POST-BLOCK
16.POST-FORM