My Oracle Support Banner

'PSP: Create Distribution Lines' Error: 'APP-PAY-06881: Error ORA-01086: savepoint 'A' never established in this session or is invalid' and PA_NEW_TXNS_NOT_ALLOWED (Doc ID 2494745.1)

Last updated on APRIL 23, 2020

Applies to:

Oracle Labor Distribution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PSP: Create Distribution Lines failed with error.  Checked element entries for the employee that is failing and there are multiple retro entries.

ERRORS
-----------------------
APP-PAY-06881: Error ORA-01086: savepoint 'A' never established in this session or is invalid
has occurred in table pyarpchk at location 1608

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1118
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 1118
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 1118
ORA-06512: at line 3

The program failed with the following error :
The process failed in Validating POETA of Suspense Account for Organization : [Org name] and failed with the error PA_NEW_TXNS_NOT_ALLOWED while distributing for [Employee name]. Please fix the problem and re-submit the process.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PSP: Create Distribution Lines - Process ended with Errors
2. Rollback PSP: Create Distribution Lines
3. Check Organization Suspense Accounts setup and found out the default Project that was being used was already invalid
4. End dated the old default project and inserted a new record with the new default project
5. Re-Run PSP: Create Distribution Lines - same error appears
6. Checked element entries for the employee that is failing and there are multiple retro entries.


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.