OAE Jobs using Subvars fail with LAUNCH ERROR or DB-ERROR after switch to Oracle Advanced Queuing

Document ID : KB000103104
Last Modified Date : 21/08/2018
Show Technical Document Details
Issue:
After upgrading to v9.2.x and switching to use Oracle Advanced Queuing with an ID other than the APPS user, Subvars with the APPS Login assigned to them fail. Jobs utilizing them go to LAUNCH ERROR or DB-ERROR depending on how the Subvar is used.

 
Resolution:
Re-create the Login object used in the Subvar and switch it Login Type from OAE to ORACLE.