My Oracle Support Banner

Variable Inheritance Is Not Working For Agent Action 'For Each' (Doc ID 1267394.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.1.0 and later
Information in this document applies to any platform.


An agent assigns a variable and then uses the "FOR EACH" to raise a second agent. The variable assigned in the first agent is attempted to be used, but is found to be undefined from the second agent.

The documentation of the FOR EACH agent action says that it should generate a child event for each result of the saved query creating a relationship parent/child where the variables of the parent are visible and accessible by the child.

1. Navigate to Shipment Management -> Shipment Management -> Buy Shipment
2. Search for Shipment
3. Edit the shipment and change the Shipment Name (e..g add a character)
4. Click Finished

The modification to the Shipment triggers the shipment agent. This will set the variable to the Shipment_Gid and trigger the second agent. This variable is then attempted to be used, but is undefined and results in:

2010-10-05 17:51:38.579 93816 Error Exception Named bind variable $3_2123686281_VAR not defined in: update order_release set ORDER_RELEASE_NAME = '$3_2123686281_VAR' where order_release_gid = $gid

It is expected that the variable maintains the assigned value for the downline agent


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.