If you are new here, you may want to subscribe to the following feeds FND_GLOBAL.APPS_INITIALIZE
Written by Nilesh JethwaFND_GLOBAL.APPS_INITIALIZE
procedure APPS_INITIALIZE(user_id in number,
resp_id in number,
resp_appl_id in number);
This procedure sets up global variables and profile values in a database
session. Call this procedure to initialize the global security context for
a database session. You can use it for routines such as Java, PL/SQL,
or other programs that are not integrated with either the Oracle
Applications concurrent processing facility or Oracle Forms (both of
which already do a similar initialization for a database session).
The typical use for this routine would be as part of the logic for launching a
separate non–Forms session (such as a Java program) from an
established Oracle Applications form session. You can also use this
procedure to set up a database session for manually testing application
code using SQL*Plus. This routine should only be used when the
session must be established outside of a normal form or concurrent
program connection.
You can obtain valid values to use with this procedure by using profile
option routines to retrieve these values in an existing Oracle
Applications form session. For manual testing purposes, you can use
Examine during an Oracle Applications form session to retrieve the
profile option values.
USER_ID : The USER_ID number
RESP_ID : The ID number of the responsibility
RESP_APPL_ID : The ID number of the application to which the responsibility belongs
example:
fnd_global.APPS_INITIALIZE (1010, 20417, 201);
Posted in ERP |
4 Comments to “FND_GLOBAL.APPS_INITIALIZE”
Leave a Comment
Free Dashboards and KPI examples
October 12th, 2006 at 11:02 am
I call a procedure from a emote databse using JDBC to connet to the apps database.
When I run l fnd_global.APPS_INITIALIZE I received the error
=============
ORA-20001: Oracle error -20001: ORA-20001: APP-FND-02500: Error occurred during product initialization for MO when executing ‘begin MO_GLOBAL.INIT; end;’.
SQLCODE = -20001
SQLERROR = ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, fnd.plsql.MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile
=============
Any help?
Thanks
October 12th, 2006 at 12:47 pm
Can you post the syntax with what parameters are you calling this procedure? Also are you connected to database using the apps user_id?
June 30th, 2008 at 12:12 pm
Hi Nilesh
I am facing exactly the same error.
But in my case its happening in my Development environment.
I mean its been working well till now(for 1+ yr apprx)
The parameters which I am passing is FND_GLOBAL.apps_initialize(0,21739,514);
Any help on this is appreciated.
Thanks
Iswarya
July 25th, 2008 at 5:47 am
Hi ,
am also , facing the same problem .
is any body resolved this problem , its very help to me ..