Compile Form fmb and pll files in Oracle Apps R12

Commands to be used to compile Form plls and Form fmbs in Oracle apps :-

Form FMB Compile :-

Place fmb file in AU top (It could be custom top where you keep your custom fmb files based on your organization standards)

Command :-
frmcmp_batch userid=apps/apps_pwd module=$AU_TOP/forms/US/MY_FILE.fmb output_file=$AU_TOP/forms/US/MY_FILE.fmx module_type=form batch=yes compile_all=special


Form PLL Compile :-

Place fmb file in AU top (It could be custom top where you keep your custom pll files based on your organization standards)

Command:-
frmcmp_batch module=$AU_TOP/resource/CUSTOM.pll userid=apps/apps_pwd output_file=$AU_TOP/resource/CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special

Oracle Syatem Profile setup at different levels

Query to find out a specific profile setup at different levels :-

In the query below I have taken standard profile 'FND: Debug Log Enabled', you can change it accordingly for the profile you want to check.

Pass user profile name in the query.

Query :- 

SELECT po.profile_option_name "NAME",org.name name1,
pot.USER_PROFILE_OPTION_NAME,
        decode(to_char(pov.level_id),
               '10001', 'SITE',
               '10002', 'APP',
               '10003', 'RESP',
               '10005', 'SERVER',
               '10006', 'ORG',
               '10004', 'USER', '???') "LEV",
        decode(to_char(pov.level_id),
               '10001', '',
               '10002', app.application_short_name,
               '10003', rsp.responsibility_key,
               '10005', svr.node_name,
               '10006', org.name,
               '10004', usr.user_name,
               '???') "CONTEXT",
        pov.profile_option_value "VALUE"
FROM   apps.FND_PROFILE_OPTIONS po,
        apps.fnd_profile_options_tl pot,
        apps.FND_PROFILE_OPTION_VALUES pov,
        apps.fnd_user usr,
        apps.fnd_application app,
        apps.fnd_responsibility rsp,
        apps.fnd_nodes svr,
        apps.hr_all_organization_units org
WHERE  pot.user_profile_option_name like 'FND: Debug Log Enabled'
and    po.profile_option_name = pot.profile_option_name
AND    pov.application_id = po.application_id
AND    pov.profile_option_id = po.profile_option_id
AND    usr.user_id (+) = pov.level_value
AND    rsp.application_id (+) = pov.level_value_application_id
AND    rsp.responsibility_id (+) = pov.level_value
AND    app.application_id (+) = pov.level_value
AND    svr.node_id (+) = pov.level_value
AND    org.organization_id (+) = pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE";


Output :- 

Feel free to ask questions :) 

How to create Concurrent Program in Oracle Applications

Below are simple steps to create

1. Executable
2. Concurrent program and then
3. Attach Concurrent Program with Request Group.

Login as Sysadmin or Application Developer

Create Executable :- 

Navigate to Concurrent > Executable.Define your executable as shown below.

Create Concurrent Program

• Navigate to concurrent program (CP) screen.
• Eneter Name for CP.Short Name should be same as short name of executable.(It's Best Practice).
• Check the enable check box.Select executable name from LOV.
• Select the output format for CP.

• Define Parameter. For each Parameter
  1.Select the Value Set .
  2.Default Type.
  3.Default value for Set
  4.Default Value.

• After Saving the Concurrent Program, Attach it with requied Request Set.
• Choose the group where you want to attach CP
• Add Concurent program