Setting Defined Parameters for SRS Program Jobs in OEBS throws an exception: java.sql.SQLException: (ErrorCode 17041) (SQLState 99999)
book
Article ID: 88137
calendar_today
Updated On:
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.