Wednesday, February 15, 2012

Adding Responsibility to an Application User for Oracle E-Business Suite Application

Hi,
Adding Responsibility to an Application User can be done as follows:

Step 1:Login with 'sysadmin' user into Oracle E-Business Suite front
end page.


Step 2:In the Oracle Applications Home Page go to Navigator section,select the User Management Responsibility

Step 3:Click the User Management Responsibility,In the User Management,click Users

Step 4:In the Oracle User Management of page,we find lot of search options available for use,we can use % also to find the name of the Oracle Application user
If you now the employee id than you can directly enter here.

Let us say we want to change password for Employee id 'E0111' ,than I will enter 'EO111' in the place where User Name is present

Step 5:Search the user
After entering the User Name,click Go

We see the details as specified below:
Last Name First Name Email User Name Status Create User Reset Password Update

Step 6:Adding Responsibility

Click on Update tab shown with Pencil mark to add responsibility to the Application User.

Click on Assign Roles tab

Now,search the Roles or Responsibility we want and than click Select

Once selected,Give justification for adding the Responsibility.

Than Click on Save button at the bottom or top

Click on Apply or else any how the changes are applied by Apps engine after 5 minutes.


Step 7:Verify and Validate


Verify the added responsibilities are assigned to user and are active and also inform the user for adding
the responsibilities.



Note 1:We have one more method of adding responsibilities from front end(also called as form based).
i.e By going to System Administrator Responsibility =>Security:User Define
This opens the form page

In the Navigator-System Administrator form Page
Go to security,Click the + symbol
click the + User Tab
Click Define

From here also we can change the password and Add Responsibilities to Users,use % to search the User or Responsibility we want to search and add.

Note 2:We have the other method also for adding responsibilities to User from backend,but this method
is rarely used.Any how this is just for your information we can do as follows:

We can use FND_USER_PKG package present in Apps Schema to do so.

