Query to find all incompatibilities between programs in oracle application:-

SELECT A2.APPLICATION_NAME, A1.USER_CONCURRENT_PROGRAM_NAME,

       DECODE (RUNNING_TYPE,

               'P', 'Program',

               'S', 'Request set',

               'UNKNOWN'

              ) "Type",

       B2.APPLICATION_NAME "Incompatible App",

       B1.USER_CONCURRENT_PROGRAM_NAME "Incompatible_Prog",

       DECODE (TO_RUN_TYPE,

               'P', 'Program',

               'S', 'Request set',

               'UNKNOWN'

              ) INCOMPATIBLE_TYPE

  FROM APPS.FND_CONCURRENT_PROGRAM_SERIAL CPS,

       APPS.FND_CONCURRENT_PROGRAMS_TL A1,

       APPS.FND_CONCURRENT_PROGRAMS_TL B1,

       APPS.FND_APPLICATION_TL A2,

       APPS.FND_APPLICATION_TL B2

 WHERE A1.APPLICATION_ID = CPS.RUNNING_APPLICATION_ID

   AND A1.CONCURRENT_PROGRAM_ID = CPS.RUNNING_CONCURRENT_PROGRAM_ID

   AND A2.APPLICATION_ID = CPS.RUNNING_APPLICATION_ID

   AND B1.APPLICATION_ID = CPS.TO_RUN_APPLICATION_ID

   AND B1.CONCURRENT_PROGRAM_ID = CPS.TO_RUN_CONCURRENT_PROGRAM_ID

   AND B2.APPLICATION_ID = CPS.TO_RUN_APPLICATION_ID;

   AND A1.LANGUAGE = 'US'

   AND A2.LANGUAGE = 'US'

   AND B1.LANGUAGE = 'US'

   AND B2.LANGUAGE = 'US'