AOL Interview Questions

We can delete the Concurrent Program from Back End.

begin
FND_PROGRAM.delete_executable(executable_short_name=>xxexe,application=>XXMZ Custom);
commit;
end;

begin
FND_PROGRAM.DELETE_PROGRAM(program_short_name=>XXCONC,application=>XXMZ Custom);
commit;
end;

From front end we can not delete the concurrent program. We can only enable or disable the program.
We can delete the concurrent program from back end.

fnd_program.delete_program('Short Name', 'Application');
fnd_program.delete_executable('Short Name', 'Application');

Regards,

Sunil Kaswan

Applsys Schema : Consists of files starts with FND, ALR, WF and AD.

Applsyshub Schema : Contains a collection of all public synonyms of all FND Tables, which are used for user verification.

All the technical products' database objects are consolidated into a single schema called Applsys

Applsyspub is used for authentication by having read only views

We also can able to submit from back end by using API called 'fnd_request.submit_request',it consist following
program,Description,arguments .Before this we must initialize by using fnd_apps.global_intialize

You can try FND_REQUEST.SET_REPEAT_OPTIONS to run at specific times

we can submit 2 or more programs from backend by using below FND

FND_CONCURRENT.WAIT_FOR_REQUEST

if we need to submit 2 or more programs serieally
we need to submit from back end by using below FND

FND_CONCURRENT.WAIT_FOR_REQUEST

The name of the table where value set stores:-
1) fnd_flex_value_sets

The name of the table where values stores:
2) fnd_flex_values
3) fnd_flex_values_tl

Regards,

Sunil Kaswan

If you want the base table where the name of the value set is stored then it is
FND_FLEX_VALUE_SETS.

Forms personalization is the best way to enable and disable the standard button's in apps window. The other option is using by logical apps rules.

You can do this with Custom.pll and if ur using apps version greater that 11.5.9 then you can do this with form personlization too.Gajanan

Field must be DATE type.
In the KEY_LIST_VAL trigger you must add the code:
CALENDAR.SHOW;

In the properties of the field, you should set "Validate from List" to 'No'.

We can do this in Apps Forms.Prerequisite: We need to load all the predefined plls for example, APPDAYPK for calendars.Once we have all the dll's required, Assign the key list lamb LOV to th...

If the enterprise has a multi org structure then it would have a Master org and inv/child orgs. All items should have an entry in Master org before they can be assigned to inventory orgs. The items in...

Whenever an item receives in an operating unit then it will receive in master orgnization id only after that we assigns the items to take different orgnization ids. Therefore there must be an unique master orgnization id and can be multiple orgnization ids with in an operating unit.

US directory is one directory for save the reports or forms or programs to be used in US language, if you want to use Spanish language option you should save the programs in ESA directory. It mea...

Forms and reports directories contains the language directories,

Means which language apps is using, apps supports multiple languages.

US is the standard language used by Oracle.

vinod.

Here is the API script which add the System Administrator responsibility through which you add the other responsibility.DECLARECURSOR c1_cur IS SELECT u.user_name      &n...

Please run the following concurrent program

Workflow Directory Services User/Role Validation

This is detail about Shipping Parameters..for OM.. The below details are breifly descripb u.. If any clarifications plz.. go to India Local Order Management>> Shipping>> Setup>>...

go to applcation developer responsibilitynavigation->Application/function.query the function name then goto form tab then goto parameters field then write the following code in that fieldQUERY_YES="YES"save the changes and then see the forms get affected in query only mode.

Concurrent program is nothing but instance of execution file along with parameters and incompatabilities.

By using concurrent request set we can submit multiple programs at a time through srs window.

after creation of request set we can attach it to request group.

A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing your hardware capacity. Typically, a concurrent program i...

Hi Usha,If you wanna find out the USER_ID, ORG_ID, RESP_ID, RESP_APPL_ID, connect to the system and open any window and flow the below mentiioned navigation to find the values..Help -> Diagnostics ...

I am not able to see the userid or org-id going to the home page of applications under the help menu.  There is no diagnostics menu at all when I expand it...I don't know where to see it atll.

Thanks,

Usha

SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS

y --THIS IS MULTIORG INSTALLED
n--MULTIORGNOT INSTALEED

BUSINESSGROUPS->LEGALENTITEIS->SETOFBOOKS->OPERATINGUNIT->INVENTORYORGANIZATION

U can check whether  Multi - org is installed or not by using following query.

Select multi_org_flag from fnd_product_groups ;

If the result is

' Y ' then it is set to be multi - org.

' N ' then it is not set to be multi - org.

Cheers,

Bonthu.

It can be generated through submission of Concurrent Program from Application Developer responsibility.

use adadmin

Quick Code or Lookup Code are short names given to some field values. an example is two letter codes given to Country names.

quick code is that where we can hurry up the process of getting services and extended warranties quickly.

surya

The output of the command below is the answer

select LOGFILE_NAME, OUTFILE_NAME

from fnd_concurrent_requests

Saurabh

Hindalco

solution is good at the beginnner level .  
 
can be still more infromative

Please open below package & see the coments.