October 12, 2008

Sysadmin Zoom functionality using Oracle Forms Personalization

Oracle introduced Forms Personalizations Feature, which was first introduced with FND Patch Set Level H (FND.H). Since then, lots of customizations got moved from CUSTOM.pll.

One of simply achievable functionality is Zoom functionality. Often my developers / APPS sysadmins wants to Navigate in the following flow.

1. Define Users Window -> Responsibilities Details Window -> Request Group Details Window -> Concurrent Program Details Window -> Executable Details Window
[OR]
2. Define Users Window -> Responsibilities Details Window -> Menu Details Window -> Sub Menu Details Windows -> Function Details Window

Download the below ldt file and Upload the personalizations into your test instance using below command.
Datafile (.ldt)

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct sysadmincus.ldt

Now Login into Applications -> Define Users Window -> Query for a User -> Place the cursor on a responsibility -> Tools Menu -> Responsibility Details

It will take you to the Responsibilities Details Window.

When you are in the Responsibilities Window, you can find below menu items

  • Tools -> Menu Details
  • Tools -> Requeset Group Details
When you are in Request Group Details window, you can find below menu items
  • Tools -> Program Details
  • Tools -> Requeset Set Details
When you are in Concurrent Program Details window, you can find below menu items
  • Tools -> Executable Details
When you are in Concurrent Program Details window, you can find below menu items
  • Tools -> Executable Details
When you are in Menu Details window, you can find below menu items
  • Tools -> Submenu Details
  • Tools -> Function Details