Teleservice - EBS (MOSC)

MOSC Banner

R12 - customer profile > Drill Down

edited Nov 23, 2011 11:25AM in Teleservice - EBS (MOSC) 12 commentsAnswered
We have the following profile variable setup but when we call up the variable to map the drill down we get "FRM-40831: Truncation Occurred: Value too long for field ALIAS_NAME"

Any way around this?

SELECT count(ps.attribute1)+count(ps.attribute2)+count(ps.attribute3)

FROM hz_party_sites ps,

          (SELECT distinct person_id FROM per_all_people_f) A,

          (SELECT distinct person_id FROM per_all_people_f) b,

          (SELECT distinct person_id FROM per_all_people_f) c

Where ps.party_id = :party_id

AND ps.party_site_id = :party_site_id

AND ps.attribute1 = A.person_id (+)

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

EBS Teleservice Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center