Skip to main content

Error: (P02E) Inserting into LIVE TIMESHEET (PAYROLL) for person [PERSONNEL NUMBER] ORA-01403

This error typically occurs when generating timesheets in CoreTime on CorePay-enabled sites.

J
Written by James Pardy
Updated over 5 months ago

This error is triggered because one or more Pay Codes used in the timesheet are not configured in CorePay.

In CorePay-integrated systems, all Pay Codes must be set up in CorePay before they can be used in CoreTime. If a Pay Code exists in CoreTime but not in CorePay, the system cannot transfer the timesheet for payroll processing, resulting in this error.


You can resolve this issue in one of two ways:

Mark the Pay Code as Non-Payroll

If the Pay Code is not required for payroll transfer, you can mark it as Non-Payroll in CoreTime.


Configure the Pay Code in CorePay

If the Pay Code should transfer to payroll, follow these steps:

In CorePay:

  1. Navigate to CorePay

  2. Click Reference

  3. Find Pay Codes

  4. Configure the missing Pay Code.
    Make sure all relevant settings are completed.

In CoreTime:

  1. Use the outer List of Values (LOV) on the Pay Code screen to verify the CorePay configuration.

  2. Check the Pay Codes recorded for the employee specified in the error.

  3. Ensure that each Pay Code is present in CorePay and correctly linked to CoreTime.


Summary

Action

When to Use

Mark Pay Code as Non-Payroll

If the Pay Code is for tracking purposes only and does not require payroll transfer

Configure Pay Code in CorePay

If the Pay Code is for payroll and must be transferred

Did this answer your question?