Home » Applications » Oracle Fusion Apps & E-Business Suite » How To Switch Apps Context In One Session From One Org to Another (Oracle EBS 11.5.10, Linux 4, Oracle DB 10g)
How To Switch Apps Context In One Session From One Org to Another [message #586685] Sun, 09 June 2013 09:44
Messages: 7
Registered: August 2010
Junior Member

We are using Oracle APPS 11.5.10 with Database 10g and trying to create receipts using API in a PL/SQL procedure and have registered this procedure a concurrent request. This procedure reads the data from a custom table. The table contains receipt information rows for different orgs. So, in order to create receipts for different orgs we have to run this request multiple times for different orgs. Is it possible for us to run the request once and procedure would change the APPS context at run time reading the respective org from custom table. I hope I have made my point clear.

We have consulted the API documentation as well and it says:

Before you begin to use the API....
Initialization of ARP_STANDARD and ARP_GLOBAL
Custom code that uses AR or HZ APIs will set the ORG_ID via dbms_application_
info.set_client_info() and then call the APIs. The APIs in turn might access either
ARP_STANDARD and ARP_GLOBAL, which initialize the global variables that are used
across Oracle Receivables when the package is first called. Most of these global variable
values are organization dependent, and the first such call sets the global variables based
on the current ORG_ID.
If additional custom code then changes the ORG_ID via another call to
dbms_application_info.set_client_info(), then the ORG context changes, but the
ARP_STANDARD and ARP_GLOBAL context does not.
In such cases, you should explicitly re-initialize the global variables by a call to these
two public procedures:
1. ARP_GLOBAL.INIT_GLOBAL: For setting public variables in ARP_GLOBAL.
2. ARP_STANDARD.INIT_STANDARD: For setting public variables in

We have followed the guide lines to an extent we could understand and it does set the APPS context for the first org it find and then doesn't switch over to other orgs.

Waiting for expert opinion.

Previous Topic: Form Folders help
Next Topic: Query Help..
Goto Forum:

Current Time: Sat May 15 07:09:18 CDT 2021