ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
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>
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.