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>

 

Environment

OS Version: N/A

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.

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.