Re: FNDSM down

Posted by ErmanArslansOracleBlog on Jun 27, 2024; 11:03am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/FNDSM-down-tp12580p12586.html

Interesting.

This is a standard routine and the query gets 01007  , which is due to "a reference was made to a variable not listed in the SELECT clause of the statement."

Failing query: SELECT DISTINCT NODE_NAME, DB_INSTANCE   FROM FND_CONCURRENT_PROCESSES  WHERE PROCESS_STATUS_CODE = 'Z'    AND MANAGER_TYPE < 6    AND LAST_UPDATE_DATE > SYSDATE - (4 * :pmon_secs)/86400   AND NODE_NAME IS NOT NULL   AND DB_INSTANCE IS NOT NULL

The error is probably due to :pmon_secs

These things ((4 * :pmon_secs)/86400) are hardcoded in the standard code. So, SR should resolve this.

1)Does that happen only once? Or does it happen time to time?
2)ORA-03106 seems like a result, but I m not quite sure.. What about patch levels? Both APPS side and DB Side?