Human Capital Management - EBS (MOSC)

MOSC Banner

APP-FND-01564: ORACLE error 6553 in FDFGDF

edited May 17, 2013 10:45PM in Human Capital Management - EBS (MOSC) 19 commentsAnswered ✓
 Environment:

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center