Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Saturday, February 16, 2013

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

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete