Issue with bursting an analytic report through agent

User_SI7HK

Hi, we are using OAS 7.0, OBIA 7964, EBS 12.2.1 with Oracle 19c db on Linux platform. We are able to send an analytic report using agent to dynamic list of recipients using the (Agent > Recipient > Use Analysis (Get Recipients from the Analysis Used in the Agent Condition) check box and selecting the column in it as "User Name" (which for us is Initcapfirstname.Initcaplastname). And it works fine, as expected (it sends the report to all users picked up in the "User Name" column of the report, dynamically at run-time). There is one more Check Box in this section for "Only Return Rows Relevant to the User Running the Agent", which we checked expecting it would only send a subset of the report with rows specific to recipient "User Name" only (not the entire report to everyone), which it tried and we got an email saying "No Result" The specified criteria didn't result . .. .. (standard text) and filter showing that the agent tried to filter the report (by adding the criteria) and User Name is equal to JOHN.SMITH, john.smith (one upper and one lower), which failed, as we have "User Name" stored as Initcapfirstname.Initcaplastname (i.e. John.Smith)

(The issue can be quickly replicated in an instance using the "Usage Tracking" (or any other) subject area, that has "User Name" attribute). Any tips to resolve this issue is highly appreciated.

Jerry Casey

My quick workaround would be to create a 2nd user name column, containing UPPER(user name) and match on that. It can be hidden in your actual report, if I'm remembering correctly.

User_SI7HK

Hi Jerry, it worked. Thanks for your help, much appreciated.