Home » Applications » Other Application Suites » Customized forms Upgrading to Multi-org
Customized forms Upgrading to Multi-org [message #240270] Thu, 24 May 2007 08:59 Go to next message
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 #240679 is a reply to message #240270] Fri, 25 May 2007 08:48 Go to previous messageGo to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Any thoughts???
Re: Customized forms Upgrading to Multi-org [message #261189 is a reply to message #240270] Wed, 22 August 2007 02:08 Go to previous messageGo to next message
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

Re: Customized forms Upgrading to Multi-org [message #268457 is a reply to message #261189] Tue, 18 September 2007 13:24 Go to previous message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Thanks..the information helped greatly and some information I found as well.

Anne
Previous Topic: Bind Variables are defined as VARCHAR2 for table columns of CHAR data type
Next Topic: Training in Oracle/Siebel CRM
Goto Forum:
  


Current Time: Wed Sep 03 03:07:16 CDT 2014

Total time taken to generate the page: 0.11407 seconds