An error message of "ORA-20997: trying to set so_module to null" can be see if the following is met:
When both of the above requirements are met, the Alias value resolves to a Null value. Applications Manager throws the ORA error because it is unable to set the Alias value to a Null value. Below is the full error message.
java.sql.SQLException: ORA-20999: Scheduling has encountered an exception - Scheduling will not continue until issue is resolved -
[ORA-20001: Submit_chains so_sch_seq=40145-[ORA-20997: trying to set so_module to null
ORA-06512: at "APPWORX.SQLOPER_SOJOBQUEUE", line 431
ORA-04088: error during execution of trigger 'APPWORX.SQLOPER_SOJOBQUEUE']
ORA-06512: at "APPWORX.SQLOPER_SOJOBQUEUE", line 431
ORA-06512: at "APPWORX.SCHEDULING", line 808
ORA-06512: at "APPWORX.SCHEDULING", line 808
ORA-06512: at "APPWORX.SCHEDULING", line 840
ORA-06512: at "APPWORX.SCHEDULING", line 840
ORA-06512: at "APPWORX.SCHEDULING", line 840
ORA-06512: at "APPWO]
ORA-06512: at "APPWORX.AW_TIMEZONES", line 2453
ORA-06512: at "APPWORX.AW_TIMEZONES", line 2177
ORA-06512: at "APPWORX.AW5", line 2272
ORA-06512: at "APPWORX.AW5", line 2276
ORA-06512: at line 1
Component : APPLICATIONS MANAGER
Can be resolved by one of the following: