Security on Custom Forms based on User/Responsibility

Hello All,

EBS R12.1.3

Forms 10g

Database 11g

We created Custom Forms from the Custom Tables and registered successfully in the EBS.

There is a field Location in the Table and Forms, based on this field, all the Customs forms need be secured for each user/Responsibility.

Responsibility_1 can view/enter only Location_1 data

Responsibility_2 can view/enter only Location_2 data

Responsibility_3 can view/enter all Locations

Below are the Custom forms.

1. Defining Event (Lov of Location exists) --> Custom Table
2. Defining Contracts (selecting lov of Location ) --> Custom Table
3. Payments --> based on the Oracle DB custom View , the user can search Contract or based on Events or even not selecting any, it will show all the contracts pending for payment.