Substitution Variables and Replacement Values do not resolve in Banner Login Override field

Document ID : KB000084691
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ErrorMsg: AwE-5001 Database Query Error (1/1/17 12:00 AM)
Details: ORA-20035: Could not find "Db login --Test_Login@{agent}"
ORA-06512: at "APPMGR.AWAPI2", line 477

The RA Banner Login Override field accepts Substitution Variables and Replacement Values as noted in the documentation referenced below. The {agent} Replacement Variable is commonly used in this field to dynamically select the connection object. After upgrading to Applications Manager version 9.2.0, the RA Banner Login Override field no longer resolves Substitution Variables and Replacement Values.

Attempting to use an {agent} Replacement Variable will throw a Database Query Error stating that the login could not be found. The full error message below shows that the Replacement Value {agent} is not evaluated.

 
ErrorMsg: AwE-5001 Database Query Error (1/1/17 12:00 AM)
Details: ORA-20035: Could not find "Db login --Test_Login@{agent}"
ORA-06512: at "APPMGR.AWAPI2", line 477
ORA-06512: at "APPMGR.AWAPI2", line 450
ORA-06512: at "APPMGR.AWAPI", line 112
ORA-06512: at "APPMGR.AWAPI", line 1128
ORA-06512: at "APPMGR.AWAPI", line 1246
ORA-06512: at line 1

Reference

RA Banner – Agent Guide 3.6:
Working with Jobs > Introduction to Working with Jobs
 
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Bug caused by another fix made in AM 9.2.0
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Applications Manager 9.2.1 - Available
Additional Information:
Workaround :
  1. Revert to Applications Manger 9.1.3 or below.
OR
  1. Avoid using Substitution Variables and Replacement Values in the Banner Login Override field.