My Oracle Support Banner

KR HRMS - Errors Occurred in KR Simple Earning Report Archive Process (Doc ID 2565765.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle HRMS (Republic of Korea) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

This issue is occurred after applying Patch.29608324

Reproducible step is following :

  1. Log in to KR HRMS Responsibility.
  2. Run  KR Simple Earnings Report Archive program.
  3. Completes with errors.

Errors are :

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Cause:        an oracle error has occurred.  The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3

Changes

 

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
Changes
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.