Oracle 11i Application Developer – Technical FAQ

Q1       In which FND table independent value set will be stored?

A 1              FND_FLEX_VALUES and FND_FLEX_VALUES_TL

 Q2       How to schedule the concurrent programs from Back end(PLSQL) -not from SRS form.

A2            fnd.request.submit_request( Concurrent_program_name,  application_short_name,  description,  parameters)

Use FND_REQUEST.SUBMIT_REQUEST

Example: req_id := FND_REQUEST.SUBMIT_REQUEST(‘FND’, ‘FNDSCARU’);    Fnd_request.submit_request can be called from any valid EBS session (initialized by fnd_global.apps_initialize)

  Q3       Where do concurrent request log files and output files go?

A3       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 

 Q4       How do I cancel a running concurrent request?           

A4            Navigate to the Concurrent Request Summary form

Select a request

In GUI, use the Cancel buttons

The Sysadmin responsibility can cancel any running request  , If you cancel a running request be aware that the backend process continues. See this good forum discussion for details: http://forums.oracle.com/forums/thread.jspa?threadID=832725&tstart=0                       

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

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

 Q6       How do I check if Multi-org is installed?          

A6            SELECT multi_org_flag FROM fnd_product_groups;          

  Q7       How do I find the name of a form?    

A7       GUI: Use Help->About Oracle Applications

Scroll down to find the form name

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

A8            Navigate to the Form Functions form (Application->Function)    Query the particular form and add the parameter QUERY_ONLY=YES

 go to applcation developer responsibility

navigation->Application/function.

query the function name

then goto form tab

then goto parameters field

then write the following code QUERY_YES=”YES”

save the changes and then see the forms get affected in query only mode.

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

Follow the following steps inorder to make a form as Query only/Read Only.

1. Login into the System Administrator/Application Developer responsibility.
2. Navigate to ‘Security -> Responsibility -> Define’
3. Query for the responsibility for which you want to make the form as ‘Query Only’ and copy the ‘Menu’ name.
4. Navigate to ‘Application -> Menu’ and query with the menu name which we got in step 3 in ‘User Menu Name’
5. Now look out for the form (Prompt) you want to make it as query only. Copy the value in the ‘Function’ field w.r.t the form that needs to be made as ‘Query Only’.
6. Navigate to ‘Application -> Funtion’ and query with the function name we got in Step 5 in ‘User Function Name’ field.
7. Identify the correct Function for your form and then naviagate to the ‘Form’ tab.
8. Enter the value: QUERY_ONLY=YES in the parameters section in the Form tab, if you already have another value existing in the parameter form then you need to seperate them with a space..

Example: MODE=”PROJECT” QUERY_ONLY=YES

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

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

A9       1. FTP  the Custom.pll from $AU_TOP/resource

2. Open the Custom.pll in 11i or earlier

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

 Q10     What is ‘$flex$ and ‘$profile$, What is the use of ‘$flex$’

A10         $Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object . they used within Forms, value sets.

 For Ex .  $Flex$.<Valueset name>  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