Banner Job fails with ERROR LOOKING UP PARM error

Document ID : KB000093000
Last Modified Date : 25/04/2018
Show Technical Document Details
Issue:
Banner Jobs fails to run. Logs files show the error: *ERROR* LOOKING UP PARM start ...ABORTING SQLCODE = 0000

No other information is provided about the error.
Cause:
Banner Job contains incompatible sql containing a "between" condition in a variable.

Its possible that other incompatible sql can trigger the same error.
Resolution:
Instead of using a sql "between" condition, use the sql ">= . . . <=" without the double quotes.