Oracle Apps Basics Interview Questions

Credit memo is used to reduce the balance due for a transaction and Debits that we assign to a customer to collect additional charges like freight charges,taxes,or finance charges.

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

Informatics Outsourcing is an Offshore Data Management service company. Data Management Service includes all types of Data Conversion, File Conversion, XML Conversion, HTML Conversion,SGML Conversion,...

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

There are other ways too like we can use sql*loader or an fnd file

UTL and external tables can be used to load data

The item moving from staging area to sub inventory is called as PICK RELEASE

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

to run a application in oracle application

we have 4 type

Sorry Dear , I haven't seen yur Hierarchy. Yea it is correct.

User->Application->Responsibilty->Site

you can fetch the more rows and insert into another table easily

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

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.

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

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