忙裏偷閑

很多事情很多心情寫了也就記下了; 不寫,以後可能就忘了.
個人資料
正文

Defining User Profile

(2009-03-18 07:21:48) 下一個

We all know the we can refer system profiles by using FND_PROFILE.VALUE(profile_name). There are already existing system profiles. We can also define and set up profiles not provided by Oracle, for example: FTP_TO_TARGET_SERVER_NAME. In this case, we can refer it in PL/SQL by FND_PROFILE.VALUE('FTP_TO_TARGET_SERVER_NAME'). The below are the steps to define user profiles. 

1)      Log in as Application Developer responsibility, click on ‘Profile’ from menu. when the form opened, input all necessary information.

Name: FTP_TO_TARGET_SERVER_NAME

Application: XX

User Profile Name: Target Server Name for FTP

Hierarchy Type: Security

Hierarchy Type Access Level: Check site and Application.

2)      Switch to System Administrator responsibility

Menu: Profile -> System

Search for Profile: Target%FTP% on site level, the defined profile will be showed in the opened ‘System Profile Values’ Window. (‘Profile Option Name’ will be ‘User Profile Name ‘defined in step 1).

3)      Set up the value for this profile in this window, then you can refer it by using FND_PROFILE.VALUE('FTP_TO_TARGET_SERVER_NAME').

Note: FND_PROFILE.VALUE(Target Server Name for FTP'). To avoid confusion, you can give the same name for Name and User Profile Name is step one.

This voids us to hard code the server path in the code. We can set up the different values in test and production environment without code change.

[ 打印 ]
閱讀 ()評論 (1)
評論
目前還沒有任何評論
登錄後才可評論.