Script to transfer a notification in Oracle Workflow

Below anonymous script can be used to transfer the notification ownership from person x to y

BEGIN

   wf_notification.transfer (17515872,          -- notification id to transfer

                             '1000012008', -- role to whom the notification is to be transferred

                             'Transferring as requested by z from x to y' -- Transfer comment

                                                                         );

END;

Oracle Applications - Query to get incompatible programs

SELECT fat.APPLICATION_NAME,

         fctl.user_concurrent_program_name,

         DECODE (TO_RUN_TYPE, 'S', 'Set', 'Program') TYPE,

         DECODE (INCOMPATIBILITY_TYPE, 'G', 'Global', 'Domain')

            "Incompatibilty Type"

    FROM FND_CONCURRENT_PROGRAM_SERIAL fcrs,

         FND_CONCURRENT_PROGRAMS_TL fctl,

         FND_APPLICATION_TL fat

   WHERE     fcrs.RUNNING_APPLICATION_ID = fat.application_id

         AND (RUNNING_CONCURRENT_PROGRAM_ID = 32045) -- CP id of the program in question

         AND fctl.CONCURRENT_PROGRAM_ID = fcrs.TO_RUN_CONCURRENT_PROGRAM_ID

         AND fctl.LANGUAGE = 'US'

         AND fat.LANGUAGE = 'US'

ORDER BY to_run_application_id, to_run_concurrent_program_id;

Forms Error : bad bind variable 'PARAMETER.G_QUERY_FIND'

When compiling a form the following error may be encountered :


Compiling KEY-NXTBLK trigger on XXXXXXX data block...
Compilation error on KEY-NXTBLK trigger on XXXXXXX  data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on XXXXXXX data block...
Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger on XXXXXXX data block:
PL/SQL ERROR 49 at line 3, column 2
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 2
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 5, column 2
bad bind variable 'parameter.G_query_find'

.

.

.

.

Compilation errors have occurred.

Form not created

**********************

Cause : FORMS60_PATH not properly set or incorrect

Solution: Set FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

In your shell simply execute

FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

This should solve the problem