Technology Stack - EBS (MOSC)

MOSC Banner

APP-FND-01564: Oracle error 1406 in FDFGCD

edited Aug 20, 2021 10:56AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

Please help me resolve this error. I know it is happening because of the fetch value is larger than what it can hold but how to resolve this?

Background on error: Error in HR Form

The SQL statement being executed at the time of the error

SELECT enabled_flag,

  summary_flag,

  NVL(TO_CHAR(start_date_active,'J'),0),

  NVL(TO_CHAR(end_date_active,'J'),0),

  segment1,

  segment2,

  segment3,

  job_definition_id

FROM per_job_definitions

WHERE id_flex_num     = :num

AND job_definition_id = :id;

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