AOL Interview Questions

How can we delete a concurrent program which is already registered?

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.

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;

-------------------------------------------------------------------------------

What is the role of applsys and applsyspub

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.

or---------------------------------

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

Applsyspub is used for authentication by having read only views

-----------------------------------------------------------------

How to schedule the concurrent programs from back end(PL/SQL) -not from srs form.

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

------------------------------------------------------------------------------

How do I submit a share of requests from PL/SQL?

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

-----------------------------------------------------------------------

Table for independent value set

In which fnd table independent value set will be stored?

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

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

---------------------------------------------------------------------

How can I disabled and enabled the standard button's in Apps window?

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.

--------------------------------------------------------------------

How do you create calender value set?

All are known creating of date,number,varchar2 by using we can create lov's. Similar that can we create& attach calender.
OR_----------------------

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 the textfield.

Validate from list (property) : No

Key list val trigger of that field, --> calendar.show;

You will get the calendar LOV whenever you enter into that text field...!

OR----------------------------

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'.

---------------------------------------------------------------

What is the difference between organization id and master organization id?

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.
-------------------------------------------------------------------

What is us directory under any top?

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.
------------------------------------------------------------

How do I recover the responsibility in Apps if it is disabled?

Here is the API script which add the System Administrator responsibility through which you add the other responsibility.
DECLARE
CURSOR c1_cur IS SELECT u.user_name
          ,u.user_id,u.end_date,u.start_date,u.description
   FROM   fnd_user u
   WHERE  u.user_name IN ('subbarab')
   AND    (u.end_date IS NULL OR u.end_date = TO_DATE('31-dec-4712','dd-mon-yyyy'))
   ORDER  BY u.user_name;
    BEGIN
    FOR c1 IN c1_cur LOOP
     BEGIN
       fnd_user_pkg.addresp(username       => c1.user_name --varchar2,
                           ,resp_app       => 'SYSADMIN' --varchar2,
                           ,resp_key       => 'SYSTEM_ADMINISTRATOR' --varchar2,
                           ,security_group => 'STANDARD' --varchar2,
                           ,description    => c1.description --varchar2,
                           ,start_date     => sysdate --date,
                           ,end_date       => c1.end_date --date
             );
       dbms_output.put_line('Inserted '||c1.user_name);
       EXCEPTION
       WHEN OTHERS THEN
       dbms_output.put_line('ERROR '||c1.user_name|| SQLERRM);
      END;
     END LOOP;
     COMMIT;
    END;
/

OR---------------------

Go to system administrator responsibility > Security > Responsibility > Define > Give the particular responsibility name, query on it and then see the effective dates to field. If any date is there then that repsonsibility will expire on that date and if it is null then it will not expire on any date.
--------------------------------------------------------------------

What is the process of defining shipping parameters in om

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>> Shipping Parameters..

General:
========
Weight UOM Class : VOLUME
vOLUMEN uom cLASS :  volume
pERSENT Fill Basis: Quantity
Export Compliance Screening : Not Required -- as per requirement..

PICK RELEASE:
=============================================
Release Sequence Rule : Default: Order Number
Pick Slip Grouping Rule : Default: Order Number
Print Pick slip : At the End
Number of pick slip lines: null
Default Pick release document set : create Default rule
Default Stage Subinventory: org code
Autocreate Deliveries: Check
Auto Allocate: Check
Default Stage Locator: Stock locator
==============================================
Shipping Transaction:
Delivery

--------------------------------------------------

How do I open a form in query-only mode?

Navigate to the form functions form (application->function) query the particular form and add the parameter query_only=yes not all forms will accept this parameter however.

or-----------------------

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

--------------------------------------------------------------------

What is a concurrent program and a concurrent request set ?

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

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.

or-------------------------------

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 is a long-running, data-intensive task, such as posting a journal or generating a report.

A concurrent request is a request that you submit to run a concurrent program as a concurrent process.

A request set is a collection of reports and/or programs that you group together. You can submit the reports and/or programs in a request set all at once using a single transaction.

----------------------------------------------------------

How do I submit a concurrent request from PL/SQL?

we first need to initialise oracle applications session using fnd_global.apps_initialize(user_id,responsibility_id,application_responsibility_id) and then run fnd_request.submit_request

begin
fnd_global.apps_initialize(user_id,resp_id,appl_resp_id)
v_request_id := fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)
commit;
if v_request_id > 0 then
   dbms_output.put_line('Successfully submitted')
else
  dbms_output.put_line('Not Submitted');
end;
or------------------------------

Use fnd_request.Submit_request example: req_id := fnd_request.Submit_request('fnd', 'fndscaru'); note that this can only be called from a concurrent program see the coding standards for parameter details

-----------------------------------------------------

How do I check if multi-org is installed?

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.
----------------------------------------------------------------------------

How do I generate a message file (usaeng.Msb)?

Use: fndmdcmf applsys/pwd 0 y app usaeng where: applsys/pwd is the applsys user and password and app is the short name of the application (like PO or inv)
or-----------------------

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

