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

Document ID : KB000088137
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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


0EMb0000001UwtI.png


 
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.