Calling Oracle Report from Form in Oracle Apps(using Personalization)

Here we will see how to call a report (Concurrent Program) from a form using personalization.

Requirement: Call a report from the form using personalization.

Steps:

• ·         Open your form and then navigate to Help -> Diagnostics -> Custom Code -> Personalize.

• ·         In the Form Personalization window, first we will create a menu item. Enter the information as mentioned below:

Ø  Seq:                               15

Ø  Description:                Print Acknowledgement Print 1

Ø  Level:                            Function

Ø  Trigger Event:            WHEN-NEW-FORM-INSTANCE

• ·         Then go to Actions Tab and enter the following information:

Ø  Seq:                               1

Ø  Type:                             Menu

Ø  Menu Entry:               SPECIAL45

Ø  Menu Label:               Print Receipt Acknowledgement             

• ·         Enter one more entry to call the Report.  Enter the information as mentioned below:

Ø  Seq:                               20

Ø  Description:                Print Acknowledgement Print 2

Ø  Level:                            Function

Ø  Trigger Event:            SPECIAL45

• ·         Click on Actions tab and enter the following:

Ø  Seq :                              5

Ø  Type:                             Builtin

Ø  Built Type:                   Execute a Procedure

Ø  Argument:                  ='

BEGIN

XXFIL_BILL_ACK_PRINT_P('''||1||''','''||

    ${item.XXFIL_MEASUREMENT_BOOK_HDR_V.MB_HEADER_ID.value}           ||''');

                                                end'

Note: In the argument field copy the code as it is. Points to keep in mind

1.       Start the code with ‘=’ sign

2.       Single quote before Begin and after end.

3.       3 single quotes and || symbol to differentiate the parameters.

• ·         Yes now we are done with it, go and check it.