My Oracle Support Banner

Audit Report Concurrent Request is Long Running in HRMS Production (Doc ID 2634611.1)

Last updated on MARCH 02, 2020

Applies to:

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

Symptoms

Audit Report(PAYAUDIT) fails with the following error is seen or the request takes time.

ERROR
-----------------------
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp018:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-01555: snapshot too old: rollback segment number 311 with name "_SYSSMU311_2554311702$" too small

 

Costly Statement:




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Submit Audit Report
2. It's failing with above mentioned errors or the request takes time to complete.



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.