GeekInterview.com
Series: Subject: Topic:

Oracle Apps Technical Interview Questions

Showing Questions 1 - 20 of 145 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Allow dynamic inserts

Asked By: oraclehrmsab60 | Asked On: May 23rd, 2013

Why we enable allow dynamic inserts and what is the purpose?

Fast formula

Asked By: oraclehrmsab60 | Asked On: May 23rd, 2013

What are the types of fast formulas available in hrms payroll and their details?

What is the difference between organization_id and org_id ?

Asked By: ramohanreddy05 | Asked On: Oct 13th, 2011

Answered by: nilanjan de on: May 22nd, 2013

Organization id is mainly related to Inventory Organization and Org_id is belongs to Operating Unit. whenever we are doing any transaction based on different inventory organization in the business tha...

Answered by: Ramana on: May 13th, 2012

org_id is belongs to operating unit level.It will be available on modules like PO, AP, AR,...... organization_id belongs to inventory level.It will be available on modules like INVENTORY,BOM,WIP

What do you mean by hz_ in customer tables ?

Asked By: Interview Candidate | Asked On: Aug 15th, 2005

Answered by: Sridhar on: May 9th, 2013

HZ_ stands for human Zone

Answered by: suresh on: Aug 16th, 2007

HZ is a profile option. All the customer related tables starts with HZ

What is set of books ? What are the four conditions when you change your sobs?

Asked By: Interview Candidate | Asked On: Aug 31st, 2005

Answered by: balakotireddy on: Apr 26th, 2013

In R12 setbooks are called as ledgers

setofbook contain 3c->currency,calendar,chartofaccounts.

ledgers contain 4c->currency,calendar,chartofaccounts,conversion methods

Answered by: Adireddy on: Feb 15th, 2012

In R12 Set Of Books(SOB) means combination of

1)Chart of Accounts

2)currency

3)calender

4) Sub Ledger Account(SLA).

The above 4 conditions used to change the SOBs

Inventory module q.

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

What is the item category? What is the use of it?

Answered by: Divya Gaba on: Apr 24th, 2013

Item Category is grouping of items. Item Category Sets is grouping of Item Categories. An item can belong to any number of category sets. We can assign item to one category within each category set. T...

Answered by: Raaj Kiran on: Dec 24th, 2012

mtl_item_categories

How to register tables and columns in aol?

Asked By: Interview Candidate | Asked On: Aug 31st, 2005

Answered by: pandu golla on: Apr 4th, 2013

Register table by using AD_DD.Register_table
and
Register column by using AD_DD.Register_column APIs

Answered by: sandeep24410 on: Jul 6th, 2012

Table registration: note: connect to custom schema (wip) --wip/wip@prod 1) Create table custom_vendors 2) Grant all on custom_vendors to apps; 3) Conn apps/apps@prod 4) Create public synonym custo...

Can anybody suggest me how can the multi org. Be set up?

Asked By: Debajyoti | Asked On: Dec 19th, 2005

Answered by: bala koti reddy on: Feb 21st, 2013

In R12

begin
mo_global.set_policy_context(s,orgid);
end;

Answered by: ramesh on: Apr 19th, 2012

"sql SELECT COUNT(*) FROM PO_HEADERS_ALL --OUTPUT =10835 SELECT COUNT(*) FROM PO_HEADERS --OUTPUT = 0 "sql DECLARE V_ORG_ID NUMBER :=FND_PROFILE....

Manadatory user exits in Oracle Apps reports

Asked By: anishajain | Asked On: Mar 6th, 2008

What are the manadatory user exits in Oracle Apps reports?

Answered by: CHALAM on: Jan 29th, 2013

srwinit and srwexit

Answered by: marla.113 on: May 23rd, 2012

There are no mandatory exits. Without using User Exit, we can run the report in Apps.

Manadatory parameters in Oracle Apps reports

Asked By: anishajain | Asked On: Mar 6th, 2008

What are the manadatory parameters in Oracle Apps reports?

Answered by: RAAJ on: Dec 24th, 2012

errbuf,retcode are the mandatory parameters...

Answered by: marla.113 on: May 23rd, 2012

There are no mandatory parameters . All parameters are optional including p_conc_request_id.

Item revision

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

What is the item revision?

Answered by: Krishh on: Dec 26th, 2012

Item Revision:

Suppose we have an item and if it requires some changes or adding something like a new item/modification in the qty at that time we a Revision takes place called as Item Revision. It is stored in MTL_ITEM_REVISIONS.

Thanks,
Krishh

Mtl_system_items_b and mtl_system_items_kfv

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

What is the difference between mtl_system_items_b and mtl_system_items_kfv?

Answered by: rohit on: Dec 5th, 2012

_b is the item master table and _kfv is the flex field view where we can get the concatenated segments

Answered by: ganesh rongali on: Jul 16th, 2012

b for base table nd kfv for view(key flex view)

Lot and serial controlled

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

What is meant by lot and serial controlled item?

Answered by: priya on: Sep 25th, 2012

Serial controlled means a serial number is associated to each piece of the item.Attribue1 in table mtl_system_items defines if the item is serial controlled.

Master vs child organization details

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

Which table holds the master vs child organization details?

Answered by: priyanka on: Aug 2nd, 2012

mtl_parameters , ORG_ORGANIZATION_DEFINITIONS

Answered by: priyanka on: Jul 31st, 2012

mtl_system_items_b consists all master and child items details

Inventory

Asked By: jagadeesh9 | Asked On: Jul 14th, 2008

How to restrict the item in inv?

Answered by: GANESH RONGALI on: Jul 16th, 2012

dropshipment

Answered by: teja on: Feb 23rd, 2012

Uncheck purchasing

PO form

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

Which attributes need to be checked in order to get the item in PO form?

Answered by: PRAHASITH on: Jul 15th, 2012

inventory
purchasing
bom
om

Master organization doesn’t have any child organizations

Asked By: sandeep24410 | Asked On: Jul 6th, 2012

If master organization doesn’t have any child organizations, this will be stored in mtl_parameters or not?

Retrieve one particular row

Asked By: kuncharapu_ashu | Asked On: Sep 12th, 2011

Suppose if there are 100 rows and you need to retrieve one particular row without using where clause?

Answered by: ptmich on: May 28th, 2012

select rownum=1 from table;

Answered by: sss on: Apr 4th, 2012

Using Group BY and Having clause

How to implement multiorg in reports and @SQL prompt

Asked By: thyt | Asked On: Nov 18th, 2011

Answered by: kvijay5924 on: Mar 6th, 2012

In 11i
BEGIN
FND_CLIENT_INFO.SET_ORG_CONTEXT(204);
END;

Answered by: mechrul on: Jan 23rd, 2012

Earlier in 11i, it was dbms_application_info.set_client_info(). But in R12, it is MO_GLOBAL.SET_POLICY_CONTEXT(S,101); --where S-For Single organization

Child field is placed in parent frame

Asked By: syedrafi123 | Asked On: Jan 19th, 2012

There is parent frame and for that parent frame there is child frame, suppose child field is placed in parent frame what message you will get.

Answered by: kvijay5924 on: Mar 6th, 2012

Think child frame could be repeating frame. If so it show no message.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.