My Oracle Support Banner

NOTIFY INVOLVED PARTY Agent Action for a REPORT Agent Not Finding Contacts and Therefore no Report Sent (Doc ID 1262591.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.1.0 to 6.1.3 [Release 6.1]
Information in this document applies to any platform.


An REPORT agent is configured with actoin NOTIFY INVOLVED PARTY. This agent action should search for attached Involved Parties on the Shipment, Order Release, Invoice, etc...

When this agent action is doing this search for contacts, it is using the REPORT_LOG_PARAMETER in the SQL Query. However, there are not entries in this table and therefore the SQL query returns no contacts and no notification is done.

Expect Notification to involved parties to be sent

The issue can be reproduced at will with the following steps:

1. Create the following Agents:

a) An Agent to Create the Report upon triggered actions
b) An Agent to Send the report upon creation and to use the action NOTIFY INVOLVED PARTY

3. Trigger  the above to force the report creation/delivery
4. Review the generated log, and you will notice the agent could not find an involved party associated to the Report object as expected




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.