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;

Oracle HRMS Payroll -Retry,Reverse and Rollback a Payroll process

Marking and Retrying Payroll Runs and Other Processes

To mark a small payroll process for retry

    • In the Payroll Processes window, select the process to retry and check the Retry box. This effectively marks every employee assignment included in the process for reprocessing when you retry it.

To mark a large payroll process for retry ->

  1. In the Submit Requests window, select Mark Payroll Run for Retry in the Name field if you are retrying a payroll run. Otherwise select Mark Process for Retry. These processes have the same parameters, Payroll Process and Assignment Set.
  2. Select the process you are marking for retry.
  3. Leave the Assignment Set field blank.
  4. Choose Submit.

To mark an individual employee assignment for retry

    • In the Assignment Processes window, select the assignment to retry and check the Retry box. Then when you retry the process, only these assignments are reprocessed. This is a convenient approach when only a few assignments require reprocessing.

Correcting Run Results Reversals

You reverse pay runs in the Reverse Payroll Run window for the employee assignment.

To reverse a payroll run or QuickPay for an assignment

  1. Select the run you want to reverse.

All the payroll runs for the assignment are displayed when you open the window.

  1. Select the Reverse check box for the run you want to reverse.

The consolidation set for the run automatically displays as the consolidation set for the reversal.

  1. Select a different consolidation set if you want to process the reversal in a different set to the original run set.

After running the payroll and if post run processing has already occurred we cannot correct the payroll by retry, even in case of roll back we need to roll back the complete Payroll for correcting an entry for one or two assignment.
In these cases we can use Payroll Reversal. In short Payroll Reversal helps to correct the run result for an single assignment

To Reverse the Payroll run for an assignment
(R) US HRMS Manager
(N) Fast Path > Reverse Payroll Run
Select the Assignment that you need to reverse from the LOV, Tick the Reverse Check Box for the Payroll that we need to reverse and save the work. Consolidation set for the run will be automatically displayed for the Reversal
Now the Run Result is been reversed to the Value before the payroll Run. Now you can modify the Entry and start processing your payroll again.

Rolling Back Payroll Runs and Other Processes

You can roll back a process in one of several ways depending on the extent of the rollback.

If you want to … Then refer to…
Roll back processes for a few individuals Rolling Back a Process from the Payroll Processes Window
Roll back processes for many employees (defined as an assignment set) Rolling Back a Process from the Submit Requests Window
Roll back an assignment process for an individual employee Rolling Back a Process from the Assignment Processes Window

Once the Payroll /Quick Pay process is completed if there is some issue or if some correction need to be made. We can either

  • Retry
  • Reverse
  • Rollback

What Rollback does?

In simple word to explain Rollback process reset the Run Result and the Latest balance back to the value before running the Payroll Process.

Rollback process has to be run in the same reverse sequence of the Payroll Run. for eg. for processing the payroll, we run the following process in sequence Payroll run, Prepayment, costing, Transfer to GL. Similarly for the Rollback we need to run in the reverse sequence Rollback Transfer to GL, Rollback Costing, Rollback Prepayment, Rollback Payroll Run.

Note: if the costing details are imported into GL then we cannot rollback the process.So it is always advisable to run the Transfer to GL process after all validation and checking are done and run this process when we feel no more modification are needed

List of Process type that can be rolled back in PF K RUP1

  • Advance Pay Element
  • Balance Adjustment
  • Bank or Post office Payment
  • Batch element entry
  • cheque writer
  • Costing
  • Costing of Payment
  • Estimate costing
  • ext/Manual Payment
  • Magnetic report
  • Magnetic Transfer
  • Pre-Payments
  • Purge
  • QuickPay Pre-Payment
  • Quick Pay run
  • Report Generator
  • Retro Costing
  • Retro Pay
  • Retro Pay by Action
  • Retro Pay by element
  • Reversal
  • Run
  • Transfer to GL
  • Void Payment

Rolling Back a Process from the Payroll Processes Window

Use the Payroll Processes window when you want to roll back a process for a few individuals.

To roll back a process from the Payroll Processes window:

  1. Select the process record.
  2. Select Delete Record from the Edit menu.

Rolling Back a Process from the Submit Requests Window

Use the Submit Requests window when you want to roll back a process for many employees. If you do not want to roll back the process for all employees originally processed, you must create an assignment set. See: Creating an Assignment Set.

To roll back a process from the Submit Requests window:

  1. In the Name field, do one of the following:
      • Select Rollback to roll back all processes except a payroll run.
      • Select Rollback Run to roll back a payroll run.
      • Mexico only: Select Rollback MX Payroll Processes.
  1. If the Parameters box does not appear, click in the Parameters field.
  2. Select the process to roll back. The list for Rollback displays processing dates with the corresponding process types, payrolls, and consolidation sets. The list for Rollback Run displays process run dates with the corresponding period dates and payrolls.
  3. To roll back processing for an assignment set, select the set name.
  4. Choose Submit.

Rolling Back a Process from the Assignment Processes Window

Use the Assignment Processes window when you want to roll back a process for an individual employee assignment.

To roll back an assignment process:

  1. Select the record for the assignment process.
  2. Choose Delete Record from the Edit menu.

Source of the Information(Copied)

SQL plus executing a sql file in Corresponding Path

sql-plus-executing-a-sql-file-in-path

I had a problem to run the script file in the server.

After then I have done some search and then I got how to run.

So first define the path of the file located in a variable. Im taking as dir

now execute the command as shown in screenshot

define dir=”E:\prod\prodappl\per\11.5.0\sql”
@&dir\hr_analyzer.sql