Fusion Applications OTBI(OBIEE): Problem With BI Delivers/Agent - Email Delivery , When generating recipients from a second analysis (Doc ID 1684271.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Common CRM Cloud Service - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion CRM BI Delivers.

It works fine when recipients are not based on an analysis
However, when I had a recipients based on the employee.employee email address column , I receive an error message and nothing is delivered.

UNEXPECTED BEHAVIOR
-------------------------------------------
OBIEE "test agent" > Recipient Name :email address     Use Analysis > "Get Recipients from the Analysis Used in the Agent Condition" is CHECKED, Analysis is "Users for agent"

Settings > Columns Containing Recipients: Employee Email Address ("Sales - CRM Pipeline". Email address and Employee login are used in the analysis which gathers the Recipients list)

Result:

Agent Completed with warnings
eventually succeeded but encountered and resolved errors...
  Number of skipped recipients: 0 of 1

AgentId: ....
Invalid subscribers skipped: email address

Notes: This functionality works when the option "Use Analysis > "Get Recipients from the Analysis Used in the Agent Condition" is UNCHECKED

and the recipient is explicitly defined in the "Select Recipients" box as the same email address

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms