The use of EBS fnd_global.apps_initialize
Responsibility_application_id);
Role: the conversation in the database set up global variables, and user-summary information.
Parameters was:
Parameters of a User ID
select user_id
from fnd_user
where user_name like '% OPERATIONS%'; - ID of OPERATIONS: 1318
Parameter b, duties ID (responsibility id)
select RESPONSIBILITY_ID, APPLICATION_ID, RESPONSIBILITY_KEY
from fnd_responsibility
- where APPLICATION_ID = 140
where RESPONSIBILITY_KEY like '% ASSETS_VISION_OPERATIONS%';
Parameter c, on behalf of the duties of their applications (application) number
SQL access to the above
Run:
BEGIN
fnd_global.APPS_INITIALIZE (youruesr_id, yourresp_id, yourresp_appl_id);
END;
Test:
select fnd_profile.value ( 'GL_SET_OF_BKS_ID') FROM DUAL;
fnd_profile.value ( 'USER_ID') - corresponds to just user_id
Related Posts of The use of EBS fnd_global.apps_initialize
-
The second part (12) of the creation of practice-wide library Streams replication environment (2) the implementation of the creation of
Second, access to create a link, the operation is as follows: 1, the administrator account to create streams Recommendations for the management of streams tablespace the creation of an independent account to facilitate the management of maintenance. ...
-
The third part (21) Advanced Configuration of the single-source multi-directional replication environment (3)
Fifth, the entire configuration manually copy the environment How do I remove a replication environment, you must have been cooked can not be cooked, not demonstrated here. Attention in front of auto-configuration has also created a number of other s ...
-
Detailed rules to optimize Oracle statement
1. The types of Oracle Optimizer Oracle's Optimizer total of three kinds: a.RULE (rule-based) b.COST (based on cost) c.CHOOSE (optional) Optimization of the default settings, you can file through the init.ora parameters OPTIMIZER_MODE various sta ...
-
Detailed rules Optimize Oracle statement
1. The types of Oracle Optimizer Oracle's Optimizer total of three kinds: a.RULE (rule-based) b.COST (based on cost) c.CHOOSE (optional) Optimize the default settings, you can file through the init.ora parameters OPTIMIZER_MODE various statements ...
-
Oracle Database Exp / Imp tools for performance tuning
Abstract: Oracle Exp / Imp instrument is a simple, convenient and flexible backup and restore data transfer tool, it can implement the entire class library, user-level, table-class data backup and recovery. For the amount of data in class G or G with ...
-
Detailed: database name. Instance name. ORACLE_SID. Database name
Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some
-
Database tuning problem (parameter binding, Histogram Analysis)
1, histogram Analysis of depth. . 20080901 ~ 20060101 ~ 99991231 2, the binding parameters The use of different parameters of the different analysis. . . The use of index Scanning the entire table is slightly
-
setting to discuss filing oracle10g
Oracle Database 10g Enterprise Edition Release 10.2.0 .4.0 - Prod PL / SQL Release 10.2.0 .4.0 - Production IXDBA.NET Community Forums CORE 10.2.0 .4.0 Production TNS for Solaris: Version 10.2.0 .4.0 - Production NLSRTL Version 10.2.0 .4.0 - Producti ...
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply