Retrieve Employee Salary History in EBiz

SELECT
  employee_number,
  proposed_salary_n,
  from_date,
  CASE
    WHEN
      to_date IS NULL 
    THEN
      to_date('31-dec-4712') 
    ELSE
      to_date 
  END
  xx 
FROM
  (
    SELECT
      a.employee_number,
      c.proposed_salary_n,
      c.change_date from_date,
      (
        LEAD (c.change_date, 1) OVER (PARTITION BY a.employee_number 
      ORDER BY
        c.change_date)
      )
       - 1 to_date 
    FROM
      per_all_people_f a,
      per_all_assignments_f b,
      per_pay_proposals c 
    WHERE
      1 = 1 
      AND sysdate BETWEEN a.effective_start_date AND a.effective_end_date 
      AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date 
      AND a.person_id = b.person_id    --and a.employee_number = '001'
      AND b.assignment_id = c.assignment_id 
    ORDER BY
      a.employee_number,
      c.change_date
  )
GROUP BY
  employee_number,
  proposed_salary_n,
  from_date,
  to_date 
ORDER BY
  1,
  3;

PMS Doc Id and My Learnings

Doc Id's:

Appraisee Update Action Link From The Notification Results into an Error Page (Doc ID 2047250.1)

Information Center: EBS Performance Management (All Application Versions) (Doc ID 1297851.2)

How to Enable Personalization link for OAF Pages?

To enable Personalization, Set the Profile

Profile Name	Value
FND: Personalization Region Link Enabled	Yes
Personalize Self-Service Defn	Yes
Disable Self-Service Personal	No

Query to retrieve Payroll Run Details for Staff's

/* This Query used to retrieve the Run Result Values for a Single Element or Group of Elements.We can use it for Querying the Information Element also Change the details Accordingly. Eg: How Employee paid by an Element in a Period*/

SELECT ppa.effective_date P_Date,

  papf.employee_number EMP_No,

  papf.person_id PersonID,

  papf.full_name EMP_NAME,

  petf.element_name ElementName,

  pivf.NAME INNAME,

  prrv.result_value VResult

FROM per_all_people_f papf,

  per_all_assignments_f paaf,

  pay_input_values_f pivf,

  pay_run_results prr,

  pay_run_result_values prrv,

  pay_assignment_actions paa,

  pay_payroll_actions ppa,

  pay_element_types_f petf,

  pay_element_classifications pec,

  per_time_periods ptp,

  pay_all_payrolls_f papsf

WHERE papf.person_id         = paaf.person_id

AND pivf.input_value_id      = prrv.input_value_id

AND prr.run_result_id        = prrv.run_result_id

AND paa.assignment_id        = paaf.assignment_id

AND paa.assignment_action_id = prr.assignment_action_id

AND paa.payroll_action_id    = ppa.payroll_action_id

AND pec.classification_id    = petf.classification_id

AND prr.element_type_id      = petf.element_type_id

AND ptp.time_period_id       = ppa.time_period_id

  --AND paaf.business_group_id=9112

AND pec.classification_name IN ('Earnings', 'Involuntary Deductions', 'Involuntary Deductions', 'Pre Social Insurance Deductions', 'Pre-Tax Deductions', 'Tax Deductions', 'Voluntary Deductions', 'Voluntary Deductions', 'Information')

AND ppa.action_type         IN ('R', 'Q')

AND papsf.payroll_id         = paaf.payroll_id

  -- and papf.person_id = 1477

AND ppa.date_earned BETWEEN papsf.effective_start_date AND papsf.effective_end_date

AND ppa.date_earned BETWEEN papf.effective_start_date AND papf.effective_end_date

AND ppa.date_earned BETWEEN paaf.effective_start_date AND paaf.effective_end_date

AND ppa.date_earned BETWEEN pivf.effective_start_date AND pivf.effective_end_date

AND ppa.date_earned BETWEEN petf.effective_start_date AND petf.effective_end_date

AND pivf.NAME = 'Pay Value'  /* Add Input Values if needed*/

AND petf.element_name IN ('Basic Salary')  /* Add Elements if needed*/

  --AND TO_CHAR (ppa.effective_date, 'MON-YYYY') = 'MAR-2016'

AND ppa.effective_date BETWEEN '01-JAN-2016' AND '31-OCT-2016';

Vacation Rule in Oracle EBiz

Objective:

• Add Vacation Rule option to User to Set up Vacation Rule for Others.

Step 1:

• Create Custom Menu

1. Routing Rules Administrator
2. Create Routing Rule
3. Update Routing Rule

Step 2:

• Create Custom Responsibility and add the EC Workflow Administrator Menu.

Step 3:

• Go to “Workflow Administrator Web Applications”
• Administrator Workflow > Administration > Select EC Workflow Administrator > Apply

Step 4:

• Add the Responsibility to the User.

Note:

1. Only an Administrator can create Vacation Rule for others. We can set Vacation Rule through the “Workflow Administrator Web Applications” responsibility. 
2. Workflow System Administrator may be a SYSADMIN, Workflow Administrator (Web Admin).
3. Usually SYSADMIN Login have the System administrator and Workflow Administrator Role.
4. If we want to give this rights to Other User, we have to give Admin rights to the User.
5. Workflow System Administrator is EC Workflow Administrator, then a User who holds EC Workflow Administrator can access the Vacation Rule (Set up for Others).
6. Workflow System Administrator is System Administrator, then a User should hold System Administrator Role access the Vacation Rule (Set up for Others).
7. Workflow System Administrator is Workflow Administrator, then a User should hold Workflow Administrator Role access the Vacation Rule (Set up for Others).