Error APP-FND-01564: ORACLE error 1422 in FDFGVD When Try To Enter Parameters To Run Social Security Affiliation Report

(Doc ID 1916197.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle HRMS (Mexico) - Version 12.1 HRMS RUP7 to 12.2 HRMS RUP4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Payroll - General

When attempting to enter parameters to run Social Security Affiliation Report
the following error occurs.

ERROR
-----------------------
APP-FND-01564: ORACLE error 1422 in FDFGVD

Cause: FDFGVD failed due to ORA-01422: exact fetch returns more than requested number of rows.

The SQL statement being executed at the time of the error was: SELECT TO_CHAR(SYSDATE, 'YYYY/MM/DD')
  || ' 00:00:00',
  HOUTL.NAME VALUE,
  TO_CHAR(HOI.ORGANIZATION_ID) DESCRIPTION,
  NVL('N', 'N'),
  NVL(TO_NUMBER(NULL), -1),
  NULL,
  NVL('Y', 'Y'),
  NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0),
  NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0)
FROM PER_MX_GRES_LEGAL_EMPLOYER_V PMGL,
  HR_ORGANIZATION_INFORMATION HOI,
  HR_ORGANIZATION_INFORMATION HOI1,
  HR_ALL_ORGANIZATION_UNITS_TL HOUTL
WHERE ( PMGL.TAX_UNIT_ID         = FND_NUMBER.NUMBER_TO_CANONICAL(HOI.ORGANIZATION_ID)
AND HOI.ORGANIZATION_ID          = HOI1.ORGANIZATION_ID
AND HOI.ORGANIZATION_ID          = HOUTL.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT  = 'CLASS'
AND HOI.ORG_INFORMATION1         = 'HR_LEGAL'
AND HOI.ORG_INFORMATION2         = 'Y'
AND HOI1.ORG_INFORMATION_CONTEXT = 'MX_SOC_SEC_DETAILS'
AND HOI1.ORG_INFORMATION3        = 'Y'
AND HOUTL.LANGUAGE               = USERENV('LANG')
AND PMGL.BUSINESS_GROUP_ID       = :b1
AND PMGL.LEGAL_EMPLOYER_ID       = FND_NUMBER.NUMBER_TO_CANONICAL(:b2) )
AND TO_CHAR(SYSDATE, 'YYYY/MM/DD')
  || ' 00:00:00' = :X
AND was executed
FROM the file
  &ERRFILE.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Mexico HRMS Manager navigate Processes and Reports - Submit Report - Single Request - select Social Security Affiliation Report
  Enter a Legal Employer with more than 1 GRE' s
  Legal Employer: <Enter LE>
  Transmiter GRE: <Enter GRE>
         see error


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