Oracle Apps Basics Interview Questions

UTL and external tables can be used to load data

If the data file is a *.dat file then the Oracle front end( i.e Interface Utility) can be used to load the data to Staging table.

Customization is making the changes to the Oracle applications using Oracle tools like Forms, Reports etc....

Personalization is just changing the properties with out making any changes.

Customization means making few changes according to client requirement to an already existing product. Personalization means complete devolpment on frontend and backend.

Pick Release finds and release the eligible delivery line that meet the release criteria and create move orders.

Pick release is the process by which the items on the sales order are taken out from inventory. The flow is as follows:1) When an order is booked, based on the setups, the lines are scheduled and they...

Cursor is a private SQL memeory area which retrieving multiple data or record by record through single variable and selected variable.

Generally we use cursor to get multiple Result. and Specify a particular name of storage area . by cursor we know that active set. where is position of cursor.

There are five report triggers

*BEFORE PARAMETER FORM
*AFTER PARAMETER FORM
*BEFORE REPORT
*BETWEEN PAGES
*AFTER REPORT

RCV_SHIPMENT_HEADERS

RCV_TRANSACTIONS

RCV_SHIPMENT_LINES

In case of any errors, i.e. if the receipt is not processed you can check in the below tables

RCV_TRANSACTIONS_INTERFACE

RCV_HEADERS_INTERFACE

PO_INTERFACE_ERRORS ( Reason its stuck in Interface)

RCV_SHIPMENT_HEADERS

RCV_TRANSACTIONS

RCV_SHIPMENT_LINES

In case of any errors, i.e. if the receipt is not processed you can check in the below tables

RCV_TRANSACTIONS_INTERFACE

RCV_HEADERS_INTERFACE

PO_INTERFACE_ERRORS ( Reason its stuck in Interface)

Thanks,
Raghav

Suppliers: who sells the goods to the vendor whereas vendor sells the material to the client or end customer.for example x company making a component for their vendors.The same vendor sell to their client with OH's

When a company needs a product, it places an offer to vendor(s). The vendor(s) on the other hand will place bits (amounts based on quality), this is evaluated by the company and a final vendor select...

We have to select "all" only then old supplier pending invoices, PO's data will be moved to the new supplier.and buyers can communicate to the new supplier details.

LINE_ID from OE_ORDER_LINES_ALL  is stored in INTERFACE_LINE_ATTRIBUTE6 in RA_CUSTOMER_TRX_LINES_ALL

AR and OE are related by the following keys:

1. sales_rep_id (oe_order_headers_all <-> ra_salesreps_all)

2. invoice_to_org_id, site_use_id (oe_order_headers_all <-> ra_site_users_all)

Qualifier means that behavioursegment qualifier means that it tells us abt behaviour of a segmentsegment qualifiers arefor company  ---   Balancing segmentDepartment   --- cos...

segment qualifier are used to identify a particular segement within key flexfield

In RCV_TRANSACTIONS Table  there is a field Invoice_status_code which shows whether invoice is made or not against the receipt.

In MultiOrg Environment, we can have 1+7 set of books (SOB) and hence can have 1+7 Chartsof Accounts or Accounting Flex fields.

No. You cannot have more than one Accounting Flexfields for a Set of Books in AR. Accounting Flexfield defines a Chart of Accounts. Having 2 different Accounting Flexfield structure implies that they ...

Data Migration is a process of moving required (and most often very large) volumes of data from our clients' existing systems to new systems. Existing systems can be anything from custom-built IT infr...

Data Conversion refers to the movement of data from a legacy system or application, to a replacement application or sub-system.Data migration refers to movement of data from one database to another da...

A credit memo is an invioce that reduces the amount due to a  customer's invioce. This usually occurs becuase the customer has returned some of the goods (goods returned ) the adjustments ca...

Credit memo In Oracle Payables and Oracle Projects, a document that partially or fully reverses an original invoice.  Debit memos Debits that you assign to a customer to collect additional c...

These are Global Scheduling Rules or Logistics Rules use for Scheduling the Order in Order Management. 

Full life cycle implementation involves various cross functional team and Project management team working together through different PHASES of Oracle Application life cycle (case: Legacy system roll o...

Note: Please correct,if there are any mistakesFull Life Cycle means implementing a project from the begining to the production and maintenance stage.(1) System Planning:     &...

No, we cannot have single Inventory with multiple Operating units.Let us suppose if it happened then it wlll screwup material transactions. Material transaction will not be able to provide correct inf...

Once the item is assigned to an Organization, we can remove the same. It can be done thru Organization Item.. query for the item and make in "Inactive". Importantly it cannot be done by unchecking the Organization Assignment check box - Santosh Pandey

KFFs in Receivables (AR):

- Sales Tax Location (code: MKTS)
- Territory (code: CT#)

You might also want to know the KFFs in ASSETS, which are:

- Asset KFF (Code: KEY#)
- Category (Code: CAT#)
- Location (Code: LOC#)

Hope it helps.
Cheers!

There are 2 Kff's are there in AR1.Sales Tax Location FF-this is a mandatory one to implement2.Territory- its an optional one.