Oracle Apps Technical Interview Questions

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...

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

HZ_ stands for human Zone

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

In R12 setbooks are called as ledgers

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

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

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

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...

mtl_item_categories

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

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...

In R12

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

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

srwinit and srwexit

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

errbuf,retcode are the mandatory parameters...

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

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

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

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

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.

mtl_parameters , ORG_ORGANIZATION_DEFINITIONS

mtl_system_items_b consists all master and child items details

dropshipment

Uncheck purchasing

inventory
purchasing
bom
om

select rownum=1 from table;

Using Group BY and Having clause

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

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

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