Conn Apps/****

BEGIN
fnd_user_pkg.addresp ('TESTAPP','SYSADMIN','SYSTEM ADMINISTRATOR','STANDARD',
'Add Sysadmin Responsibility to TESTAPP user using pl/sql', SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Responsibility is not added due to ' || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;
/


Hope it helps.....

Happy Apps DBA learning...


Best regards,

Rafi.

Saturday, February 11, 2012

Changing Oracle Application user password for Oracle E-Business Suite R12 Application

As a part of system administrator's task,Apps DBA do lot of tasks
One such task is changing or resetting Oracle Application user password.
We can follow the below steps to do this task:

Step 1:Login with 'sysadmin' user into Oracle E-Business Suite front
end page.


Step 2:In the Oracle Applications Home Page go to Navigator section,select the User Management Responsibility

Step 3:Click the User Management Responsibility,In the User Management,click Users

Step 4:In the Oracle User Management of page,we find lot of search options available for use,we can use % also to find the name of the Oracle Application user
If you now the employee id than you can directly enter here.

Let us say we want to change password for Employee id 'E0111' ,than I will enter 'EO111' in the place where User Name is present


Step 5:Seach the user
After entering ther User Name,click Go

We can see the details as specified below:
Last Name First Name Email User Name Status Create User Reset Password Update


Step 6:Reset the password
Click the Reset Password tab and Choose Enter Manually option of resetting the password.Now,we can enter the password and confirm the password and
Click Submit.

Step 7:Verify and inform the User
After resetting or changing the password,we can verify once ourself by logging from that user from the Oracle E-Business Suite front end page

Let us say we have reset the password of 'E0111' to welcome123,than we can login successfully and inform the user for the change.



Hope it helps....

Happy oracle Apps DBA learning..


Best regards,

Rafi.

Tuesday, February 7, 2012

Creating Soft link or Symbolic link for Concurrent Manager program files

Soft Link or Symbolic Link is required to read a shell script (.prog file) through a concurrent program.

We can create soft links or symbolic links for Concurrent Manager program files as follows:

Step 1:Go to the custom top as below:

>cd $xxtest_TOP/bin
testapp01(APPDEV) /product/appl/apps/apps_st/appl/xxtest/12.0.0/bin

Step 2: Use 'fndcpesr' command to create soft link

Lets say we have to create two symbolic links for two .prog files xxtest_techtest_ets_loader.prog and xxtest_techtest_points_loader.prog respectively,than we can proceed as follows:

$pwd
testapp01(APPDEV) /product/appl/apps/apps_st/appl/xxtest/12.0.0/bin
$ln -s $FND_TOP/bin/fndcpesr xxtest_techtest_ets_loader

$ln -s $FND_TOP/bin/fndcpesr xxtest_techtest_points_loader


Note:prog_name should be without .prog extension while creating symbolic link for .prog files.

Step 3:Verify the two created symbolic links:

$ls -altr xxtest_techtest*
lrwxrwxrwx 1 applmgr oinstall 55 Feb 7 14:29 xxtest_techtest_ets_loader -> /product/appl/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr
lrwxrwxrwx 1 applmgr oinstall 55 Feb 7 14:29 xxtest_techtest_points_loader -> /product/appl/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr
As we see above,after creating symbolic link the new attribute 'l' is added that is nothing but symbolic link.

Note:
1)'fndcpesr' is a standard utility available in $FND_TOP/bin directory.
2) Its mainly used by the application to parse arguments for shell scripts.
3)It is located in $FND_TOP/bin path along with other FND Utilities.
4)'fndcpesr' is an executable and read only file.

Hope it helps.

Happy Apps DBA learning...

Monday, February 6, 2012

Reference summary of asmcmd commands

asmcmd is a various nice feature of ASM.It helps us understand and do things from command line itself.I find this utility very useful.Thanks to Oracle again for making things easy.

Reference summary of asmcmd commands:

cd Changes the current directory to the specified directory.

du Displays the total disk space occupied by ASM files in the
specified ASM directory and all its subdirectories, recursively.

exit Exits ASMCMD.

find Lists the paths of all occurrences of the specified name (with
wildcards) under the specified directory.

help Displays the syntax and description of ASMCMD commands.

ls Lists the contents of an ASM directory, the attributes of the
specified file, or the names and attributes of all disk groups.

lsct Lists information about current ASM clients.

lsdg Lists all disk groups and their attributes.

mkalias Creates an alias for a system-generated filename.

mkdir Creates ASM directory.

pwd Displays the path of the current ASM directory.

rm Deletes the specified ASM files or directories.

rmalias Deletes the specified alias, retaining the file that the alias points to.

asm.sh, a Linux shell script, that demonstrates some of the asmcmd functionality.

lsct :list all connected Oracle instances

ASMCMD> lsct
DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group
+ASM CONNECTED 11.2.0.1.0 11.2.0.1.0 +ASM1 GRID_DATA_01
+ASM CONNECTED 11.2.0.1.0 11.2.0.1.0 +ASM1 TESTDB_DATA_01
TESTDB CONNECTED 11.2.0.1.0 11.2.0.0.0 TESTDB1 TESTDB_FRA_01
TESTDB CONNECTED 11.2.0.1.0 11.2.0.0.0 TESTDB1 TESTDB_DATA_01
ICMQB CONNECTED 11.2.0.1.0 11.2.0.0.0 ICMQB1 TESTDB_FRA_01
ICMQB CONNECTED 11.2.0.1.0 11.2.0.0.0 ICMQB1 TESTDB_REDO_01
ICMQB CONNECTED 11.2.0.1.0 11.2.0.0.0 ICMQB1 TESTDB_REDO_02

lsdg:List Diskgroup status and type.

ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 5934 5002 173 2414 0 N GRID_DATA_01/
MOUNTED EXTERN N 512 4096 1048576 2161538 112220 0 112220 0 N TESTDB_DATA_01/
MOUNTED EXTERN N 512 4096 1048576 654684 560350 0 560350 0 N TESTDB_FRA_01/
MOUNTED EXTERN N 512 4096 1048576 32652 11922 0 11922 0 N TESTDB_REDO_01/
MOUNTED EXTERN N 512 4096 1048576 32652 11954 0 11954 0 N TESTDB_REDO_02/


ASMCMD> iostat
Group_Name Dsk_Name Reads Writes
GRID_DATA_01 GRID_DATA_01_0000 3121340416 0
GRID_DATA_01 GRID_DATA_01_0001 3616768 0
GRID_DATA_01 GRID_DATA_01_0002 4354048 4096
GRID_DATA_01 GRID_DATA_01_0003 2061918208 4096
GRID_DATA_01 GRID_DATA_01_0004 3616768 0
GRID_DATA_01 GRID_DATA_01_0005 3731456 4096
TESTDB_DATA_01 TESTDB_DATA_01_0000 1868196700160 205746507776
TESTDB_DATA_01 TESTDB_DATA_01_0001 1860077395968 203464622080
TESTDB_DATA_01 TESTDB_DATA_01_0002 1860528062464 204175556608

Reference :MY ORACLE SUPPORT and Oracle Documentations

Hope is helps...

Happy ASM learning...

Changing the profile value in Oracle EBS applications

How do we change the profile value in Oracle EBS applications?

Ans: Below are the steps for changing profile value in Oracle EBS applications:

Step 1:
Login to EBS home page with 'SYSADMIN' or privileged application user.


Step 2:

In the Navigator,Go to System Administrator Tab and On the right side Go to Profile=>System



Step 3:

Click System you will see Oracle Application Manager Form Page is opened.


Step 4:

Double Click Profile Tab,go to System,Click Open Tab at the bottom.


Step 5:

We will see form page Find System Profile Values

Enter the Profile Name at the Bottom where Profile Tab is there and Click Find.

Where Profile:Name_of_profile whose value we want to set.


Step 6:
Now we will see Form Page where
Profile Option Name:Profile_name
Site:Value you want to set

Site=0,1...


Step 7:
Save the Changes.


File=>Save

And Close the Form.

File=>Close Form or Exit Oracle Applications.


Hope it helps Beginners Apps DBA