AOL Interview Questions & Answers
=================================
1.Question :
------------
What is AUTO Accounting what are the steps for setting up auto accounting
Answers:
--------
Auto Accounting is a mechnism for generating defualt accounting flexfields for revenue , receivables, frieght and tax based on the other parameters associated with the invoice you are entering.. since auto accounting looks at the following tables to get the data so please set/define the following depending upon your requirement.
1.Salesrep.
2.Transaction Types.
3.Standard Lines.
4.Taxes.
5.Customer bill-to-site
2.Question :
------------
What are the standard concurent programs for auto invoice interface and customer interfaces
Answers:
--------
Autoinvoice Import Program -- for auto invoice program Customer Interface Master Conc Program --> for Customer Interface
3.Question :
------------
What do I do if I am missing an executable from my APPL_TOP?
Answers:
--------
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.
4.Question :
------------
How do I find the version of an installed product? (such as Reports, SQL*Net etc.)
Answers:
--------
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.
5.Question :
------------
Why does Help->Tools->Examine ask for a password?
Answers:
-------
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.
6.Question :
------------
How do I submit a concurrent request from PL/SQL?
Answers:
--------
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')
else
dbms_output.put_line('Not Submitted');
end;
7.Question :
------------
How do I generate a message file (usaeng.msb)?
Answers:
--------
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.Question :
------------
How do I find the name of a form?
Answers:
--------
GUI: Use Help->About Oracle Applications
Scroll down to find the form name in Current Form
9.Question :
------------
How do I find out what the currently installed release of Applications is?
Answers:
--------
Run the following Quey
SELECT * FROM FND_PRODUCT_INIT_CONDITION
Select * from FND_PRODUCT_INSTALLATIONS
&
Go to help -> About Oracle Applications. In Oracle Applications heading you will find the current version of application.
10.Question :
-------------
How do I check if Multi-org is installed?
Answers:
--------
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to 'Y', Then its Multi Org.
_all is shown us it is belongs to a mult org so if the file what appear in the column name having _all then you have it
11.Question :
-------------
What are the logfile and output file naming conventions?
Answers:
--------
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
12.Question :
-------------
Where do concurrent request logfiles and output files go?
Answers:
--------
The solutions provided are very informative and crisp . HIghly for beginners and for experts .
You can find the concurrent request logfiles in $APPLCSF/APPLLOG and the outfiles in $APPLCSF/APPLOUT
13.Question :
-------------
How do i recover the responsibility in apps if it is disabled?
Answers:
--------
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;
14.Question :
-------------
I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?
Answers:
--------
one case could be multiple upgrade scripts in the patch are there, and ad workers are running them parally , so when the first worker was upading the table and second one also gone for the update at the same time, in this case locking error will come.
To resolve this kind of issues patch should not contain different upgrade scripts for a single table ,all the upgrades should happen in the same file.
15.Question :
-------------
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 follow for the unning request?
Answers:
--------
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
The priority of the concurrent program can be set when defining the concurrent program in the Priority field.
&
Once again check the program what you attached to concurrent program, If the Loop or Report is having any technical problem then the Request is always showing like 'Running Normal'.
So checkt the Technical relating things in the attached program before submit the other Request.
16.Question :
-------------
How cam i changes in custom.pll? After changes how can i send on the server and what's effect in this condition?
Answers:
--------
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
17.Question :
-------------
How can i implementing and managing the custom schema?
please give me quick reply.
Answers:
--------
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.
Stept to Create Custom Applications are required if you are creating new forms, reports, etc.
This allows you to segregate your custom written files from the standard seeded functionality thatOracle Applications provide. Customizations can therefore be preserved when applying patches or upgrades to your environment. 1) Make the directory structure for your custom application files. cd $APPL_TOP mkdir fz mkdir fz/11.5.0 mkdir fz/11.5.0/admin mkdir fz/11.5.0/admin/sql mkdir fz/11.5.0/admin/odf mkdir fz/11.5.0/sql mkdir fz/11.5.0/bin mkdir fz/11.5.0/reports mkdir fz/11.5.0/reports/US mkdir fz/11.5.0/forms mkdir fz/11.5.0/forms/US mkdir fz/11.5.0/$APPLLIB mkdir fz/11.5.0/$APPLOUT mkdir fz/11.5.0/$APPLLOG 2) Add the custom module into the environmentApply ADX.E.1 and add the entry to topfile.txt as a standard product top entry . Customised environment variables can be added to AutoConfig by using the filename specificed by s_custom_file, which is then called from the APPSORA.env file. If using Forms Listener Servlet, you may also need to add $CUSTOM_TOP to formsservlet.ini in$APACHE_TOP/Jserv/etc 3) Create new tablespace for database objects create tablespace FZ datafile '/u01/oracle/visdata/fz.dbf' size 10M default storage(initial 10k next 10k)4) Create schema create user fz identified by fz default tablespace fz temporary tablespace temp quota unlimited on fz quota unlimited on temp; grant connect, resource to fz;5) Register your Oracle Schema. Login to Applications with System Administrator responsibility Navigate to Application-->Register Application = FZ Custom Short Name = FZ Basepath = FZ_TOP Description = FZ Custom Application6) Register Oracle User Naviate to Security-->Oracle-->Register Database User Name = FZ Password = FZ Privilege = Enabled Install Group = 0 Description = FZ Custom Application User7) Add Application to a Data Group Navigate to Security-->Oracle-->DataGroup Data Group = FZGroup Description = FZ Custom Data Group Click on "Copy Applications from" and pick Standard data Group, then add the following entry. Application = FZ Custom Oracle ID = APPS Description = FZ Custom Application Create custom request group This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility Navigate to Security-->responsbility-->Request Group = FZ Request Group Application = FZ Custom Code = FZ Description = FZ Custom Requests We will not define any requests to add to the group at this stage, but you can add some now if required.9) Create custom menu This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility. We will create two menus, one for Core Applications and one for Self Service. Navigate to Application-->Menu Menu = FZ_CUSTOM_MENU User Menu Name = FZ Custom Application Menu Type = <leave blank> Description = FZ Custom Application Menu Seq = 100 Prompt = View Requests Submenu = <leave blank> Function = View All Concurrent Requests Description = View Requests Seq = 110 Prompt = Run Requests Submenu = <leave blank> Function = Requests: Submit Description = Submit Requests Menu = FZ_CUSTOM_MENU_SSWA User Menu Name = FZ Custom Application SSWA Menu Type = <leave blank> Description = FZ Custom Application Menu for SSWA 10) Create new responsibility. One for Core Applications and One for Self Service (SSWA) Navigate to Security-->Responsibility-->Define Responsibility Name = FZ Custom Application = FZ Custom Responsibility Key = FZCUSTOM Description = FZ Custom Responsibility Available From = Oracle Applications Data Group Name = fzGroup Data Group Application = FZ Custom Menu = FZ Custom Application Request Group Name = FZ Request Group Responsibility Name = FZ Custom SSWA Application = FZ Custom Responsibility Key = FZCUSTOMSSWA Description = FZ Custom Responsibility SSWA Available From = Oracle Self Service Web Applications Data Group Name = fzGroup Data Group Application = FZ Custom Menu = FZ Custom Application SSWA Request Group Name = FZ Request Group11) Add responsibility to user Navigate to Security-->User-->Define Add FZ Custom responsibility to users as required.12) Other considerations You are now ready to create your database Objects, custom Reports, Forms, Packages, etcCreate the source code files in the FZ_TOP directory appropriate for the type of object. For example formswould be located in $FZ_TOP/forms/US or package source code in $FZ_TOP/admin/sql for example.Database Objects, such as tables, indexes and sequences should be created in the FZ schema, then you need to a) Grant all privilege from each custom data object to the APPS schema. For example : logged in as FZ user grant all privileges on myTable to apps; b) Create a synonym in APPS for each custom data object For example : logged in as APPS user create synonym myTable for fz.myTable;Other database objects, such as views and packages should be created directly in the APPS schema.
18.Question :
-------------
What is '$flex$ and '$profile$, Waht is the use of '$flex$'?
Answers:
--------
$Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .
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.
:$FLEX$
=======
:$Flex$.<valueset_name> is used to get the previous parameter value to the current parameter. And it is a reserved word.
Can be used at 2 locations in oracle applications.
1. Value set where/order by field.
If we want to select statement in application>validation>sets instead of tablename it should be select caluse and in parathesis.
eg: create a value set by name DPTNO datatype number(5)
validation type TABLE
click EDIT INFORMATION
in table place (select distinct deptno from emp)
create another value set by name JOB datatype CHAR(20)
validation type TABLE
click EDIT INFORMATION
table name (SELECT DISTINCT DEPTNO,JOB FROM EMP)
JOB CHAR 20
where/order by WHERE DEPTNO=:$FLEX$.DPTNO
and mention this valueset in the concurrent >program>define>parameter form.
2. Default value field in concurrent progrm form.
first create an value set of DTNO of Table validation type
click EDIT INFORMATION
at table name (SELECT DISTINCT DEPTNO FROM EMP)
in the concurrent>program>define>parameter form
you can even specify as
mention Parameter name as JOB
default type -SQL STATEMENT
default value - SELECT DISTINCT DEPTNO,JOB FROM EMP WHERE DEPTNO=:$FLEX$.DTNO
:$PROFILE$
==========
used to get current profile value to the current parameter.
1. Value set where/order by field.
create a value set by Name as
XX_ORG_ID
datatype CHAR(240)
validation type TABLE
click EDIT INFORMATION
table name HR_OPERATING_UNITS
table columns
NAME CHAR 240
ORGANIZATION_ID NUMBER 15
where/order by ORGANIZATION_ID= :$profiles$.org_id
and mention this valueset in the concurrent >program>define>parameter form.
2. Default value field in concurrent progrm form.
concurrent>program>define>parameter form
you can even specify as
mention Parameter name as P_ORG_ID
default type -SQL STATEMENT
default value - SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID=:$PROFILE$.ORG_ID
19.Question :
-------------
What is quick code? why is it called a quick code?
What is steps of defining a quick code?
Answers:
--------
Quick code is that where we can hurry up the process of getting services and extended warranties quickly.
The Quick codes are lookup codes that are defined for quick references and can be used to display exact meaning while on the front end. Example: the column Gender of your table may hold values M or F. this can be defined to have the meaning Male or Female in the Quick Codes. The quick code value is usually what gets displayed when you access the web pages
20.Question :
-------------
What is the difference between organization id and master organization id?
Answers:
--------
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.
both ids are related to inventory.
when new item is defined.first it needs to defined and assign in master organization id then child organization id.
normally inventory transactions are not done on master organization id.
21.Question :
-------------
What so you mean by Hierarchical and non Hierarchical security type in value set?
Answers:
--------
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.
22.Question :
-------------
What is US directory under any TOP?
Answers:
--------
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
As oracle apps is US based product. So, in all folders you will find US.
1.Question :
------------
What is AUTO Accounting what are the steps for setting up auto accounting
Answers:
--------
Auto Accounting is a mechnism for generating defualt accounting flexfields for revenue , receivables, frieght and tax based on the other parameters associated with the invoice you are entering.. since auto accounting looks at the following tables to get the data so please set/define the following depending upon your requirement.
1.Salesrep.
2.Transaction Types.
3.Standard Lines.
4.Taxes.
5.Customer bill-to-site
2.Question :
------------
What are the standard concurent programs for auto invoice interface and customer interfaces
Answers:
--------
Autoinvoice Import Program -- for auto invoice program Customer Interface Master Conc Program --> for Customer Interface
3.Question :
------------
What do I do if I am missing an executable from my APPL_TOP?
Answers:
--------
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.
4.Question :
------------
How do I find the version of an installed product? (such as Reports, SQL*Net etc.)
Answers:
--------
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.
5.Question :
------------
Why does Help->Tools->Examine ask for a password?
Answers:
-------
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.
6.Question :
------------
How do I submit a concurrent request from PL/SQL?
Answers:
--------
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')
else
dbms_output.put_line('Not Submitted');
end;
7.Question :
------------
How do I generate a message file (usaeng.msb)?
Answers:
--------
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.Question :
------------
How do I find the name of a form?
Answers:
--------
GUI: Use Help->About Oracle Applications
Scroll down to find the form name in Current Form
9.Question :
------------
How do I find out what the currently installed release of Applications is?
Answers:
--------
Run the following Quey
SELECT * FROM FND_PRODUCT_INIT_CONDITION
Select * from FND_PRODUCT_INSTALLATIONS
&
Go to help -> About Oracle Applications. In Oracle Applications heading you will find the current version of application.
10.Question :
-------------
How do I check if Multi-org is installed?
Answers:
--------
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to 'Y', Then its Multi Org.
_all is shown us it is belongs to a mult org so if the file what appear in the column name having _all then you have it
11.Question :
-------------
What are the logfile and output file naming conventions?
Answers:
--------
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
12.Question :
-------------
Where do concurrent request logfiles and output files go?
Answers:
--------
The solutions provided are very informative and crisp . HIghly for beginners and for experts .
You can find the concurrent request logfiles in $APPLCSF/APPLLOG and the outfiles in $APPLCSF/APPLOUT
13.Question :
-------------
How do i recover the responsibility in apps if it is disabled?
Answers:
--------
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;
14.Question :
-------------
I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?
Answers:
--------
one case could be multiple upgrade scripts in the patch are there, and ad workers are running them parally , so when the first worker was upading the table and second one also gone for the update at the same time, in this case locking error will come.
To resolve this kind of issues patch should not contain different upgrade scripts for a single table ,all the upgrades should happen in the same file.
15.Question :
-------------
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 follow for the unning request?
Answers:
--------
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
The priority of the concurrent program can be set when defining the concurrent program in the Priority field.
&
Once again check the program what you attached to concurrent program, If the Loop or Report is having any technical problem then the Request is always showing like 'Running Normal'.
So checkt the Technical relating things in the attached program before submit the other Request.
16.Question :
-------------
How cam i changes in custom.pll? After changes how can i send on the server and what's effect in this condition?
Answers:
--------
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
17.Question :
-------------
How can i implementing and managing the custom schema?
please give me quick reply.
Answers:
--------
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.
Stept to Create Custom Applications are required if you are creating new forms, reports, etc.
This allows you to segregate your custom written files from the standard seeded functionality thatOracle Applications provide. Customizations can therefore be preserved when applying patches or upgrades to your environment. 1) Make the directory structure for your custom application files. cd $APPL_TOP mkdir fz mkdir fz/11.5.0 mkdir fz/11.5.0/admin mkdir fz/11.5.0/admin/sql mkdir fz/11.5.0/admin/odf mkdir fz/11.5.0/sql mkdir fz/11.5.0/bin mkdir fz/11.5.0/reports mkdir fz/11.5.0/reports/US mkdir fz/11.5.0/forms mkdir fz/11.5.0/forms/US mkdir fz/11.5.0/$APPLLIB mkdir fz/11.5.0/$APPLOUT mkdir fz/11.5.0/$APPLLOG 2) Add the custom module into the environmentApply ADX.E.1 and add the entry to topfile.txt as a standard product top entry . Customised environment variables can be added to AutoConfig by using the filename specificed by s_custom_file, which is then called from the APPSORA.env file. If using Forms Listener Servlet, you may also need to add $CUSTOM_TOP to formsservlet.ini in$APACHE_TOP/Jserv/etc 3) Create new tablespace for database objects create tablespace FZ datafile '/u01/oracle/visdata/fz.dbf' size 10M default storage(initial 10k next 10k)4) Create schema create user fz identified by fz default tablespace fz temporary tablespace temp quota unlimited on fz quota unlimited on temp; grant connect, resource to fz;5) Register your Oracle Schema. Login to Applications with System Administrator responsibility Navigate to Application-->Register Application = FZ Custom Short Name = FZ Basepath = FZ_TOP Description = FZ Custom Application6) Register Oracle User Naviate to Security-->Oracle-->Register Database User Name = FZ Password = FZ Privilege = Enabled Install Group = 0 Description = FZ Custom Application User7) Add Application to a Data Group Navigate to Security-->Oracle-->DataGroup Data Group = FZGroup Description = FZ Custom Data Group Click on "Copy Applications from" and pick Standard data Group, then add the following entry. Application = FZ Custom Oracle ID = APPS Description = FZ Custom Application Create custom request group This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility Navigate to Security-->responsbility-->Request Group = FZ Request Group Application = FZ Custom Code = FZ Description = FZ Custom Requests We will not define any requests to add to the group at this stage, but you can add some now if required.9) Create custom menu This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility. We will create two menus, one for Core Applications and one for Self Service. Navigate to Application-->Menu Menu = FZ_CUSTOM_MENU User Menu Name = FZ Custom Application Menu Type = <leave blank> Description = FZ Custom Application Menu Seq = 100 Prompt = View Requests Submenu = <leave blank> Function = View All Concurrent Requests Description = View Requests Seq = 110 Prompt = Run Requests Submenu = <leave blank> Function = Requests: Submit Description = Submit Requests Menu = FZ_CUSTOM_MENU_SSWA User Menu Name = FZ Custom Application SSWA Menu Type = <leave blank> Description = FZ Custom Application Menu for SSWA 10) Create new responsibility. One for Core Applications and One for Self Service (SSWA) Navigate to Security-->Responsibility-->Define Responsibility Name = FZ Custom Application = FZ Custom Responsibility Key = FZCUSTOM Description = FZ Custom Responsibility Available From = Oracle Applications Data Group Name = fzGroup Data Group Application = FZ Custom Menu = FZ Custom Application Request Group Name = FZ Request Group Responsibility Name = FZ Custom SSWA Application = FZ Custom Responsibility Key = FZCUSTOMSSWA Description = FZ Custom Responsibility SSWA Available From = Oracle Self Service Web Applications Data Group Name = fzGroup Data Group Application = FZ Custom Menu = FZ Custom Application SSWA Request Group Name = FZ Request Group11) Add responsibility to user Navigate to Security-->User-->Define Add FZ Custom responsibility to users as required.12) Other considerations You are now ready to create your database Objects, custom Reports, Forms, Packages, etcCreate the source code files in the FZ_TOP directory appropriate for the type of object. For example formswould be located in $FZ_TOP/forms/US or package source code in $FZ_TOP/admin/sql for example.Database Objects, such as tables, indexes and sequences should be created in the FZ schema, then you need to a) Grant all privilege from each custom data object to the APPS schema. For example : logged in as FZ user grant all privileges on myTable to apps; b) Create a synonym in APPS for each custom data object For example : logged in as APPS user create synonym myTable for fz.myTable;Other database objects, such as views and packages should be created directly in the APPS schema.
18.Question :
-------------
What is '$flex$ and '$profile$, Waht is the use of '$flex$'?
Answers:
--------
$Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .
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.
:$FLEX$
=======
:$Flex$.<valueset_name> is used to get the previous parameter value to the current parameter. And it is a reserved word.
Can be used at 2 locations in oracle applications.
1. Value set where/order by field.
If we want to select statement in application>validation>sets instead of tablename it should be select caluse and in parathesis.
eg: create a value set by name DPTNO datatype number(5)
validation type TABLE
click EDIT INFORMATION
in table place (select distinct deptno from emp)
create another value set by name JOB datatype CHAR(20)
validation type TABLE
click EDIT INFORMATION
table name (SELECT DISTINCT DEPTNO,JOB FROM EMP)
JOB CHAR 20
where/order by WHERE DEPTNO=:$FLEX$.DPTNO
and mention this valueset in the concurrent >program>define>parameter form.
2. Default value field in concurrent progrm form.
first create an value set of DTNO of Table validation type
click EDIT INFORMATION
at table name (SELECT DISTINCT DEPTNO FROM EMP)
in the concurrent>program>define>parameter form
you can even specify as
mention Parameter name as JOB
default type -SQL STATEMENT
default value - SELECT DISTINCT DEPTNO,JOB FROM EMP WHERE DEPTNO=:$FLEX$.DTNO
:$PROFILE$
==========
used to get current profile value to the current parameter.
1. Value set where/order by field.
create a value set by Name as
XX_ORG_ID
datatype CHAR(240)
validation type TABLE
click EDIT INFORMATION
table name HR_OPERATING_UNITS
table columns
NAME CHAR 240
ORGANIZATION_ID NUMBER 15
where/order by ORGANIZATION_ID= :$profiles$.org_id
and mention this valueset in the concurrent >program>define>parameter form.
2. Default value field in concurrent progrm form.
concurrent>program>define>parameter form
you can even specify as
mention Parameter name as P_ORG_ID
default type -SQL STATEMENT
default value - SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID=:$PROFILE$.ORG_ID
19.Question :
-------------
What is quick code? why is it called a quick code?
What is steps of defining a quick code?
Answers:
--------
Quick code is that where we can hurry up the process of getting services and extended warranties quickly.
The Quick codes are lookup codes that are defined for quick references and can be used to display exact meaning while on the front end. Example: the column Gender of your table may hold values M or F. this can be defined to have the meaning Male or Female in the Quick Codes. The quick code value is usually what gets displayed when you access the web pages
20.Question :
-------------
What is the difference between organization id and master organization id?
Answers:
--------
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.
both ids are related to inventory.
when new item is defined.first it needs to defined and assign in master organization id then child organization id.
normally inventory transactions are not done on master organization id.
21.Question :
-------------
What so you mean by Hierarchical and non Hierarchical security type in value set?
Answers:
--------
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.
22.Question :
-------------
What is US directory under any TOP?
Answers:
--------
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
As oracle apps is US based product. So, in all folders you will find US.
No comments:
Post a Comment