zz:http://www.oracleappshub.com/api/oracle-api-availability-profile/
In oracle user Profile functionality is provided in theFND_PROFILEpackage and the FNDSQF library.
What is inside this API:
- Retrieve user profile values for the current run-time environment
- Set user profile values for the current run-time environment
There are various Objects that can be used with this API's. These are discussed below:
1. Put :This can be used to put a value to the specified user profile option.
Usage:
- FND_Profile.Put('PROFILE_NAME','New_Value')
- FND_Profile.Put('USERNAME', Usr_Name)
- FND_Profile.Put('RESP_ID', Resp_ID)
- FND_Profile.Put('RESP_APPL_ID', Resp_App_ID)
- FND_Profile.Put('USER_ID', User_ID)
2.DEFINED :this is function returns TRUE if a value has been assigned to the specified profile option.
Usage:
- SELECT fnd_profile.defined('ACCOUNT_GENERATOR:DEBUG_MODE') ACC_GEN_DEBUG_SESSION_MODE FROM DUAL;
3.GET :This is used to retrieve the current value of the specified user profile option
Usage :
Different type of options can be retrieved like
- FND_Profile.Get('PROFILENAME', Profile_name);
- FND_Profile.Get('CONC_LOGIN_ID', Conc_login_id);
- FND_Profile.Get('LOGIN_ID', loginid);
4.VALUE :This is function which returns a character string. Used to retrieve the current value of the specified user profile option.
Usage:
- fnd_profile.value('PROFILEOPTION')
- fnd_profile.value('MFG_ORGANIZATION_ID')
- fnd_profile.value('login_ID')
- fnd_profile.value('USER_ID')
- fnd_profile.value('USERNAME')
- fnd_profile.value('CONCURRENT_REQUEST_ID')
- fnd_profile.value('GL_SET_OF_BKS_ID')
- fnd_profile.value('ORG_ID')
- fnd_profile.value('SO_ORGANIZATION_ID')
- fnd_profile.value('APPL_SHRT_NAME')
- fnd_profile.value('RESP_NAME')
- fnd_profile.value('RESP_ID')
5.VALUE_WNPS:This is a function, returns a character string. This is Used to retrieve the current value of the specified user profile option without caching it.
6.SAVE_USER :This is function used to save a value for a profile option permanently to the database, for the current user level. It is necessary to explicitly issue a commit when using this function. Returns TRUE if profile option
is successfully saved, otherwise FALSE.
7.SAVE :This is function used to save a value for a profile option permanently to the database, for a specified level. It is necessary to explicitly issue a commit when using this function. Returns TRUE if profile option is successfully
saved, otherwise FALSE.
Usage
- fnd_profile.save('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');
8.INITIALIZE:This is used by internal Applications Object Library to initialize the internal profile information at the level context.
The cache is first cleared of all database options.
Usage:
- fnd_profile.initialize(user_id);
9.PUTMULTIPLE :This is used by internal Applications Object Library to set multiple pairs of profile options and values.
分享到:
相关推荐
Oracle High Availability, Disaster Recovery, and Cloud Services
Oracle高可用体系结构视屏资料;描述oracle高可用体系的搭建。
详细介绍了ORACLE高可用相关内容,其中主要包括了管理配置和监控这一块,是不可多得的一本电子书哦
databases to use the Oracle high-availability infrastructure. – Oracle Clusterware enables you to create a clustered pool of storage to be used by any combination of nonclustered and Oracle RAC ...
A High Availability (HA) cluster is a set of servers (nodes) managed by clusterware to work together for minimizing application downtime as much as possible. Clusterware enables servers to ...
Oracle Database High Availability Best Practices 11g Release 2 (11.2)-262
Oracle Database 11g Release 2 High Availability
官方资料:Oracle Database 12c高可用规划(Maximize Availability With Oracle Database 12c) 内容是全英文。Oracle Database 12c: Extreme Availability。Maximum Availability Architecture。High Availability ...
Oracle Database High Availability Overview 11g Release 2 (11.2)-136
Oracle Clusterware Administration and Deployment Guide, 11g Release 2 (11.2)
Oracle11g第2版的高可用性 第2版 Oracle Database 11g Release 2 High Availability
High Availability with Oracle Database 11g Release 2,Oracle的高可用性白皮书
Oracle High Availability using Veritas Cluster Server (VCS)
Enable high availability and scalability with Oracle Real Application Clusters and Oracle Active Data Guard Perform backup and recovery with Oracle Recovery Manager Manage distributed databases and ...
例如: dependencies : google_api_availability : ^2.0.4 注意:将使用Swift的插件集成到由Objective-C模板创建的Flutter项目中存在一个已知问题。 有关集成的帮助,请参见问题 。APIGoogleApi可用性
官方资料:Oracle Data Guard 11g Release 2:High Availability to Protect Your Business • Data availability and data protection for the Oracle Database• Up to thirty standby databases in a single ...
CentOS High Availability
14 章,可管理性 Chapter 15, Backup and Recovery 第 15 章,备份与恢复 Chapter 16, Business Intelligence 第 16 章,业务智能 Chapter 17, High Availability 第 17 章,高可用性 Chapter 18, ...