Variable Inheritance Is Not Working For Agent Action 'For Each'
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Transportation Management - Version: 6.1.0
Information in this document applies to any platform.
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
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