Setting Defined Parameters for SRS Program Jobs in OEBS throws an exception: java.sql.SQLException: (ErrorCode 17041) (SQLState 99999)

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
java.sql.SQLException: (ErrorCode 17041) (SQLState 99999) SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = :$FLEX$.XLA_SRS_SUBLEDGERS

Setting Defined Parameters for SRS Program Jobs throws an exception:
 

Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
Caused by: java.sql.SQLException: (ErrorCode 17041) (SQLState 99999) SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = :$FLEX$.XLA_SRS_SUBLEDGERS

<Please see attached file for image>

 

Cause

Cause type:
By design
Root Cause: As designed functionality. SQL from the OEBS database may need to be edited before it can be used for parameters.

Environment

OS Version: N/A

Resolution

This SQL is meant to run from within the Oracle EBS forms (when a user runs the job from Oracle EBS itself).

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
Do not use custom SQL statements within the "Defined Parameters" section.
Use the "Populate Values" button instead.