My Oracle Support Banner

Quick Pay Failed With ORA-01403 ORA-06512 in PEPTOEXC.ASG_PTO_HD_YTD_EC (Doc ID 2612376.1)

Last updated on JULY 07, 2020

Applies to:

Oracle Payroll - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

Payroll run completed with below error for an employee

ERROR

APP-PAY-51118: Error was encountered when processing assignment <assignment number>
TABLE_NAME PEPTOEXC.ASG_PTO_HD_YTD_EC
APP-PAY-06881: Error ORA-01403: no data found
ORA-06512: at "APPS.PEPTOEXC", line <line number>
ORA-06512: at line <line number>
has occurred in table PEPTOEXC.ASG_PTO_HD_YTD_EC at location <location number>

Cause: an oracle error has occurred. The failure was reported on table PEPTOEXC.ASG_PTO_HD_YTD_EC at location <location number> with the error text ORA-01403: no data found

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility: US Super HRMS Manager

2. Navigation: Submit Process & Reports > Run Payroll

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.