APP-FND-01564: ORACLE error 6553 in FDFGDF
OS: RHEL 5.7
DB: 11.2.0.3
EBS: 12.1.3
Error:
APP-FND-01564: ORACLE error 6553 in FDFGDF
Cause: FDFGDF failed due to ORA-06553: PLS-307: too many declarations of 'DATE_TO_DISPLAYDT' match this call.
The SQL statement being executed at the time of the error was: SELECT SUBSTR(FND_DATE.DATE_TO_DISPLAYDT(TO_DATE(HR_SA_HIJRAH_FUNCTIONS.HIJRAH_TO_GREGORIAN(:a1), 'YYYY/MM/DD'),NULL),1,LENGTH(FND_DATE.DATE_TO_DISPLAYDT(TO_DATE(HR_SA_HIJRAH_FUNCTIONS.HIJRAH_TO_GREGORIAN(:a2), 'YYYY/MM/DD'),NULL))-9) FROM DUAL and was executed from the file &ERRFILE.
Problem Description:
The error is received in HRMS, when I open an employee Additional Information form and try entering the Iqama Date in Hijri.