Top 40 Oracle Apps Interview Questions You Must Prepare 19.Mar.2024

  • Open template form
  • Save as .fmb
  • Change the form module name as form name.
  • Delete the default blocks, window, and canvas
  • Create a window.
  • Assign the window property class to window
  • Create a canvas (subclass info)
  • Assign canvas property class to the canvas
  • assign the window to the canvas and canvas to the window
  • Create a data block
  • Modify the form level properties. (sub class item Text item)
  • Modify the app_custom package. In the program unit.
  • Modify the pre-form trigger (form level)
  • Modify the module level properties ((console window, First navigation
  • Save and compile the form.
    Place the .fmx in the server directory.

Autonomous traction me a traction that is embedded in some other traction, but functions independently.

yes, we can have custom schema, when we want to create a new table we required custom schema.     

Open Interface, also known as the Application Programmer Interface (API), is a process whereby the Oracle Applications are linked with external or legacy systems. Open Interface works as a temporary staging area to load the external information into Oracle Applications tables. Once the data is validated, it sends the information to the permanent tables. Rejected tractions can be corrected and resubmitted.

A request set is a collection of reports or programs grouped together. Once you submit a request set job, it executes all the programs in a report set sequentially or in a parallel manner as defined in the request set.

Concurrent processing is a process that simultaneously runs programs in the background (usually on the server rather than your workstation) while working online.

A DFF lets you define the custom fields into Oracle Application forms without customizing the program code. DFFs in forms are represented by a "beer mug" field (a single space field enclosed by brackets) that looks like the following symbol: [ ]. They are usually stored in ATTRIBUTE 1...ATTRIBUTE n database columns. DFFs can also be used to accept report parameters.

A formula column performs a user-defined computation on another column(s) data, including placeholder columns.

Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them. This information is maintained in the TCA Registry, which is the single source of trading community information for Oracle E-Business Suite applications.

Yes. It is strongly recommended to add WHO columns to the custom tables and call standard API, FND_STANDARD.SET_WHO in PRE-INSERT, and PRE-UPDATE triggers in each block of the form. Also, specify these fields as hidden in each block of the form.

Six validation types exist:
none, dependent, independent, table, special, and pair.

A Key Flexfield is a unique identifier that is made up of meaningful segments to identify GL account numbers and item numbers. Key Flexfields are usually stored in SEGMENT1...SEGMENTn database columns.

Some examples would be Item No 34H-AFR-223-112.G and GL Account No:

100-00-1000-324-11100.

For an example GL Account, segments could be identified as Organization, Cost Center, Account, Product, Product Line.

You can maintain all your table changes by creating a new schema. You can use your custom application short name (such as XXPO) as your Oracle schema name for easy identification. The new schema must be registered in the Oracle AOL.

A Concurrent Manager is a component of concurrent processing that monitors and runs requests while you work online. Once the user submits a request to run the job, the information is stored in the request table. A concurrent manager gets the information from the request table and executes the specified concurrent job.

You can use a placeholder to achieve this. If you enter a single colon ( : ) in one of your query fields during the Enter Query mode, Oracle Forms Run Query will prompt you to enter the text of SQL Where clause.

When ever a concurrent job is submitted, Applications creates a Request ID. You can use this Request ID to view the results.

A document sequence assigns unique numbers to the documents (tractions) generated by Oracle Applications. For example, each invoice has its own unique invoice number and each purchasing document has its own unique purchase order (PO) number.

Use to trfer values to report builder and it is not case sensitive.

You can use the CUSTOM library in a variety of cases. You can use it to incorporate Zoom logic, logic for generic events, logic for product-specific events, and to add entries for the special menu.

Yes. This can be done using the CUSTOM library, which is an Oracle Forms PL/SQL library. You can integrate your custom code directly with Oracle Applications without making changes to your Oracle Applications forms code. The CUSTOM library is located in the $AU_TOP/res/plsql directory. Once you write the code, you compile and generate the CUSTOM procedures to make your changes.

It is a language specific folder used to store the G.U.I like reports and forms.

The APPS schema. AutoInstall automatically sets the FNDNAM environment variable to the name of the APPS schema.

A request security group is the collection of requests, request sets, and concurrent programs that a user, operating under a given responsibility, can select from the Submit Requests window.

It is nothing but Instance of the execution along with parameters & Incompatables. Here Incompatables nothing but if we  are submiting cc programs if any one can be execute in those program , which programs r not imp yet this time we will  mention those programs in incompatables tab.

Custom Top is nothing but Customer Top, which is created for customer only. we can have multiple custom tops based on client requirement. It is used to store developed & customized components. whenever oracle corp applying patches it will over ride on all the modules except custom top. that's why we will use custom top.

Set up a directory structure for a custom application, and define an environment variable that trlates to your application base path.

select basepath,application_short_name from fnd_application from the backend. From the from end we can get it Navigation Application Developer.-----> Application---->Register The application name we will get from FND_APPLICATION_TL

Identify programs that should not run simultaneously with your concurrent program because they might interfere with its execution.You can specify your program as being incompatible with itself.

Application: Although the default for this field is the application of your concurrent program, you can enter any valid application name.

Name: The program name and application you specify must uniquely identify a concurrent program. Your list displays the user-friendly name of the program, the short name, and the description of the program.

Scope: Enter Set or Program Only to specify whether your concurrent program is zincompatible with this program and all its child requests (Set) or only with this program (Program Only).

Run Alone: Indicate whether your program should run alone relative to all other programs in the same logical database. If the execution of your program interferes with the execution of all other programs in the same logical database (in other words, if your program is incompatible with all programs in its logical database, including itself), it should run alone.

The required steps are as follows: define the value sets, define the structures, and define the values, if needed. The optional steps are as follows: define the security rules, define the cross-validation rules, and define the shorthand aliases, if necessary.

Apps schema contains only Synonyms we can't create tables in apps schema,where as other schema s contains tables, & all the objects. Here only we will create the tables and giving grants on created tables. Almost all every time we  will connect to apps schema only.

The four phases are as follows: inactive, pending, running, and completed.

A Flexfield is a field made up of segments. Each segment has an assigned name and a list of valid values. Two types of Flexfields exist: Key Flexfields and Descriptive Flexfields (DFFs).

Sql  loader is a bulk loader utility used for moving data from external files into the oracle database.

Sql loader supports various load formats, selective loading, and multi-tables loads.

  1. Conventional --The conventional path loader essentially loads the data by using standard ‘insert’ statement.
  2. Direct -- The direct path loader (direct = true) by possess of logic involved with that, and loads directly in to the oracle data files.

EX:- My data.csv file

1001, “scott tiger”,1000,40

1002,”gvreddy”,2345,50

Load data

Infile ‘c:datamydata.csv’

insert Into table emp Fields terminated by “,” optionally enclosed by‘”’

(empno, empname,sal,deptno)

>sqlldr scott/tiger@vis control=loader.ctl log= gvlog.log bad=gvbad.bad discard=gvdis.dsc .

A placeholder is a column is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed in to It by pl/sql code from another object.

You can set the value of a placeholder column is in a Before Report trigger.

Store a Temporary value for future reference. EX. Store the current max salary as records are retrieved.

Oracle recommends an application short name begin with XX. As an example, extensions to Oracle Purchasing would be XXPO.

A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional

summaries: first, last, standard deviation, variance.

Collection of Chart of Accounts and Currency and Calendars is called SOB

Oracle Alert is an exception reporting system. It keeps you informed on an as-needed basis. It also communicates with other users through e-mail regarding exception messages.

It is nothing but language specification by default it is in american language. We can have multiple languages folders  based on installed languages. from backend we can get it from

FND_LANGUAGES -- COL --INSTALLED_FLAG I,B,D

              I--INSTALLED,

              B--BASE,

              D--DISABLE

              select language_code,nls_language from fnd_languages where installed_flag like 'B'

Profile options are set to determine how the applications look and feel. There are four levels of profile options available: site level, application level, responsibility level, and user level. You can have various categories of profile options, such as personal options, system options, auditing profile options, currency options, Flexfield options, online reporting options, personal output viewer options, and user profile options.