im using below query to update CU165_HR_APPR_LIMITS end_date_active field to fnd_user table end_date.
but im getting this error
SQL Error: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
00932. 00000 - "inconsistent datatypes: expected %s got %s".
can someone provide me the solution for this.
UPDATE CU165_HR_APPR_LIMITS hral
SET end_date_active = (SELECT fu.user_id FROM fnd_user fu
where fu.user_id = HRAL.person_id
AND (fu.end_date <= SYSDATE OR fu.end_date IS NOT NULL));