ORACLE APP TECHNICAL Interview Questions

What are Mandatory triggers to write in the block, which is created on view?

How to register a form and stored procedure in oracle apps ?

What is meant by Global Templates in Oracle ?

When we run payment batch what are the 3 concurrent programs?

How to avoid duplicate data while uploading data from flatfile to staging table?

While registering executable and concurrent program we register both with application name?

so my question is why we are defining in both concurrent program and executable?

After deploying like forms, reports into server how we connect this forms, reports to web?

How relation will be made between modules in oracle financial?

After execution of a report we get parameter layout where we have enter From_date and
To_date.After entering From_date and without entering To_date what happen , a report will execute or not?

In a table there are 20 records. I had update 6 records? How can I see and retrieve particular 6 records. i.e., Latest updated ?

In a Standard form a DFF is disable? How we can Enable it?

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records
and skip the last 10 Records within a single .ctl file ? So my total no. of records to be loaded would be 60. Could anybody help me in this ?

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? Name the different
Cursor Attributes ?

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

Write an SQL Query to Delete Duplicate records from a table using ROWID ?

We have to show a logo/image in a report? what are the steps and which format it is?whether
pdf format is applicable or not?

Where we can write a PL/SQL code in report triggers?

In report we have to show two Layout? how it is and how we can see from where it?

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

Steps for DFF registration ?

In custom.pll what are the events we can Not write ?

How to use .prt file in bitmap reports?

How can you find the status in po?

What are the basetables of customer interface?

What is format trigger?

What is the use of Xml reports over reports6i?

In Unix Schell script what is very 1st line to be written ?

What repots or concurrent program run to transfer data from Inventory to GL ?

What is OM Cycle and What do u mean by Alternate Item ?

Except the SRS window in which we can submit the concurrent program.?

In which table or database definition we can find the link of organization and operation units.?

What is multi org and what is it’s level or structure ?

While registering the concurrent program we first do the executable concurrent program and
then define it . So why we need to give the application name twice in executable and as well as
definitions ?

In the custom.pll what are the events we can write ?

What are files in oracle.?

What is the Exception. Types of exception, Difference between those. And example ?

What is an Index , Types of index and why we use index. ?

What is profile and what is level of profile option and it’s hierarchy ?

How to link modules in apps ?

How to link between inventory and OrderManagement. ?

Give a brief overview on OrderManagement. ?

Tell me some interface tables on ordermangement. ?

While running an interface if we get 100 records as errors. how to debug it.?

Can we customize a form with out template.fmb ?

While running the concurrent program we will get the status, we have to change the status. How it will be done.?

What is the difference between base table and multi-org table?

How to create a link between One dependent value set to another Dependent value set ?

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

What is the use of anchors?

HOW CAN U POPULATE DATA INTO PO_HEADERS_ALL SEGMENTS COLUMN?

IN WHICH MODULE THE LEGAL ENTITY COMES?

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR
NOT ?

In which directory your flatfile is given? If you connected different instance where it is find?

Weather discard file is automatically created or explicitly created? Can u mention it?

What is fiscal calendar?

What is the difference between po_vendors & po_headers_all? does po_vendors relate to
operating unit?

WHAT IS REFCURSOR IN ORACLE ?

HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

HOW CAN U KNOW THE STAUS OF PO?

WHAT IS THE USE OF FORMAT TRIGGER?

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

WHAT IS USE OF APPS API?

What are the profiles ?

If the valueset of type –TABLE then how many tables can we attach in the valueset ?

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

What is the need of registering table in apps?

In Oracle Apps Some tables ends with TL,VL, what is the significance of the TL and VL?

What will happen If I am not giving the Suspense account while defining the Set of Books in GL?

What is the Lookup’s and what is the use of lookups?

What is the Use of User Exit in Oracle apps and when we are developing the new report you
need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter
and is it mandatory. Can’t we develop report without this User exits and
P_CONC_REQUEST_ID parameter ?

How you will Display the Company LOGO In report. Can anyone knows please give solution ?

How You Will display the key flexifields in your report ?

How will you do documentation ?

Which API to return the parameters & valuesets etc ?

In GL module specifying org_id or not?

What are the difference between 11.5.7 and 11.5.9 in oracle apps ?

I Have report which is having field at the end of page,,, problem is when i run report data is
overflowing to the next page,,i want the data to come on same page can anybody help me out?

