How To Install LVMs With a GUI

The Logical Volume Manager or LVM

Install LVM GUI utility

On RHEL

You can install the package using the CLI, by issuing in a terminal:

#yum install system-config-lvm

Once installed, you can issue the following command to launch it:

#sudo system-config-lvm

Once installed  the program will appear under “System” -> “Administration” -> “Logical Volume Management”.

Update People National Identifier using API

Bulk Update Employee national identifier using oracle hrms api

Declare
 Cursor c_emp_cur (cp_employee_number In Varchar2) Is
        Select papf.employee_number
              ,papf.effective_start_date
              ,papf.object_Version_number
              ,papf.person_id
        From per_All_people_f papf
        Where papf.business_group_id = <<Business Group Id>>
        And papf.person_type_id = <<Active Person Type Id>>
        And papf.employee_number = cp_employee_number
        And sysdate Between papf.effective_start_date And papf.effective_end_date;
  l_emp_rec c_emp_cur%rowtype;
  l_emp_no Varchar2(30);
  l_effective_start_date Date;
  l_effective_end_date Date;
  l_full_name per_all_people_f.employee_number%type;
  l_commnet_id Number;
  l_name_combination_warning Boolean;
  l_assign_payroll_warning Boolean;
  l_orig_hire_warning Boolean;
Begin
 -- initialize app session
 fnd_global.apps_initialize(<<AOL user id>>,<<HRMS Responsibility Id>>,HRMS Application Id (Default Id 800));
 For i In (Select  emp_no,
                           nat_no
              from xxhr_emp_nat )
  Loop
    Open c_emp_cur(cp_employee_number => i.emp_no);
    Fetch c_emp_cur Into l_emp_rec;
    Close c_emp_cur;
  l_emp_no := l_emp_rec.employee_number;
  hr_person_api.update_person
  (p_effective_date               => l_emp_rec.effective_start_date
  ,p_datetrack_update_mode        => 'CORRECTION'
  ,p_person_id                    => l_emp_rec.person_id
  ,p_object_version_number        => l_emp_rec.object_Version_number
  ,p_employee_number              => l_emp_no
  ,p_national_identifier          => i.nat_no
  ,p_effective_start_date         => l_effective_start_date
  ,p_effective_end_date           => l_effective_end_date
  ,p_full_name                    => l_full_name
  ,p_comment_id                   => l_commnet_id
  ,p_name_combination_warning     => l_name_combination_warning
  ,p_assign_payroll_warning       => l_assign_payroll_warning
  ,p_orig_hire_warning            => l_orig_hire_warning
  );
  End Loop;
  commit;
End;

XML Publisher RTF template Page Break

Use any one the syntax inside the form field

Delete Duplicate Rows Based on a Column

There are so many ways available, but I used oracle analytic .

Use analytic to delete duplicate rows
You can  detect and delete duplicate rows using Oracle analytic functions:

delete from
   <<xxx_accounts>>

where rowid in
 (select rowid from
   (select
     rowid,
     row_number()
    over
     (partition by account_name order by account_name) dup
    from <<xxx_accounts>>
    )
  where dup > 1 )

How to Sign Into Two or More Skype Accounts at Once in Windows

To launch a second Skype application on Windows, press Windows Key + R to open the Run dialog, copy-paste the below command into it, and press Enter.

On a 64-bit version of Windows

"C:\Program Files (x86)\Skype\Phone\Skype.exe" /secondary

On a 32-bit version of Windows

"C:\Program Files\Skype\Phone\Skype.exe" /secondary

You can create shortcut also, so you don't need to repeat the same command again and again

Secure Admin must be enabled to access the DAS remotely

I installed Glassfish on my development server and  access the administration module locally by using “localhost:4048”. But when I try to access it remotely, by using “http:/my_host:port”. It shows me an error as cannot login with the message as

Secure Admin must be enabled to access the DAS remotely

Solution:
Activate the secure admin by using the following command line 

asadmin --host localhost --port 4848 enable-secure-admin

The host is the host name or IP address for the Glassfish Server which we need to enable the secure admin.The port is the target Glassfish Server port which wee need to enable the secure admin.

Rollback

 disable the secure admin, it can be done easily as the following: –
asadmin --host [host] --port [port] disable-secure-admin 

Glassfish Change Admin Password

Use change-admin-password sub command to change the password of glassfish admin user. Default administrator username of glassfish is "admin". Default password of "admin"" user is blank on first installation.


Changing the Administrator Password 

Ensure that the server is running

asadmin --user admin
asadmin> change-admin-password
Please enter the old admin password>
Please enter the new admin password>
Please enter the new admin password again>
Command change-admin-password executed successfully

How to Delete XML Publisher Definition

In the XML publisher Responsibility,  data definition there is no option to delete unwanted or wrong definitions.

BEGIN

XDO_DS_DEFINITIONS_PKG.DELETE_ROW('<<APPLICATION SHORT NAME>>', '<<XML DEFITION CODE>>')

END;