Receivables - EBS (MOSC)

MOSC Banner

Error 'Column url must have a value' in api hz_contact_point_v2pub.create_contact_point

edited Jan 30, 2020 6:31AM in Receivables - EBS (MOSC) 12 commentsAnswered ✓

hi

i am getting error 'Column url' must have a value when i am creating new contact with communication type as 'Email/Web' for ship to site for customer.

l_contact_point_rec.contact_point_type    := 'WEB';

l_contact_point_rec.contact_point_purpose := 'NULL';

l_contact_point_rec.owner_table_name      := 'HZ_PARTIES';     

l_contact_point_rec.owner_table_id        := l_party_id;        

l_contact_point_rec.created_by_module     := c_createdby;       

l_contact_point_rec.primary_flag        := c_no;

l_contact_point_rec.status := 'I';

l_email_rec_type.email_format             := 'MAILHTML';

l_email_rec_type.email_address            := p_email;

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