Oracle Purchasing Interview Question (Source http://www.brainbeez.com/)
---------------------------------------------------
1) What are the
different purchase order types in Oracle Purchasing?
There are 4 type of PO. Standard, Planned, Blanket and
Contract. Below is the difference between them
 |
| Source : Metalink |
2) Can a requisition
be encumbered?
Yes, enable requisition encumbrance from PO>setup>organization>
Financial options
3) What is the
difference between a scheduled release and blanket release?
A schedule release is created against Planned PO and Blanket
release against the Blanket PO
4) On a contract
purchase agreement qty can be specified?
No, You cannot enter lines of Contract PO
5) On a blanket
purchase agreement qty can be specified?
No, Quantity field is grey out.
6) Quotation analysis
is an automated process in oracle purchasing?
7) Vendor analysis
can be performed in oracle purchasing?
8) How many types of
purchase requisitions are there?
2 Types : Purchase and Internal
9) Rfq's can be
created based on unapproved purchase requisition?
Yes you can auto create a RFQ from an unapproved requisition
10)During autocreate
process from req to rfq supplier list specification is mandatory?
NO
11)Requisitions can
be imported into the system from legacy softwares?
Yes, you can import them in PO_REQUISITIONS_INTERFACE_ALL
12)What is the
requisition interface table name?
PO_REQUISITIONS_INTERFACE_ALL
13)Is workflow
integrated with oracle purchasing?
Yes
14)What workflow
process is executed whenever the purchasing documents are approved?
PO Approval Top Process
15)Can you import
purchase orders ? if yes what is the program name?
Yes, Import Standard Purchase Orders program
16)Purchase orders can
be created without base quotation documents?
Yes, you can manually enter PO
17)How many types of
quotations are there?
Three Types. Standard, Bid and Catalog
18)Can a standard
purchase order be associated with contract purchase agreement ?
Yes, against Contract Po you make Standard PO
19)Scheduled releases
are issued against contract purchase agreements?
No, Standard PO issued against Contract Agreement.
20)Blanket releases
are recorded against planned purchase orders?
No Scheduled releases recorded against Planned PO
21)Multiple shipment
lines can be existing for a single purchase order line?
Yes, Very True
22)Quantity received
against po is updated in the po document?
Yes, you can see it from PO summary form
23)Cancellation of po
cancels the requisition?
Depends on Option selected in Purchasing options.
24)Releases can be
encumebred?
I don't Know. You tell me? Post a comment below
25)Where do you set
the encumbrance options in oracle purchasing system?
Financial Options
26)Oracle purchasing
system can be run without setting up the purchasing options?
No, that is the First thing you should to setup when setting up purchasing
27)A purchase order
can be based on multiple quotations?
Yes
28)A rfq can be based
on multiple requisition lines?
Yes
29)A purchase order
distribution can be based on multiple shipment lines?
Each shipment line has its own distribution
30)Receiving controls
can be specified in requisition document?
No
31)How many types of
receipt routings are available?
Three. Standard, Direct and inspection Required
32)Goods receipt
information is recorded in oracle purchasing system?
Inventory and purchasing both
33)Through workflow
purchase orders can be created?
Yes
34)Purchased order
revisions can be recorded?
Yes
35)What are the
tables involved in for storing the po information?
PO_headers_all
PO_lines_all
PO_line_locations_all
PO_distributions_all
PO_releases_all
36)Supplier lists
must be mandatorily setup for purchasing system?
37)Purchasing
documents can be updated once they are approved?
Yes, Revision will be created after that
38)Supplier database
is owned by oracle payables?
Yes, True in R12
39)Is it possible to
reverse a purchase order line ?
No. You can cancel it
40)What is ASL?
Approved Supplier list
41)What is ASN?
Advance Shipment Notice
42)What is the copy
document feature?
Used to create a new doc by duplicating/copy from another doc
43)What are the
different statuses for the purchasing periods?
Open/Close/Permanently Close
44)What are the
tables for supplier database?
AP_SUPPLIERS Replaced PO_VENDORS table.
AP_SUPPLIER_SITES_ALL
IBY_EXTERNAL_PAYEES_ALL Stores Payee(supplier) information.
HZ_PARTIES Stores Party data of suppliers.
HZ_PARTY_SITES Stores Party site data of supplier sites.
45)Oracle purchasing
owns the job and position flexfields?
HRMS owns following key flex fields
Grade flexfield, Job flexfield, Position flexfield, People Group flexfield
46)Employees
information is maintained in oracle purchasing system?
No, Its maintained in HRMS
47)To approve a
purchase order the user must be a buyer?
Not Necessary
47)Employees must be
assigned to application user definitions in system administration?
Yes
48)Supplier number
generation by default is auotmatic?
You can set it in Payables.
49)Where do you set
the emloyee numbering options?
While defining Business Group Information
50)Inventory
organisation must be setup to run purchasing module?
Yes
Thanks
Mandeep Kumar
