Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need subject area to retrieve accounts and contacts based on territory owner

Received Response
21
Views
5
Comments

@Need subject area to retrieve accounts and contacts based on territory owner

Required Fields:

  1. Customer Profile
  2. Account Custom Field
  3. Contact Name
  4. Contact Custom field
  5. Territory owner

My approach but I failed to achieved

Subject Area: sales – CRM Sales Account Territories

Subject Area: Sales Customer and contact real time

Columns:

  1. Customer.Customer Profile
  2. Customer.Customer type
  3. Customer.Customer Row ID
  4. Contact.Contact ID
  5. Territory.Territory Owner
  6. Territory.Territory Owner ID
  7. Contact.Last Interaction Date

Result:

Display Error

Regards

MD Hyder

Answers