Technology Stack - EBS (MOSC)

MOSC Banner

R12 HZ_RELATIONSHIPS seems not be updated after delete AR contact

edited Aug 20, 2021 10:57AM in Technology Stack - EBS (MOSC) Question

Hi everyone.

I'm currently trying to obtain list of email for customers.

Email are defined at several levels.

(besides, if someone has a ready-made sql, I 'm interested. The data model is particularly complex with the TCA

On BILL_TO site (for example), you have the choice between create an email on "communication" tab, or create a contact, that he has an email too.

In my request, i use hz_contact_points and hz_relationships to link BILL_TO site with created contact.

In my differents tests, i created 2 contacts on one BILL_TO site. My request brings me 2 lines, with contacts informations => that's correct.

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