| Customized forms Upgrading to Multi-org [message #240270] |
Thu, 24 May 2007 08:59  |
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
|
Senior Member |
|
|
Currently, upgrading to Multiple Organizations and we have some customized forms that will probably need code changes to incorporate the multiple organization (multi-org) process. Does anyone have experience with this or any recommendations on how to handle this.
Thanks
Anne
|
|
|
|
|
|
| Re: Customized forms Upgrading to Multi-org [message #261189 is a reply to message #240270] |
Wed, 22 August 2007 02:08  |
arunkp76
Messages: 16
Registered: August 2007
Location: Chennai
|
Junior Member |
|
|
Hi Anne,
First of all modify your tables, views to incorporate the org_id column
Changes in Tables
------------------
- Add org_id column to all customised tables which are used at operating unit levels
Changes in Views
----------------
- Explore the views in apps. In where
conditions you can see a condition org_id = substr(1,10,'CLIENT_INFO'). You can change your views using the same logic.
What the Client Info variables does?
The variable is a 64 byte variable which captures org_id, resp_id, resp_appl_id and user_id of the user who logins to oracle application. You need to segregate the data in the table and give information pretaining to him only ie, operating unit. First 10 bytes of Client info variable carries the org_id information. So you can filter your views based on this logic.
Changes in Forms
-----------------
You can segregate the data using org id from the current tables/views
If your forms are based on views then you can incorporate the clinet infor logic in the view itself with minimal or no changes in the form logic
If your forms are based on tables then you need to segregate data for that operating unit. The following logic will help.
The following API will return the org_id of the current responsibility and you can filter data from your base tables filtering for that org_id. The following API is used to return Org_id information from profile
fnd_profile.get('ORG_ID', v_org_id);
Hopw the above updates help ....
Arun
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
