Oracle Apps Interview Questions-13

Oracle Apps Interview Questions,Askhareeshblogspot.com

181)How do I run a shell script as a concurrent program?
1: Write the script and call it <name>.prog Place the script under the bin directory under your applications top directory. For example, call the script CUSTOM.prog and place it under $CUSTOM_TOP/bin
bin
2: Make a symbolic link from your script to $FND_TOP/bin/fndcpesr For example, if the script is called CUSTOM.prog use this: ln -s $FND_TOP/bin/fndcpesr CUSTOM This link should be named the same as your script without the .prog extension It should be in the same directory as the script.
3: Register a concurrent program as described above, using an execution method of 'Host' Use the name of your script without the .prog extension as the name of the executable For the example above, you would use CUSTOM CUSTOM
4: Your script will be passed at least 4 parameters, in $1 through $4 These will be: orauser/pwd, userid, username, request_id Any other parameters you define will be passed in $5 and higher. Make sure your script returns an exit status.
define will be passed in $5 and higher. Make sure your script returns an exit status.
5: If your script returns a failure exit status but the concurrent manager does not report the error (shows it as still running normal) apply patch 442824


182)How will u register RDF file and run it? Tell the Sequence?
a. Save the copy of ur reports in rdf file in ur local directory.
b. Transfer or copy the rdf file to cus_top under reports directory through ftp.
C. Then go concurrent program under executable menu where u define executable file and program name
d. Then go to define the program name (which ur executable file name ) and check the srs box and define the parameter and give the parameter name in token
e. Attach the program(request to ur responsibility ) and run the program and view the out put is srs through ur responsibility.

183)What is translatable Independent & Dependent ?
The value set used to support the multilingual value set.


184) How do I submit a concurrent request from PL/SQL?
using fnd_request.submit_request .
begin
v_request_id := fnd_request.submit_request(applicationshortname,
concurrentprogramshortname,
description,
paramers)
end;
commit;
if v_request_id > 0 then
dbms_output.put_line('Successfully submitted')
else
dbms_output.put_line('Not Submitted');
end;
note : to submit a conc program from UNIX/shell scrip we use CONSUB


185) How do I cancel a running concurrent request?
Navigate to the Concurrent Request Summary form Select a request The Sysadmin responsibility can cancel or hold any running request.


186) What is the difference between organization id and org_id ?
Organization_id stores inventory organization id ( like 204 for M1)
Org_id stores the OU id corresponding to a operating unit .


187) What is the difference between conversion and interfaces ?
conversion means one time activity interface means periodic activity
example:- to transfer the data old version to new version it is called conversionto transfer the data from staging table to interface table it is called interface , it is process on every day or every hour ........


188) What are the different types of value sets and also explain each briefly ?
Different types of Value sets are,
1) Independent- This Value set contains list of values which does not depends on any other value
2) Dependant- It contains values which depends on any one of the Independant value
3) Pair- combines 2 flex field together to specify range of valid values
4) Special- Uses only 1 flex field structure to specify values
5) Table- This Value set contains list of values from 1 or more than 1 table columns
6) Translatable Dependant- Same as Dependant value set, only translated values are present
7) Translatable Independant- Same as Independant value set, only translated values are present.


189) How do you register a table and columns in Oracle Apps?

To register the table and columns in AOL the 
navigation is: Open Application Developer---> Application--->Database--->table.(In table mention the table name(which you want to register), user table name,columns,user column name). The table & columns which you are going to register should be present in your module specific schema.

190) What can we find TEMPLATE.FMB file ?
$AU_TOP/forms/US
Template.fmb file can be found in AU_TOP resource directory. This file contains all the Common characterstics all the forms. And also Contains Diffrent libraries. like CUSTOM.pll,APPCORE,APPCOREE2,FNDSQF, JE,JL,JA,VERT,GLOBE etc.. And Template.fmb cotains Diffrent propery classes for all the objects. This Template.fmb can be used for developing the new form. 


191) What are the libraries attached to TEMPLATE form ?
The Template form required 19 .pll in 11i version. Those pll names are :
APPCORE.pll APPCORE2.pll FNDSQF.pll APPDAYPK.pll GLOBE.pll JE.pll JL.pll JA.pll VERT.pll GHR.pll PQH_GEN.pll PSAC.pll PSB.pll PSA.pll IGILUTIL.pll
IGILUTIL2.pll CUSTOM.pll GMS.pll FV.pll OPM.pll


192)What is Concurrent Programming?
Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with on line operations to fully utilize your hardware capacity.
Use Concurrent Programming for
Long Running – Data intensive tasks such as Posting a Journal or generating a report.


193)What is the Role of Concurrent Managers?
A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer.


194)What is AOL?
Oracle Applications are constructed and maintained using the Application Object Library (AOL).
The Three main areas of AOL are

  • Applications Security
  • Operating Profile
  • Concurrent Processing
195) What are the tables related to flex field?
  • FND_FLEX_VALUES
  • FND_FLEX_VALUE_SETS
  • FND_FLEX_VALUES_TL  



*/