My Oracle Support Banner

Error On Accessing/changing Assignment Screen In Sweden (SE) Business Group (Doc ID 2709000.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

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

Symptoms

While accessing/changing assignment screen in all records within the Sweden (SE) Business Group, seeing below error.

Error:
Error Message:- "APP-FND-01564: ORACLE error 1722 in FDFGVD

Cause: FDFGVD failed due to ORA-01722: invalid number.

The SQL statement being executed at the time of the error was: SELECT O1.ORGANIZATION_ID,O1.NAME VALUE, O1.NAME 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), HOI4.ORG_INFORMATION1||'-'||HOI5.ORG_INFORMATION1 "Y Number" FROM HR_ORGANIZATION_UNITS O1, HR_ORGANIZATION_INFORMATION HOI1,HR_ORGANIZATION_INFORMATION HOI2, HR_ORGANIZATION_INFORMATION HOI3 ,HR_ORGANIZATION_INFORMATION HOI4,HR_ORGANIZATION_INFORMATION HOI5 ,FND_SESSIONS S WHERE ( O1.BUSINESS_GROUP_ID =:b1 AND HOI1.ORGANIZATION_ID = O1.ORGANIZATION_ID AND HOI1.ORG_INFORMATION1 = 'FI_LOCAL_UNIT' AND HOI1.ORG_INFORMATION_CONTEXT = 'CLASS' AND NVL(HOI1.ORG_INFORMATION2,'N') = 'Y' AND O1.ORGANIZATION_ID = HOI2.ORG_INFORMATION1 AND HOI2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS' AND HOI2.ORGANIZATION_ID = HOI3.ORGANIZATION_ID AND HOI3.ORG_INFORMATION_CONTEXT='CLASS' AND HOI3.ORG_INFORMATION1 = 'HR_LEGAL_EMPLOYER' AND NVL(HOI3.ORG_INFORMATION2,'N') = 'Y' AND HOI4.ORGANIZATION_ID (+)= HOI2.ORGANIZATION_ID AND HOI4.ORG_INFORMATION_CONTEXT(+)='FI_LEGAL_EMPLOYER_DETAILS' AND HOI5.ORG_INFORMATION_CONTEXT(+)='FI_LOCAL_UNIT_DETAILS' AND HOI5.ORGANIZATION_ID (+) = O1.ORGANIZATION_ID AND S.SESSION_ID = USERENV('sessionid') AND S.EFFECTIVE_DATE BETWEEN O1.DATE_FROM AND NVL(O1.DATE_TO,TO_DATE('31/12/4712','DD/MM/YYYY')) ) AND O1.ORGANIZATION_ID = :X and was executed from the file &ERRFILE."


Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Select SE_HRMS Manager
2. Navigate to People > Enter and Maintain and select an active Employee.
3. Click to open Assignment form.
  - Above error fires.

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.