Different types of Costing in Oracle Payroll

Different types of costing in Oracle Payroll

When you define oracle element link; you can select element costing type

- Not costed

Means no costing will be done for that particular element

- Fixed Costed

In Fixed Costed  you can not override at Element entry and assignment level costing segments.

- Costed

Costing will follow the normal costing hierarchy.

- Distributed

If you want to distribute the overhead costing to the other elements.

Oracle Payroll Costing hierarchy

Oracle Payroll Costing Hierarchy

In oracle payroll costing can be set at 5 levels with below priority order.

- Payroll                    = Lowest

- Element Link

- Organization

- Assignment

- Element Entry        = Highest

Batch Balance Adjustment

Batch Balance Adjustment

If your responsibility is not having ‘Batch Balance Adjustment’ function then add the 3 functions to your menu as shown below.

Functions Name:

-          Batch Balance Adjustment Spreadsheet Interface

-          Create or Update Batch Balance Adjustment Lines

-          Desktop Integration - Create Document

      Double click on ‘BBA Spreadsheet Interface’

k      Click on the ‘Create Batch’ button

       

It will create WEB ADI document, enter the details as below and then upload the document.

The Batch will be created.

Search the batch as shown below.

Select the batch, select create lines in the drop down and click on process button.

Select the element that you want to use for balance adjustment.

Then click on go button.

It will create a new WEB ADI document; enter the details shown as below and upload the document.

Then validate and transfer the batch.

Important Tables in HRMS

Important Tables in HRMS

person details

• per_all_people_f

Assignment details

• per_all_assignments_f

person type details 

• per_person_types
• per_person_type_usages_f

Termination details

• per_periods_of_service

Person SIT

• per_person_analyses
• per_analysis_criteria

Person EIT

• per_people_extra_info

HR Locations

• hr_locations_all

HR Organizations

• hr_all_organization_units

HR Jobs

• per_jobs
• per_job_definitions

HR Grades

• per_grades
• per_grade_definitions

HR Positions

• hr_all_positions_f
• per_position_definitions

People Group

• pay_people_groups

Employee address

• per_addresses

Employee Phones

• per_phones

Employee Qualifications

• per_qualifications

Employee Contracts

• per_contracts_f

Organization additional information / organization classification/ organization eit details

• hr_organization_information

All self service transaction details are stored in the below tables.

For all hr transactions

- hr_api_transactions
- hr_api_transaction_steps
- hr_api_transaction_values

for payroll related transactions, e.g. salary change

- per_pay_transactions

=====================================================

History tables for SSHR transactions

PQH_SS_TRANSACTION_HISTORY
PQH_SS_STEP_HISTORY
PQH_SS_VALUE_HISTORY
PQH_SS_APPROVAL_HISTORY        

======================================================


You can use above all tables in AME for tracking the self service transactions.

you can use transaction_id of hr_api_transactions and per_pay_transactions in  AME test workbench to see the attributes values, approvals , rules.

Join these tables with wf_notifications to identify status of the transaction.

P11D in UK payroll

P11D :

Your employer sends a P11D to HM Revenue & Customs (HMRC) if you get any ‘benefits in kind’ (eg company cars or interest-free loans).

The P11D records how much each benefit is worth.

Your employer will send HMRC a P11D if your earnings, including the value of company benefits, are at least £8,500 in the tax year (6 April to 5 April).


Your employer will usually give you a copy of the P11D. They don’t have to by law, but they must tell you what’s on it.

P60 in Uk payroll

P60:

Your P60 shows the tax you’ve paid on your salary in the tax year (6 April to 5 April). Your employer must give you a P60 if you’re working for them on 5 April.

You’ll need your P60 to prove how much tax you’ve paid on your salary, eg:

- to claim back overpaid tax

- to apply for tax credits

- as proof of your income if you apply for a loan or a mortgage

Your P60 can be on paper or electronic.

P45 for in Payroll

P45 :
               
-  Employee will get a P45 from your employer when you stop working for them.

-  Your P45 shows how much tax you’ve paid on your salary so far in the tax year (6 April to 5    April).

-  A P45 has 4 parts (Part 1, Part 1A, Part 2 and Part 3).

-  Your employer sends Part 1 to HM Revenue & Customs (HMRC) and gives you the other         parts.

-  You give Part 2 and 3 to your new employer (or to Jobcentre Plus if you’re not working).

-  Keep Part 1A for your own records.

-  By law your employer must give you a P45 - ask them for one.

-  You won’t have a P45 if you’re starting your first job or you’re taking on a second job. Your    employer will need to work out how much tax you should be paying on your salary.

-  They may use a ‘Starter Checklist’ to collect the information, or may collect it another way.      The Starter Checklist has questions about any other jobs, benefits or student loans you          have. It helps your employer work out your correct tax code before your first payday.