1) What is the difference between AU_TOP and PRODUCT_TOP?
AU_TOP is the place where all the form objects, jsp of all the modules will be placed. PO_TOP is the place where all the form object of only purchasing application will be placed. The executable file from AU_TOP goes to PRODUCT_TOP from where it is referred at execution time
2) What is Special Menu? Advantages?
You can customize the menu to display application specific values. The menu supports up to forty five application specific entries underthree top level special menu entries (usually called Tools, Reports, and Actions).
3) What is the utility used when migrating from 11 to 11i?
To upgrade forms, the form can be directly compiled in next release(forms 6i) Form can be compiled by using ifcmp60.exeflint60 batch executable can be used to check whether the form is compatible to apps or not
4) What is an interface, Explain
Integrating one application to other applications It involves Data file, insertion scripts, loader scripts, Temp tablesData file is a flat file having contents with delimitter insertion scripts are used to insert data into product tables from temp tableloader scripts are also called as control files which are used insert data from data file to temp table. Temp tables are used to transfer data from one module to another or application
5) What is Concurrent Manager ? Explain
A process manager on the Applications database server that coordinates the concurrent processes generated by users’ concurrent requests.
6) How to register a Concurrent Program, Give Steps
Concurrency: The simultaneous access of the same data by multiple users.Concurrent manager: A process manager on the Applications database server that coordinates the concurrent processes generated by users’ concurrent requests.Concurrent process: A task run by a concurrent manager. A concurrent process runs simultaneously with interactive functions and other concurrent processes.Concurrent processing facility : An Oracle Applications facility that runs time–consuming, non–interactive tasks in the background.concurrent processing server : A machine on which concurrent processing facilities are run.Concurrent queue : A list of concurrent requests awaiting completion. Each concurrent manager has its own queue of pending requests.Concurrent request: A request issued to the concurrent processing facility when you submit a non–interactive task, such asrunning a report.Step1: System Adminstrator --> Concurrent --> Program --> Executable (Exectuable, Short name,Application, Execution Method, Execution file name)Step 2: System Administrator --> Concurrent --> Program--> Define(Program, Executable, output, incompatibles, parameters etc)Step 3: System Administrator --> Responsiblity --> Request --> Query for Specific Application --> Add Concurrent Program there
Advantage of Securing Attributes while Creating User & Responsibility?
Securing attributes allow rows (records) of data to be visible to specified users or responsibilities based on the specific data (attribute value)contained in the row. This is basically for Oracle Self-service web application for data security
What is Alert in Apps? How to register it? How it supports Different languages
Oracle Alerts allows you to monitor your business information. It enables you to: Be informed of database exceptions as they happenSpecify the exception conditions along with frequency Be informed through a single point - emailTake actions you specify depending on a recipient's response Perform routine database tasks automatically Integrate email systems
Is Apps NLS Compliant?
Yes
What is Descriptive Flex-Field? Advantage.
A flexfield is a field made up of segments. Each segment has a name you or your end users assign, and a set of valid values. There are two types of flexfields: key flexfields and descriptive flexfields. Descriptive flexfields let you satisfy different groups of users withouthaving to reprogram your application, by letting you provide customizable ”expansion space” on your forms.
Give an example of Key-FlexField.
In another example, Oracle General Ledger uses a key flexfield called the Accounting Flexfield to uniquely identify a general ledger account.At Oracle, we have customized this Accounting Flexfield to include six segments: company code, cost center, account, product, product line, and sub–account.
What are the new 8i features used in Apps 11i?
User Defined objectsVarraysNested tablesPartitioning table & IndexPlSql Server pagesParellel serverMaterialized viewsTemporary tables
How is determine whether the form is AOL compliant or not?
Manually checking the code in certain form eventsflint60.exe utility can be used to check whether the form is having AOL standard or not
Explain about Oracle Applications 11i architecture.
Internet Computing Architecture is a framework for three-tiered, distributed computing that supports Oracle Applications products. The three tiers are the database tier, which manages Oracle8i database; the application tier, which manages Oracle Applications and other tools; and the desktop tier, which provides the user interface display. With Internet Computing Architecture, only the presentation layerof Oracle Applications is on the desktop tier in the form of a plug-in to a standard Internet browser.
Why we have to use Profile options?
A user profile is a collection of changeable options that affect the way your applications run. Oracle Applications establishes a value for eachoption in a user’s profile when the user logs on or changes responsibility. Oracle Applications provides these options so that youcan alter the behavior of your applications to suit your own preferences.
Difference between KFF & DFF?
A flexfield is a field made up of sub fields, or segments. A flexfield appears on your form as a pop up window that contains a prompt foreach segment. Each segment has a name and a set of valid values. There are two types of flexfields: key flexfields and descriptiveflexfields. Key flexfields are flexible enough to let any organization use the codescheme they want, without programming.Descriptive flexfields provide customizable expansion space on your forms. You can use descriptive flexfields to track additionalinformation, important and unique to your business, that would not otherwise be captured by the form. Descriptive flexfields can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the form.A descriptive flexfield appears on a form as a single character, unnamed field enclosed in brackets. Just like in a key flexfield, apop up window appears when you move your cursor into a customized descriptive flexfield. And like a key flexfield, the pop up window has as many fields as your organization needs.
What are different Handlers in Apps Coding Standards?
Oracle Applications uses groups of packaged procedures, called handlers, to organize PL/SQL code in forms so that it is easier todevelop, maintain, and debug. Handlers may reside in program units in the form itself, in formlibraries, or in stored packages in the database as appropriate. Item Handlers An item handler is a PL/SQL procedure that encapsulates all of the code that acts upon an item. Most of the validation, defaulting, and behavior logic for an item is typically in an item handler.Event Handlers An event handler is a PL/SQL procedure that encapsulates all of thecode that acts upon an event. Usually event handlers exist to satisfy -requirements of either Oracle Forms or the Oracle Applications UserInterface Standards for Forms–Based Products, as opposed to particular business requirements for a product. Table HandlersA table handler encapsulates all of the code that manages interactions between a block and its base table. When an updatable block is basedon a view, you must supply procedures to manage the insert, update, lock and delete. Referential integrity checks often require additionalprocedures. Table handlers may reside on either the forms server or the database, depending on their size and the amount of interactionwith the database, but they typically reside in the database.
What is Custom.pll ? Restrictions & Advantages?
The CUSTOM library allows extension of Oracle Applications without modification of Oracle Applications code. You can use the CUSTOMlibrary for customizations such as Zoom (such as moving to another form and querying up specific records), enforcing business rules (forexample, vendor name must be in uppercase letters), and disabling fields that do not apply for your site.
What is Folder? Use?
A flexible entry and display window in which you can choose the fields you want to see and where each appears in the window.
Function Security?
Function security lets you restrict application functionality to authorized users. Application developers register functions when they develop forms. A System Administrator administers function security by creating responsibilities that include or exclude particular functions.A function is a part of an application’s functionality that is registered under a unique name for the purpose of assigning it to, or excluding itfrom, a responsibility. There are two types of functions: form functions, and non–form functions. For clarity, we refer to a form function as a form, and a non–form function as a subfunction, even though both are just instances of functions in the database.
Execution methods of concurrent programs
The execution method identifies the concurrent program executable type and the method Oracle Application Object Library uses to execute it.An execution method can be a PL/SQL Stored Procedure, an Oracle Tool such as Oracle Reports or SQL*Plus, a spawned process, or anoperating system host language.
Value sets and the various types of value set validations
ValueSet -- To Validate the values entered by the user for flex-field, report or concurrent Validation Type : None, Dependent, Independent, Pair, Special, Table, Translation Independent, Translation Dependent
What is flex-field? Advantages
An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization. There are two types of flexfields: key flexfields and descriptive flexfields.
What is Zoom feature in Apps?
Moving to another form and performing actions querying up specific records) Zoom : The addition of user–invoked logic on a per–block basis.A Zoom typically consists of opening another form and (optionally) passing parameter values to the opened form through the Zoom logic.
What is AOL?
Set of Standards and objects used by Oracle Applications to develop and maintain Oracle Applications
Apps 11i
What is Certification file?
Contains the identity of a "trusted source" that the desktop client uses to guarantee the authenticity of a JAR file. Information contained within the certificate file allows the desktop client to decrypt the digital signature of a JAR file. If the identity can be confirmed, the desktop client assumes the JAR file is safe to download and execute.
What is Jinitiator?
JInitiator is an Oracle implementation of Sun’s JavaSoft Plug-in for Solaris. It is used for connectivity between a Windows based client and Oracle Application forms. Oracle redesigned the JavaSoft code to function specifically for Oracle Applications Forms. The primary difference is that Oracle JInitiator includes the various stability and performance enhancements that Oracle implemented prior to it being added into the reference JVM. The context of this document xplains JInitiator as it is used with Oracle financial applications (E – Business Suite), not as it is used in the standalone mode in reference to Forms development. JInitiator is only for Windows based client machines.
What is identitydb.obj file?
Client Digital Certificate
What are the new features in Apps Release 11i
Peronal Homepage, it can be customized
8i New featues
Rapid install wizard
Internationlization support
Who is Applmgr user?
The login used for install and upgrade oracle applications
What is ORACLE_SID?
An environment setting that identifies an ORACLE instance running on the current machine. See also TWO_TASK and LOCAL.
What is product group?
A set of Oracle Applications product schemas linked together by a single Oracle Application Object Library schema.
What is a flexfield, what are different types of flexfileds
A flexfield is a field made up of sub fields, or segments. A flexfield appears on your form as a pop up window that contains a prompt for each segment. Each segment has a name and a set of valid values. There are two types of flexfields: key flexfields and descriptive flexfields.
What are steps involved in form registration ( in 10.7 and in 11.x)
Upload form into PRODUCT_TOP
Application Developer --> Application --> Form (Form, Application, User form name, Description)
What is an easy form?
What is a concurrent program, and what are the steps involved in conc program registration process ?
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.
Conc Program Registration:
Go to AOL Responsibility Concurrent -> Executable
Give Executable name,Short name,Application name, Execution Method (ie
Host,SQL * Plsus report, Oracle Report, PL/SQL Procedure etc),
Execution file name and save it.
This Information will be save in Table FND_EXECUTABLE_FORM_V.
Go to Concurrent -> Program
Give Concurrent program name,Short name and mention Executable short name
Execution method, If required press Parameters Button and give parameter
names. Save it.
This Information will be save in Table FND_CONCURRENT_PROGRAMS_VL.
Go to Sysadmin Responsibility
Security -> Responsibility -> Request
Add your Concurrent program under required request group. Save It.
This Information will be save in Table FND_REQUEST_GROUPS
How conc program registration process differs from SRS process?
Concurrent program registration process is explained in the above. Once you register you can run conc pgm under request group. You canot run directly from Menu Prompt. If you want to run directly from Menu prompt you can use SRS process.(Like Form)
In the AOL Responsibility
Application -> Function
Under "Form" Tab canvas you have Parameters item. In that text item
you need to give following values.
eg: TITLE="WSM:INFO_SRS_REPORT"
USE_ORG="Y"
CONCURRENT_PROGRAM_NAME="IFSPT"(ie Conc Program short name)
PROGRAM_APPL_SHORT_NAME="WMS"
REQUEST_GROUP_CODE="WSM_JOB_REPORTS"
What is difference between quick pick and quick code?.
When a database column contains a QuickCodes value, which we implement using a foreign key to FND_LOOKUPS, MFG_LOOKUPS, or to some other lookup table, we list the QuickCodes type (lookup type) to which the QuickCodes value must belong and a complete list of QuickCodes values and meanings. Some QuickCodes can be defined by you in the application. These values are designated as User–defined
What is difference between 10.7 and 11 architecture?
10.7 is smart client , client server 11 is network computing architecture with three tier
What is a multi org, and how it is different from single org set up?
Sselect multi_org_flag from fnd_product_groups;
How you define responsibility in oracle apps?
A level of authority in an application. Each responsibility lets you access a specific set of Oracle Applications windows, menus, reports, and data to fulfill your role in an organization. Several users can share the sameresponsibility, and a single user can have multiple responsibilities.
What is a data group?
A data group is a group list of Oracle Applications and the Oracle ID each application is assigned to. An Oracle ID grants access privileges to tables in an ORACLE database.
What is a report security group.
A feature that helps your system administrator control your access to reports and programs. Your system administrator defines a report security group which consists of a group of reports and/or programs and assigns a report security group to each responsibility that has access to run reports using Standard Report Submission. When you submit reports using Standard Report Submission, you can only choose from those reports and programs in the report security group assigned to your responsibility.
Where the forms are stored in oracle apps?
$PRODUCT_TOP/forms/US
Where is output of reports stored in oracle apps?
$COMMON_TOP/admin/out
What is menu and how it is attached to a form or program.?
Menu is list of options to user
What is an user exit?
A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.
You can write the following types of user exits:
ORACLE Precompiler user exits
OCI (ORACLE Call Interface) user exits
non-ORACLE user exits
You can use user exits for other tasks, such as mathematical processing and setting profile options in multiorg.
It is an external program to perform some logical operations
It can be a pro*c, c program
How to display list of organizations in form?
fnd_org.choose_org in pre form
How to restrict users to few menu options?
Using Function Security
Difference between APPCORE & APPCORE2?
APPCORE2 is the duplicate of APPCORE which is used with custom pll And it contains all the object related to standard toolbar & menu
How to register or call a form in Query only mode?
Parameter = QUERY_ONLY = YES
What are Concurrent Execution Methods?
Host
Oracle Reports
PL/SQL Stored Procedure
Java Stored Procedure
Java Concurrent Program
Multi Language Function
SQL*Loader
SQL*Plus
Spawned
Immediate
Can you validate on a DFF?
Yes,You can Validate DFF
What is FND.Message ?
Message Dictionary APIs you can use in your PL/SQL procedures.
What is NLS & MLS ?
NLS, which stands for National Language Support is basically the running of Oracle Applications in one operational language. This operating language will always be set as the base language for applications.
MLS, which stands for Multiple Language Support is the running of Oracle Applications in a number of languages, in the same Oracle Applications database instance.
For Release 11.0 and higher there is no limit on the number of languages that can be run concurrently in Oracle Applications. The only restriction is that all installed languages must share a common character set. In Release 11i, the Unicode characterset (UTF-8) supports all languages available in Oracle Applications
You can use the following SQL statement to find out which languages you have installed in your Oracle Applications database. Connect to the database using the APPS oracle username.
SELECT LANGUAGE_SHORT_NAME, INSTALLED_FLAG FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('B','I');
The language which has an INSTALLED_FLAG of 'B' is called the base language. Languages with INSTALLED_FLAG of 'I' are called installed languages. Your installation should have one (and only one) base language. However it can have zero or more installed languages. American English should always be either a base or an installed language
What is Special validation in valueset?
Special validation value sets allow you to call key flexfield user exits to validate a flexfield segment or report parameter using a flexfield within a flexfield echanism. You can call flexfield routines and use a complete flexfield as the value passed by this value set. When you define a special validation value set, you specify two things: an event and a function. The event is the time when your function occurs, and your function is your call to a key flexfield user exit. For example, the Validate event occurs once a user enters a value, and your function would validate that value.
What are the default libraries attached for a Template form and advantage of each library?
APPCORE,APPDAYPK,FNDSQF, JA, JE, GLOBE, VERT, FNDSQF, CUSTOM
Is form designed by you is multi-org compatible?
What is the difference between table_ALL & with out ALL tables?
table_name_ALL are multi org compatible tables
What is customer architecture used by Apps 11i?
Do you have used any utility to improve the performace of your application?
How to Install and configure Printer in Apps? explain complete procedure ?
What is Printer Driver and its significance?
What is printer type and its significance ? How you relate Printer driver and Printer type ?
A printer type identifies a printer by manufacturer and model. A print style tells the printer how a printed output should look. A printer driver delivers commands that tell the printer how to output the specified print style. The ability to print a report in a particular print style depends on the type of printer the report file is sent to.
Printer Type : What kind of printer you have. This is the manufacturer and model. Two examples are a DEC LN03 printer and an HP Laserjet III printer.
Print Style : A description of how your report should be
printed. Print style determines the:
Number of lines per page.
Width of each line.
Whether a header page should be printed.
Number of lines per page.
Width of each line.
Whether a header page should be printed.
Printer Driver: The set of commands that tell a printer how to
print in the Print Style chosen.
Initialization sets printing orientation.
Reset clears printer’s instructions for next print job.
SetUp Steps :
Step 4 - Setup Printer Driver - run on Client
---------------------------------------------
Go into applications as a user with 'System Administrator' responsibility.
Go to Install-->Printer-->Driver
Create new driver by entering the following information:-
Driver Name : testDriver
User Driver : testDriver
SRW Driver : L
Arguments : print /d:\\
All other options should be left at default - which is blank for everything except 'Driver Method' which is defaulted to 'Command'.
Step 5 - Setup Print Style - run on Client
------------------------------------------
Go to Install-->Printer-->Style
Create new style by entering the following information:-
Style Name : testStyle
Seq : 4
User Style : testStyle
SRW Driver : L
Columns : 132
Rows : 64
All other options should be left blank. NOTE - the 'Seq' number needs to be unique, so if you get an error to the effect number 4 has already been used, then use a different number that has not previously been used. The seeded data uses multiples of 5 (ie - 5, 10, 15, etc) up to a value of 185.
Step 6 - Setup Printer Types - run on Client
--------------------------------------------
Go to Install-->Printer-->Types
Create new type by entering the following information:-
Type : testType
Style : testStyle
Driver Name : testDriver
Step 7 - Register Printer - run on Client
-----------------------------------------
Go to Install-->Printer-->Register
Create new printer by entering the following information:-
Printer : testPrinter
Type : testType
Step 8 - Setup profile option - run on Client
---------------------------------------------
Go to Profile-->System Type in 'printer' in the 'Profile' and click on 'Find'
This should display the System Profile option called Printer on screen.
Click on "Site" and then use the List Of Values to select your printer called
'testPrinter' Save this setting, then exit Oracle Applications
Step 9 - Stop and restart Concurrent Manager - run on Server ------------------------------------------------------------
Go to Settings-->Control Panel-->Service Scroll down to and click on 'OracleConcMgr
Explain Pro * C concurrent request (Spawnned) ?
A concurrent program that runs in a separate process (on most operating systems) than that of the concurrent manager that starts it.You write spawned concurrent programs as C or Pro*C stand–alone executable files. On some operating systems, you can also write spawned concurrent programs in your operating system language.Spawned concurrent programs are the recommended execution method for new C or Pro*C execution files.
What is "Immediate" type request set ?
A concurrent program that runs in the same process as the concurrent manager that starts it. You write immediate concurrent programs as C or Pro*C subroutines and link them in with a concurrent manager.Attention: The immediate concurrent program functionality is provided for backward compatibility only. You should not be creating new immediate concurrent programs.
What is workshifts of Concurrent Managers ?
Assign work shifts to your manager, which determines what days and times the manager works. For each work shift, you define the maximum number of
operating system processes the manager can run concurrently to read requests (start programs) during the work shift.
How to activate,deactivate and run conc managers ?
How to run concurrent managers from Command prompt ?
From the Administer Concurrent Managers Form From the Operating System
Activate concurrent manager STARTMGR
(syntax may vary with platform)
Verify concurrent manager status CONCSUB FND VERIFY
Deactivate concurrent manager CONCSUB FND DEACTIVATE
Terminate requests and deactivate manager CONCSUB FND ABORT
The STARTMGR command takes up to ten optional parameters.
• Each parameter except PRINTER has a default.
• You can modify the STARTMGR command and your environment to set your own defaults.
Example : Syntax
$ startmgr sysmgr="applsys/fnd" mgrname="std"
printer="hqseq1" mailto="jsmith" restart="N"
logfile="mgrlog" sleep="90" pmon="5" quesiz="10"
This choice appears only when you select an individual manager.
When you restart a concurrent manager, the manager rereads its definition.
You should restart a manager when you have made the following changes using the Define Concurrent Manager form, and you wish those changes to take effect: Restart Change work shift assignments
Modify the number of Target Processes
In a parallel concurrent processing environment,change node or system queue information
what is a subfunction?
Subfunctions are frequently associated with buttons or other graphical elements on forms. For example, when a subfunction is enabled, the corresponding button is enabled. Subfunctions do not appear in the Navigate window and cannot be navigated to.
Where do concurrent request or manager logfiles and output files go?
What are the logfile and output file naming conventions?
What is Request Group ?
What is Request Set ?
What are the important Libraries in Template.fmb ?
What is the significance of :$FLEX$ ?
Which Concurrent Manager will run when you run the report in Apps ?
How to create a report which will compatible with Multi-org in Apps?
What is the Schema for AOL?
Name some FND tables?
Explain Directory Structure of APPS?
How to create Query-only form in Apps with out touching the fmb ?
What is the profile option related to Operating Unit ? Multi org operating unit ?
What is the difference between Applsys and Apps ?
Explain AD Tools ? (Patch Applications) ?
How to Register Shell Program in Oracle Apps ?
How to Register PL/SQL Stored Procedure in Oracle Apps ? What are the Mandatory thing we eed to do for creating PL/SQL Procedure before Registering into Apps ?
Explain Zoom Functionality and what modifications we need to do in Custom.pll for Zoom ?
How to write LOG information from PL/SQL block to log file ?
No comments:
Post a Comment