Oracle EBS Practical Approaches

Run Concurrent Program from Form: Launch SRS Built In

Form Personalization to run Concurrent Program from Form 

Built-in : Launch SRS Program.

Example :

Our Requirement is to Run Production Batch Sample Label from Production Batch Form.

We could completed this requirement through Form Personalization in below steps.

A)-Define 1 Menu : Special Menu for the Report, that shall show in tools Menu bar.

B)-Attach Concurrent Program menu with this Special Menu (defined in the above step).

C)- Store batch id ( For parameter to run your concurrent) in one Global variable.

D)- In Concurrent Definition window , Assign Global variable value to the Parameter for Batch id.

Here are the screen shots.

Requirement is like Below.

Goto Help --> Diagnostics --> Custom Code --> Personalize.

Add 1 New Sequence for You personalization, and Select Event as When-New-Form-Instance.

Goto Actions, and Choose any 1 special Menu.

Once menu is define, we need to attach Concurrent program to this menu.

Create new Sequence, for attaching The concurrent program with special menu defined in above step.

Goto Actions, here we need to define 2 Actions

1)- Global Variable to store Batch ID for Parameter.

2)- Attach Concurrent program to the Special Menu.

Global Variable name should be Logical and unique, as this needs to be pass to your concurrent program.

Save your work, Till here personalization is done for Concurrent program is attached and run, now Concurrent program will be run , but we have to assign Parameters manually, it will not pick any parameter automatically.

Step-3, To pass parameters from Batch form automatically.

GO TOà System adminà applicationà Concurrentà define

Now we have to attach Global variable from above steps to Concurrent Program.

Go to Parameters, and then pass global variable from the earlier form i.e, Batch Form.

Select Batch id parameter.

Its Default Type Should be SQL Statement.

Then Pass the 

“select :GLOBAL.XX_BATCH_ID from dual”

Now try to run report from Batch form,

It will automatically pass your current (Batch opened at form) to the report.

Friday, July 24, 2015

ZOOM Functionality and Global variable in Form Personalization

1)- Global Variable in forms Personalization.

  A)- These variables are accessible through out the application until the current active session becomes inactive.

B)- Data type for Global variables are always CHAR, hence if global variable needs to initialize or assign for any numeric value , use TO_CHAR

C)- Oracle 10g Can store as max as 4000 Bytes in Global variable, as compared wit just 255 bytes in 6i.


Syntax to Access of global variable.

  :GLOBAL.VARIABLE_NAME


2)- ZOOM Functionality.

   This functionality gives feature to pass the control from one form to Another.

So For any event we can set zoom functionality , for example on button click , control passes from the current form to another form, that is defined in personlization.



ZOOM Functionality is same as BUILT-IN Launch SRS Form with just one difference is that
In Launch SRS Form built-in we have to pass parameters manually, but in zoom functionality parameters can be passed automatically form the values available on current form.