--------------------------------------------------------------------

How do you attach Javascript to a menu ? When user clicks on a menu it should display simple message

------------------------------------------------

What is quick code? Why is it called a quick code?What is steps of defining a quick code?

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

--------------------------------------------------------------------------

Where do concurrent request log files and output files go?

The concurrent manager first looks for the environment variable $APPLCSF
If this is set, it creates a path using two other environment variables:
$APPLLOG and $APPLOUT
It places log files in $APPLCSF/$APPLLOG
Output files go in $APPLCSF/$APPLOUT
So for example, if you have this environment set:
$APPLCSF = /u01/appl/common
$APPLLOG = log
$APPLOUT = out
The concurrent manager will place log files in /u01/appl/common/log, and
output files in /u01/appl/common/out
Note that $APPLCSF must be a full, absolute path, and the other two are
directory names.
If $APPLCSF is not set, it places the files under the product top of the application associated with the request. So for example, a PO report would go under $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT
Logfiles go to: /u01/appl/po/9.0/log
Output files to: /u01/appl/po/9.0/out
Of course, all these directories must exist and have the correct permissions.
Note that all concurrent requests produce a log file, but not necessarily an output file.

or-----------------

The output of the command below is the answer
select LOGFILE_NAME, OUTFILE_NAME
from fnd_concurrent_requests

---------------------------------------------------------------------------------------------------------------------
 

How do I cancel a running concurrent request?

Navigate to the Concurrent Request Summary form
Select a request
In character, do a Quickpick on the Status column
You can select Cancel or Hold
In GUI, use the Cancel or Hold buttons
The Sysadmin responsibility can cancel or hold any running request

or-----------------------------

Please open below package & see the coments.
FND_REQUEST.submit_svc_ctl_request

----------------------------------------------------------------------------------------------------------------------

What so you mean by Hierarchical and non Hierarchical security type in value set?

Hierarchical maodel means there is a relationship between the parent comapny and subsidaries and we have to acess the inter company transactions also.Non Hiererchical Model contains the same thing but here there is parent child have not any relationship segments/lines . if we want to apply intercompany transactions we may use these two models in valuset creation.

------------------------------------------------------------------------------------------------------------------

How can i implement and manage the custom schema?

basically a schema is collection of objects(tables, views, indexes,sequences) belonging to particular user, here in case of Oracle apps every module is implemented as a user for example Order Management is implemented as a user ONT, so to create a custom schema, we need to create a user and register the user with AOL.

 check this link for step by step process to create a custom module(Application)  and register with oracle AOL.
http://www.exforsys.com/content/view/1463/342/

 ------------------------------------------------------------------------------

What is '$flex$ and '$profile$, What is the use of '$flex$'?

$Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .

 For Ex .  $Flex$.  would return the value held by that valueset .
  $profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment.
  Ex.  $profiles$.org_id would return the operating unit which is active at that time for the user.

  --------------------------------------------------------------------

Why does Help->Tools->Examine ask for a password?

The profile option Utilities:Diagnostics is set to NO
This profile option controls whether users can use the Examine utility.
The password should be the APPS password.
------------------------------------------------------------

How can I change in custom.pll? After changes how can I send on the server and what's effect in this condition?

 

1. FTP  the Custom.pll from $AU_TOP/resource
2. Open the Custom.pll in Forms6i
3. Include the following code for your Form logic :
 begin
     Form_Name varchar2(50) := name_in('system.current_form');
     If Form_Name = 'YOUR CUSTOM FORM" then
    begin   
    include your logic   
    end;
 end;
 4. Once changes over , using the following command to generate the CUSTOM.plx 
f60gen module=CUSTOM.pll userid=apps/apps@mfgdev module_type=LIBRARY
to generate the latest CUSTOM.plx and move this CUSTOM.plx to $AU_TOP/resource

---------------------------------------------------------------------------------------------------------

How do I find the name of a form?

GUI: Use Help->About Oracle Applications
Scroll down to find the form name
Character: Use Help->Version
-------------------------------------------------------------------

How do I find the version of an installed product? (such as Reports, SQL*Net etc.)

One of the easiest ways is to run the product if you can. Running Reports designer will give you the Reports version, running SQL*Plus will give you its version etc.
Another easy way is to launch the Oracle Installer and look in the installed products on the right side. It will list all the products installed with their versions.
Another way is to look at the .rgs file. This file is located in $ORACLE_HOME/orainst
On UNIX, it will be called unix.rgs. On the PC, it will be called Windows.rgs.
This file will list all the products installed and their versions. Note though that
this file is not always correct. For example, patching Reports from 2.5.5.4 to 2.5.5.8 will not show up in this file as the new version. Running Reports Designer is the best way of getting the correct version.
Also, on UNIX there is an executable called 'inspdver'. It is located in $ORACLE_HOME/orainst.
Running it will produce a display of all the installed products. It just pulls the information from unix.rgs, so it may show the wrong information as well. 

---------------------------------------------------------