EBS Customizations (MOSC)

MOSC Banner

Expected CHAR got NUMBER

Hi,

I'm getting an error (ORA-00932: inconsistent datatypes: expected CHAR got NUMBER) from the formula below. Which part of this formula is expecting a CHAR?

--------------------------------------------------

select paf.assignment_id asg_id, ppf.person_id


  ,(ppf.last_name||' '||ppf.suffix||', '||ppf.first_name||' '|| ppf.middle_names) emp_name


  ,addr.address_line1||' '||addr.ADD_INFORMATION13 ||' '||addr.ADD_INFORMATION14 ||' '||addr.address_line2||' '||addr.address_line3||' '||addr.town_or_city||', '|| addr.region_1 || ' ' ||addr.postal_code emp_addr


  ,hou.name office


  ,hla.address_line_1||' '||hla.address_line_2||' '||hla.address_line_3||' '||hla.town_or_city|| ', ' || hla.region_1 office_addr

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