PSP: Create Distribution Lines Errors HR_6881_HRPROC_ORA_ERR pyarpchk APP-PAY-06881 INVALID_PA_DATE (Doc ID 549170.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Labor Distribution - Version 11.5.9 and later
Information in this document applies to any platform.
PSP: Create Distribution Lines

***Checked for relevance 21-JUN-2014***

Symptoms

When running the following process ...
PYUSLV module: Payroll Worker Process
... receive the following error:


PL/SQL Output
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01086: savepoint 'A' never established

SQL_NO 1608
TABLE_NAME pyarpchk
APP-PAY-06881: Error ORA-01086: savepoint 'A' never established
has occurred in table pyarpchk at location 1608

Cause: an oracle error has occurred. The failure was reported on table pyarpchk at
location 1608 with the error text ORA-01086: savepoint 'A' never established
.

Action: Please contact your support representative.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1114
ORA-06512: at line 3

SQL_NO 1609
TABLE_NAME pay_archive.process_chunk
APP-PAY-06881: Error ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1114
ORA-06512: at line 3
has occurred in table pay_archive.process_chunk at location 1609

Cause: an oracle error has occurred. The failure was reported on table
pay_archive.process_chunk at location 1609 with the error text ORA-06510: PL/SQL: unhandled
user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1114
ORA-06512: at line 3
.

Action: Please contact your support representative.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
The program failed with the following error :
The process failed in Validating POETA of Suspense Account for Organization : Payroll and failed
with the error INVALID_PA_DATE while distributing for Coleman, Alvin L.. Please fix the problem
and re-submit the process.
0 batches successfully distributed
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Concurrent program returned no reason for failure.




.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms