Audit Report On Table PQP_VEHICLE_ALLOCATIONS_F Fails with REP-1401 Error

(Doc ID 1912577.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

On :  12.1 HRMS RUP6 version, Core HR - General

Audit report on table PQP_VEHICLE_ALLOCATIONS_F fails with following error :

ERROR
-----------------------

REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-01422: exact fetch returns more than requested number of rows

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp002:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-01422: exact fetch returns more than requested number of rows

 

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

A.To enable Audit on PQP_VEHICLE_ALLOCATIONS_F
1.Responsibility : System Administrator>AuditTrail> Tables
2. Add  few columns under Table - PQP_VEHICLE_ALLOCATIONS_F
3.Responsibility : System Administrator>AuditTrail>Groups
4.Under Application -Human Resource, create  Custom Group and added above table:Run AuditTrail Update Tables and AuditTrail Report for Audit Group Validation

B.To reproduce the issue
Responsibility : US Super HRMS Manager
1. Navigation : Run Audit Report
2. enter parameter : table : PQP_VEHICLE_ALLOCATIONS_F


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