Downloading the proper patch of Jdeveloper for OAF version

Once you have determined the version of OAF you have as explained here, Search Oralce support(Metalink)  for Note ID 416708.1 to determine the suitable patch for your Jdeveloper version.

Note that the patch itself is a Jdeveloper copy with OAF extensions.

You wont need anything else for starting your OAF development.

Determining the version of OAF (Oracle Application Framework)

In any OAF self service page click on the “About this Page” link. This should be on the bottom left of the page.

Click on the “Technology Components” tab and this should give you all the details of the OA Framework version.

Oracle Applications - API to quickly reset application password

API to quickly reset Oracle applications password

declare
x boolean;
begin
 x:=fnd_user_pkg.changepassword('user_name','welcome@123');
end;

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