what is this exactly FND_CLIENT_INFO

[moyoal]

Dear All,

Anyone can tell me what this exactly in oracle applications, FND_CLIENT_INFO its a Database procedure/Function or what?

thanks in advance.
moyoal

[amitpatel66]

Dear All,

Anyone can tell me what this exactly in oracle applications, FND_CLIENT_INFO its a Database procedure/Function or what?

thanks in advance.
moyoal

FND_CLIENT_INFO is mainly used to set the organization of the application. ITs something similar to setting the environment in unix box for pareticular Oracle instance.

For Example:

[code=oracle]

EXEC FND_CLIENT_INFO .SET_ORG_CONTEX T('204');

[/code]

The above code when run, sets the organization to 204 and the datas for the operating unit = 204 will be retrieved from the oracle application views like po_headers,ap_v endors etc.....

[moyoal]

thanks amit for your reply, but my question is still,
FND_CLIENT_INFO is a built-in procedure/function or what...where i can find the FND_CLIENT_INFO coding/details

regards,
awaiting

FND_CLIENT_INFO is mainly used to set the organization of the application. ITs something similar to setting the environment in unix box for pareticular Oracle instance.

For Example:

[code=oracle]

EXEC FND_CLIENT_INFO .SET_ORG_CONTEX T('204');

[/code]

The above code when run, sets the organization to 204 and the datas for the operating unit = 204 will be retrieved from the oracle application views like po_headers,ap_v endors etc.....

[amitpatel66]

thanks amit for your reply, but my question is still,
FND_CLIENT_INFO is a built-in procedure/function or what...where i can find the FND_CLIENT_INFO coding/details

regards,
awaiting

Here it goes: Its a Package:

[code=oracle]

SQL> desc FND_CLIENT_INFO

PROCEDURE SETUP_CLIENT_IN FO

Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLICATION_ID NUMBER IN
RESPONSIBILITY_ ID NUMBER IN
USER_ID NUMBER IN

PROCEDURE SET_CURRENCY_CO NTEXT

Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONTEXT VARCHAR2 IN

PROCEDURE SET_ORG_CONTEXT

Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONTEXT VARCHAR2 IN
SQL>

[/code]

[moyoal]

thanks alot amit...i got exactly what i was looking

Here it goes: Its a Package:

[code=oracle]

SQL> desc FND_CLIENT_INFO

PROCEDURE SETUP_CLIENT_IN FO

Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLICATION_ID NUMBER IN
RESPONSIBILITY_ ID NUMBER IN
USER_ID NUMBER IN

PROCEDURE SET_CURRENCY_CO NTEXT

Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONTEXT VARCHAR2 IN

PROCEDURE SET_ORG_CONTEXT

Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONTEXT VARCHAR2 IN
SQL>

[/code]

[amitpatel66]

You are welcome. Do post back in case of any further issues