1.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.
select LOGFILE_NAME, OUTFILE_NAME
from fnd_concurrent_requests
_____________________________________________________________________________________
2.What are the logfile and output file naming conventions?
Logfiles: l.req
Output files: If $APPCPNAM is not set: .
If $APPCPNAM = REQID: o.out
If $APPCPNAM = USER: .out
Where: = The request id of the concurrent request
And: = The id of the user that submitted the request
Log file get following name by default: lRequest_id.req
and Output file get following name by default : oRequest_id.out
Output files are stored at $APPLCSF/$APPLOUT
and Log files are stored at $APPLCSF/log
These paths may vary depending on the setups that sys admins perform at the time of Oracle Apps installation
_____________________________________________________________________________________
3.How do I check if Multi-org is installed?
SELECT multi_org_flag FROM fnd_product_groups;
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to 'Y', Then its Multi Org.
run adadmin, if you see the Multi-org convertion option, then you are not on Multi-org yet. If you can not see it, then you are.
BUSINESSGROUPS->LEGALENTITEIS->SETOFBOOKS->OPERATINGUNIT->INVENTORYORGANIZATION
____________________________________________________________________________________
4.How do I find out what the currently installed release of Applications is?
SELECT release_name FROM fnd_product_groups
We can also find out through Help > About Oracle Applications
SELECT * FROM FND_PRODUCT_INIT_CONDITION
_____________________________________________________________________________________
5.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
GUI: Use Help->About Oracle Applications
Scroll down to find the form name in Current Form
_____________________________________________________________________________________
6.How do I lookup ORA errors? (and TNS errors)
Use: oerr ora XXXX
or: oerr tns XXXX
where XXXX is the error number
(This also supports a number of other error types. Use the 3-letter error prefix in place of 'ora')
_____________________________________________________________________________________
7.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)
_____________________________________________________________________________________
8.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)
use adadmin
It can be generated through submission of Concurrent Program from Application Developer responsibility.
_____________________________________________________________________________________
9.How do I submit a concurrent request from PL/SQL?
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
-------------------------------------------------
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;
------------------------------------------------------------
FND_REQUEST.SUBMIT_REQUEST ( 'Application Name', 'Report Short name', '', '', FALSE, 'R', -- P_report_type '', -- P_agent_name_num '', -- P_po_num_from '', -- P_po_num_to '', -- P_release_num_from '', -- P_release_num_to '', -- P_date_from '', -- P_date_to '', -- P_approved_flag '', -- P_test_flag 'Y', -- P_print_releases '', -- P_sort_by v_user_id, -- P_user_id '2', -- P_qty_precision 'Y', -- P_fax_enable NAME_IN('FAX.FAX_FAX_NUMBER'), -- P_fax_num 'Y', -- P_CANCEL_LINE 'N', -- P_BLANKET_LINES '','','','', -- 22 '', '', '', '', '', '', '', '', '', '', --32 '', '', '', '', '', '', '', '', '', '', --42 '', '', '', '', '', '', '', '', '', '', --52 '', '', '', '', '', '', '', '', '', '', --62 '', '', '', '', '', '', '', '', '', '', --72 '', '', '', '', '', '', '', '', '', '', --82 '', '', '', '', '', '', '', '', '', '', --92 '', '', '', '', '', '', '', '');
-------------------------------------------------------------------------------
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;
------------------------------------------------
If one want to submit the conc req from backend (from OS), use CONCSUB utility.
FIRST WEHAVE TO START SESSION WITH APPS
APPS.INTIALIZE(RESP_ID,USER_ID,ORG_ID);
-- U CAN FIND THIS IN MENU HELP DIGNASTICTS EXAMINE LOGIN FROM USER
begin
v_request_id := fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)
commit;
if v_request_id > 0 then
dbms_output.put_line('Successfully submitted'V_REQUEST_ID)
else
dbms_output.put_line('Not Submitted');
end;
_____________________________________________________________________________________
10.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
FND_REQUEST.submit_svc_ctl_request
_____________________________________________________________________________________
11.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.
Navigate to the Update System Profile Screen.
(\ navigate profile system)
- Select Level: Site
- Query up Utilities:Diagnostics in the User Profile Options Zone.
If the profile option Utilities:Diagnostics is set to NO, people with access to the Utilities Menu must enter the password for the ORACLE ID of the current responsibility to use Examine. If set to Yes, a password will not be required.
_____________________________________________________________________________________
12.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.
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.
_____________________________________________________________________________________
13.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.
RPM -qa grep sql . RPM -qa will list the pakages installed.
_____________________________________________________________________________________
14.How do I generate one single form? (As opposed to using adadmin to generate them all)
Character mode forms: Use adfrmgen
Usage : adfrmgen filelist=
or : adfrmgen product="product shortname(s)" [filepath="dir-path/filename"]
For example :
adfrmgen filelist=filelist.txt
adfrmgen product="gl" filepath="forms/GLXSSMTY.inp" (one file)
adfrmgen product="gl" filepath="forms" (entire directory)
adfrmgen product="gl" (entire product)
adfrmgen product="fnd gl" (multiple products)
adfrmgen product="fnd gl" filepath="forms" (entire directories from multiple products)
GUI forms: use f45gen
Usage : f45gen module= userid=
output_file= module_type=form batch=yes compile_all=special
Example:
f45gen module=/u16/appl/nca/au/1.0/forms/US/FNDCPMCP.fmb userid=APPS_APPDEMO/APPS
output_file=/u16/appl/nca/fnd/7.5/forms/US/FNDCPMCP.fmx
module_type=form batch=yes compile_all=special
Note that in Release 11, adadmin will allow you to compile specific forms
_____________________________________________________________________________________
15.What should I do if I am missing an executable from my APPL_TOP?
Binary executables are created with adrelink.
For example, if addmimp is missing use:
adrelink force=y ranlib=y "ad addmimp"
Simply display the error(request status ERROR) , object name and path in the logfile.
NOTE : Before submitting any request(s), required executable(s) to be trasfered(FTP) in their corresponding TOPs thru UNIX.
relink the particular module ,eg :if FNDLOAD is missing then relink FND module
_____________________________________________________________________________________
16.How do i recover the responsibility in apps if it is disabled?
If your responsibility is end dated then ask the apps dba to remove the date from Effective Date (To) field.
From FND_RESPONSIBILTY table. Query the table for the reponsiblity u need.The column to query is responsiblity_key. If there is a end_date and the end_date <> SYSDATEAND FND_RESPONSIBILITY_VL.RESPONSIBILITY_ID = FND_RESPONSIBILITY.RESPONSIBILITY_ID;
update the end_date fields for your responsibilities (query by ID in the fnd_responsibility table).
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.
Please run the following concurrent program
Workflow Directory Services User/Role Validation
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;
/
____________________________________________________________________________________
17.How can i disabled and enabled the standard button's in apps window?
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.
_____________________________________________________________________________________
18.I have run a request but it is not completed. His status is (running normal) and those requests are giving after this he will be completed.So,now what steps I have to follow for the running request?
give it some more time. Did you ensure that you had run immediately checked when you submitted the report/request? If it was accidentally scheduled for a later date/time, the best thing you can do is to submit it again, with correct parameters.
sometimes the long rum willl come because of the table locks. Check is there any locks ,then remove the locks and resubmit the program.
You might have submitted the request when network traffice is peak.
So try to submitt the request when network traffice less, Suggested to submit at night time
_____________________________________________________________________________________
19.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
____________________________________________________________________________________
20.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.
_____________________________________________________________________________________
21.What is '$flex$ and '$profile$, What is the use of '$flex$'?
The syntax for both is,$flex$.value set name- It is used to retrieve the value used in previous value set and generally used in Table type value set$profile$.profile option name- It is used to retrive value for that profile option
$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.
_____________________________________________________________________________________
22.What is quick code? Why is it called a quick code?What is steps of defining a quick code?
quick code is that where we can hurry up the process of getting services and extended warranties quickly.
Quick Code or Lookup Code are short names given to some field values. an example is two letter codes given to Country names.
_____________________________________________________________________________________
23.What is the difference between organization id and master organization id?
Master organization id is a legal entity on which yearly reporting done it is a level 2 in multi-org str and organization-id is a organization unit under master organization, it is just a sale's unit,inventory unit etc...it is on level 3 in multi org str.
In simple wordsOrg_id referes the operating unit and and organization id refers the Inventory Organization
Org id is used to pick particular organization(legal Entity)Â in multiorg implementation.
organizationid is used to pick particular inventory which are defined under itemmaster inturn which is under business group (Legal entity level).
_____________________________________________________________________________________
24.What so you mean by Hierarchical and non Hierarchical security type in value set?
You define a security rule element by specifying a value range that includes both a low and high value for your segment. A security rule element applies to all segment values included in the value range you specify.
You identify each security rule element as either Include or Exclude, where Include includes all values in the specified range, and Exclude excludes all values in the specified range. Every rule must have at least one Include rule element, since a rule automatically excludes all values unless you specifically include them. Exclude rule elements override Include rule elements.
You should always include any default values you use in your segments or dependent value sets. If the default value is secured, the flexfield window erases it from the segment as the window opens, and the user must enter a value manually.
This comes into picture when security rule comes into picture.
For example Say Maintanance is the one of the accounts, in that we have cleaning, painting expenses, when we are not accesssible to main a/c (i.e maintanance) we cannot use sub a/c i.e cleaning and painting when you select Hierarchical security, when it is non-Hierarchical we can use sub a/c i.e painting, cleaning etc...
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.
_____________________________________________________________________________________
25.What is US directory under any TOP?
The US directory is for the US English Language.People who use French put the code in F and Arabic language code for forms and reports etc is kept in AR directory
This directory contain code related to base language which is US english
US indicates the localization done for a specific country.
US means for English Language standard.In Apps Under every module we have US folder that means we are working in english language.
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.
_____________________________________________________________________________________
26.How do you attach javascript to a menu ? When user clicks on a menu it should display simple message
_____________________________________________________________________________________
27.What is a concurrent program and a concurrent request set ?
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.
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.
_____________________________________________________________________________________
28.How can we delete a Concurrent Program which is already registered?
You can either enable or disable a concurrent program.
fnd_request.delete_request
_____________________________________________________________________________________
29.What is the role of applsys and applsyspub
All the technical products' database objects are consolidated into a single schema called Applsys
Applsyspub is used for authentication by having read only views
_____________________________________________________________________________________
30.Define Shipping Parameters
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
_____________________________________________________________________________________
