How to uninstall linux from windows in dual boot

First download bootsect.exe into the Download directory.

press the windows key, type cmd.exe and on the result (The command prompt) start it as an “Administrator” by right clicking on the cmd icon, and select Run as Administrator.

In the new cmd.exe window, cd to your download directory. for example cd C:\Users\Lalu Patel\Downloads. _assuming your user name is “Lalu Patel”.

Then enter this command. bootsect.exe /nt60 ALL /force /mbr. Restart your system to see that, Windows is automatically loading without grub.

Then in Windows

  1. Open the Control Panel (All Items view), and click on the Administrative Tools icon. then close the Control Panel window
  2. Click on Computer Management in Administrative Tools, then close the Administrative Tools window.
  3. In the left pane under Storage, click on Disk Management. see this.
  4. Select the the partition with unknown type. it is the Ubuntu partition. Right Click -> Delete partition.
  5. Now the former Ubuntu partition becomes an unallocated space.
  6. Select the left partition of the new unallocated space.
  7. Right click on the partition -> click on Extend Volume.
  8. Click on the Next button.
  9. Type in how many MB (1 GB = 1024 MB) you want to use from the unallocated space to extend the selected partition (step 5) into, then click on the Next button.see this.

    Note: If you want to use all of the unallocated space to extend into, then type in the maximum available space shown for the unallocated space.

  10. Click on the Finish button. You’re done.

Source: bootsect, disk management

Delete/End Date Element Entry – HRMS APIs

Below is the script for Deleting Element Entry in HRMS

declare

ld_effective_start_date      date;
ld_effective_end_date       date;
lb_delete_warning             boolean;
ln_element_entry_id          number;
ln_object_version_number number;
ln_assin_id                          number;

lc_element_name       pay_element_types_f.element_name%type := ‘Clothing For Official Mission’;
— lc_emp_num             varchar2(6) := ‘005746’;

cursor c is   select pee.element_entry_id
,pee.object_version_number
,paf.assignment_id
from per_all_people_f        per
,per_all_assignments_f   paf
,pay_element_entries_f   pee
,pay_element_types_f_tl  petl
,pay_element_types_f     pet
where 1=1– per.employee_number = lc_emp_num
and trunc(sysdate) between per.effective_start_date and per.effective_end_date
and paf.person_id       = per.person_id
and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
and pee.assignment_id   = paf.assignment_id
and pee.element_type_id = pet.element_type_id
and trunc(sysdate) between pee.effective_start_date and pee.effective_end_date
and petl.element_name   = lc_element_name
and petl.language       = ‘US’
and pet.element_type_id = petl.element_type_id;

begin

/* Date Track modes
DELETE             >> end date element entry
DELETE_NEXT_CHANGE >> delete next changes
FUTURE_CHANGE      >> delete future changes
ZAP                >> completely remove element entry from the database
*/
for i in c loop

dbms_output.put_line(‘Values are element_entry_id’||i.element_entry_id||’ assignment_id ‘||i.assignment_id);
pay_element_entry_api.delete_element_entry
(p_validate                     => false
,p_datetrack_delete_mode        => ‘DELETE’
,p_effective_date               => trunc(sysdate-17)
,p_element_entry_id             => i.element_entry_id
,p_object_version_number        => i.object_version_number
,p_effective_start_date         => ld_effective_start_date
,p_effective_end_date           => ld_effective_end_date
,p_delete_warning               => lb_delete_warning
) ;
commit;

end loop;
exception
when others then
dbms_output.put_line(‘Error: ‘||sqlerrm);
rollback;
end;

How can an element be deleted or end dated in Oracle HRMS Payroll

HOW TO DO??

The element may be deleted if the element has never been processed.

1) Purge the links for may have been created for the element.

How to delete Element Links Procedure

2) if the element has been assigned to an employee, purge it from the employee’s element entries.

How to delete Element Entries Procedure

To purge the links

  •  Navigate: Total Compensation   > Element Link.
  •  Query the element.
    Select the red X icon.
  •  Select Purge.
  •  Save.

To delete or end date an element:

  •  Navigate: Total Compensation  >  Element Description.
  •  Query your element.
  •  Select the red X icon.

Leave a comment for any query.

 

Source

Query to find the Concurrent Program attached to Responsibility

Below is Query to find the Concurrent Program that has been attached to Responsibility.

SELECT frt.responsibility_name, frg.request_group_name,
frgu.request_unit_type,frgu.request_unit_id,
fcpt.user_concurrent_program_name
FROM fnd_Responsibility fr, fnd_responsibility_tl frt,
fnd_request_groups frg, fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
AND frt.LANGUAGE = USERENV(‘LANG’)
AND fcpt.LANGUAGE = USERENV(‘LANG’)
AND fcpt.user_concurrent_program_name = :conc_prg_name
ORDER BY 1,2,3,4

Scheduling Failed. Unable to find a calendar date

As I got this Error while placing a Sales order I just searched and got thsi Document from Oracle (Doc ID 1265873.1) As Mentioned I have Setup the Workday Calendar and then when I checked the Issue was resolved.

Below is the solution provided by Oracle

Set up the Workday Calendar.

The Workday Calendar must be setup correctly and rebuilt any time modifications are made to the Calendar.

Navigation paths: Bill of Materials/Setup/Calendars
OR
Inventory/Setup/Organization/Calendars

Once you have made your modifications, you need to rebuild the calendar by selecting the special option on the top tool bar. On the drop down list, click ‘Build’.

Then run data collections to collect this information, then try to schedule the order.

If this still fails then review Note 563072.1 – ‘Unable To Find A Calendar Date’ While Scheduling a Sales Order
— this details other errors in setup that can cause this issue to occur.

Changing Referral Instance link in Irecruitment

Sometimes when we refer a job to our friend and when we feel that it is a wrong instance we can change it by using the below profile option

IRC: External Framework Agent

Most of the changes in the Irec Module will be in Profile Options for any changes.

Thank you..

 

Query to get Executable, Concurrent, Application in oracle apps AOL

Below query gives the Executable, Concurrent, Application info in oracle apps AOL
select fcpv.OUTPUT_FILE_TYPE, fcpv.CONCURRENT_PROGRAM_NAME, fcpv.USER_CONCURRENT_PROGRAM_NAME, substr(fat.application_name, 0,3), EXECUTION_FILE_NAME
from FND_CONCURRENT_PROGRAMS_VL fcpv , fnd_application_tl fat , FND_EXECUTABLES_FORM_V fefv
where
fcpv.application_id = fat.application_id
and fefv.executable_id = fcpv.EXECUTABLE_ID
and fcpv.USER_CONCURRENT_PROGRAM_NAME in (
‘HW Employee Contract Extension Letter’,
‘HW Employment Letter to Embassy’
,’HW Empoyee Education Certificate Letter’,
‘HW Probation Conformation Letter’,
‘HW Salary Certificate Letter’,
‘HW Salary Increment Letter’,
‘HW Salary Increment Or Bonus Letter Report’,
‘HW Sponsorship Visa Letter to Embassy’,
‘HW To Whom it May Concern Letter’,
‘HW Promotion Conformation Letter’,
‘HW Salary Alignment letter’,
‘HW Resignation Letter to Bank’,
‘HW Experience Certificate’,
‘HW Resignation Acceptance Letter’,
‘XXHW Employee Contract Non Renewable Report’,
‘HW Bonus Letter Only’
);

Query to Get Leave Balance for different Leaves

Query to Get Leave Balance for different Leaves
SELECT   a.employee_number staff_no,
a.full_name staff_name,
a.start_date date_of_join,
d.name Position,
c.parent_org_name department,
c.child_org_name section,
(SELECT   NVL (SUM (paa.absence_days), 0)
FROM   per_absence_attendances paa,
per_absence_attendance_types pat
WHERE   1 = 1 AND paa.person_id = a.person_id
AND paa.absence_attendance_type_id =
pat.absence_attendance_type_id
AND pat.absence_attendance_type_id IN (63, 79, 80)
AND paa.date_start IS NOT NULL
AND TRUNC (paa.date_start) BETWEEN :p_from AND :p_to)
annual_leave_utilized_2016,
— xxhy_leave_bal_fun (b.assignment_id) annual_leave_balance,
get_net_entitlement (b.assignment_id, 61, :p_to)
annual_leave_balance,
(SELECT   NVL (SUM (paa.absence_days), 0)
FROM   per_absence_attendances paa,
per_absence_attendance_types pat
WHERE   1 = 1 AND paa.person_id = a.person_id
AND paa.absence_attendance_type_id =
pat.absence_attendance_type_id
AND pat.absence_attendance_type_id = 1081
AND paa.date_start IS NOT NULL
AND TRUNC (paa.date_start) BETWEEN :p_from AND :p_to)
componsa_leave_util_2016,
get_net_entitlement (b.assignment_id, 1061, :p_to)
compen_leave_balance,
(SELECT   NVL (SUM (paa.absence_days), 0)
FROM   per_absence_attendances paa,
per_absence_attendance_types pat
WHERE   1 = 1 AND paa.person_id = a.person_id
AND paa.absence_attendance_type_id =
pat.absence_attendance_type_id
AND pat.absence_attendance_type_id = 77
AND paa.date_start IS NOT NULL
AND TRUNC (paa.date_start) BETWEEN :p_from AND :p_to)
Sick_leave_util_2016,
(SELECT   NVL (SUM (paa.absence_days), 0)
FROM   per_absence_attendances paa,
per_absence_attendance_types pat
WHERE   1 = 1 AND paa.person_id = a.person_id
AND paa.absence_attendance_type_id =
pat.absence_attendance_type_id
AND pat.absence_attendance_type_id = 67
AND paa.date_start IS NOT NULL
AND TRUNC (paa.date_start) BETWEEN :p_from AND :p_to)
Emergency_leave_util_2016,(SELECT   NVL (SUM (paa.absence_days),
0)
FROM   per_absence_attendances paa,
per_absence_attendance_types pat
WHERE   1 = 1 AND paa.person_id = a.person_id
AND paa.absence_attendance_type_id =
pat.absence_attendance_type_id
AND pat.absence_attendance_type_id not in ( 67,77,63, 79,
80)
AND paa.date_start IS NOT NULL
AND TRUNC (paa.date_start) BETWEEN :p_from AND :p_to)
other_leave_util_2016
— xxhy_leave_bal_compen_fun (b.assignment_id) compen_leave_balance
FROM   per_all_people_f a,
per_all_assignments_f b,
xxhw_organization_hierarchy_v1 c,
per_positions d
WHERE       1 = 1
AND a.person_id = b.person_id               — and a.person_id=1102
AND b.organization_id = c.child_org_id
AND TRUNC (SYSDATE) BETWEEN a.effective_start_date
AND  a.effective_end_date
AND TRUNC (SYSDATE) BETWEEN b.effective_start_date
AND  b.effective_end_date
AND TRUNC (SYSDATE) BETWEEN c.effective_date_from
AND  c.effective_date_to
AND a.current_employee_flag = ‘Y’
–AND a.employee_number LIKE ‘004014’
AND b.assignment_type = ‘E’
AND b.position_id(+) = d.position_id
–and c.parent_org_name=’Telecom unit_DT’
ORDER BY   1

Error while mounting NTFS file system as read write

Below is the error which comes when trying to mount NTFS file system with read and write access

The disk contains an unclean file system (0, 0).
Metadata kept in Windows cache, refused to mount.
Falling back to read-only mount because the NTFS partition is in an
unsafe state. Please resume and shutdown Windows fully (no hibernation
or fast restarting.)

After searching I got what to do

Run the below command

$ sudo ntfsfix /dev/sda8

Now mount the file system read and write access by below command

$ sudo mount -o rw /dev/sda8 /media/user

 

Code for Making a field or Response box mandatory in Workflow

Below is the code that will check the workflow for mandatory of response field.

Here the p_funcmode = ‘VALIDATE’ sets in validate mode and after handling the validation the we can set the appropriate message in the this line

x_resultout := ‘ERROR:You Must the Reason’;

 

if( p_funcmode = ‘VALIDATE’) then
l_nid := wf_engine.context_nid;
v_result :=wf_notification.getattrtext (l_nid, ‘APPROVE_COMMENTS’);
if(v_result is null)
then
x_resultout := ‘ERROR:You Must the Reason’;
end if;
end if;