Variable Inheritance Is Not Working For Agent Action 'For Each'
(Doc ID 1267394.1)
Last updated on MAY 06, 2022
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