What is the difference between character mode, bitmap mode ?

What are the Major differences between key flexfields ,descriptive flexfields ?

What are the Major differences between appcore.pll and appcore2.pll ?

What is aim methodology?

In procedure how to return a value?

What is difference between procedure and function ?

What is latest version in reports ?

In ap_terms table what data will be stored ?

What is organization id ?

What is difference between po_headers_all and po_headers ?

What is the difference between credit memo and debit memo ?

Why should we transfer the data base tables to flat file and what is the use ?

What is difference between d2k report and oracle apps report ?

Can anybody tell me, What is the Implementation Process?

How can we develop the po variance and po summary report? with tables mandatory columns
and query please?

What is the purpose of standard cost update?

How to get the on hand quantity of an item across all organizations? name the underlying
tables ?

Which is the table for storing organization information?

What are the prerequisites for costing transactions?

Name at least five reports in oracle inventory related to transaction ?

Mention the interface tables for item open interface and open transaction interface and also their
respective production tables.?

Is UOM maintained at master level or organization level or both?

Differentiate between intra & inter UOM class conversion with examples ?

Name all status attributes ?

What are centralized and decentralized level of control of item attributes?

In which tables the transaction details stored? at least two.

What is the prerequisite for defining unit of measure?

What is unit of measure classes? give atleast two examples. name the underlying table ?

What are stock locators and how to define them? name the tables where the stock locator
information is stored. at least two ?

Where to define interorganization transaction charges and what are the different options?

What are the prerequisite set ups for inter organization transaction?

In which table sub inventory related information for item is stored?

Define steps of assigning items to an organization ?

What is item status? name the related table ?

What is MRC? Why it is needed?

What do u mean by debit/credit memo invoices?

Types of invoices?

What do you mean by value sets ?

Difference between 2 way and 4 way matching ?

Explain Sourcing in GL ?

How will u register concurrent request ?

What are the tables in GL?

Diff between key and descriptive flexfield.?

How will U link GL with OU in Multi-org environment ?

Define MultiOrg Structure ?

What is repeating frame?

What are the important table names in purchasing?

What are the types of interfacing?

Explain registration steps of a concurrent program ?

What is lexical parameter?

How can u link a org-id with a responsibility in reports?

Where do you setup operating unit?

Where is setup of business group done?

What are documents and test cases u followed.?

What is the difference between BPA AND Contract.?

In what situation u create the BPA ?

How many types of Purchase order and what are those ?

Cycle of requisition to receiving transaction ?

What is menu.?

What is request group ?

How to create user and how u attach with responsibility ?

What is responsibility and how u attach ?

What is P2P cycle ?

What is meant by Table space?

How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP
client?

What is responsibility?

What are ad-hoc reports?

What is template?

Difference between triggers and procedures?

What are triggers?

What is FORWARD DECLARATION in Packages?

What is the package?

Can 2 functions have same name & input parameters but differ only by return datatype ?

Can functions be overloaded ?

What is function?

What is procedure?

What is Stored procedure?

What is the maximum number of statements that can be specified in a trigger statement?

Can function be overload?

Can you have two stored functions with in the same name?

Can you have two functions with the same name in a pl/sql block?

Can you define exceptions twice in same block?

What is REF Cursor?

What are Exception Handlings?

What are Attribute data types?

What are the Types of cursors?

What is a cursor?

What is Summary columns?

What is Formula Column?

What is Place holder Columns?

What is Flex mode and Confine mode?

Difference between Bind and Lexical parameters?

What is SRW Package?

What are the types of Models in the system parameters of the report?

What is AOL?

What is Sys Admin Module?

What are the requests groups?

How do u identity its name of report?

Registering parametric report?

How do u customize the Reports?

What are the validation types?

What is Value Set?

PL/SQL stored procedure parameters?

What are the User PARAMETERS in the Reports?

What is multi org?

Oracle E-Business suite?

What are profile options?

How can you call a standard interface program from sql or pl/sql code?

What should be the batch size (number of customer records) general guidelines for optimal
performance?

What is INBOUND and OUT BOUND?

What is invoice?

What is the interface?

What is SET-OF-BOOKS?

Tell me some thing about SQL-LOADER.?

What is ERP? Architecture of apps?

0 Response to "ORACLE APP TECHNICAL Interview Questions"

Post a Comment

Powered by Blogger