Incorrect SQL Object Identifier in the AWE Process (Route for Approval)

Dear All,

We are using the AWE process and it is working properly. Using the Generic Template and SQL Object Identifier to send the email communication to Approvers, incase in Route for Approval event.

The email is picking the wrong values from the record. Bind variables are correct, but the values fetched are wrong. Eg: We raised the approval process for User A with Approval ID as : 123, the email is showing for User C with Approval ID : 456.

The SQL object identifier is having the same key structure as per the record defined in the transaction registry component (under Transaction Approval Levels). All required fields are listed in the SQL definition and generic template, including the cross-reference record.