Interview Questions.

Q1. How Will You Approve A Quotation?

Navigate: RFQ and Quotations > Quote Analysis.

Q2. How Will You Find Out The Number Of Documents Assigned To A Particular Buyer?

Navigation: Management > Manage Buyer Workload

Select the sphere ‘Action’ > Review

Enter the alternative required search standards and press FIND

In the popup window we see the following information:

Buyer Assigned   Urgent Late Needed   Open Pos

Q3. What Are The Reasons That An Express Processor May Reject Lines Due To Validation Failures?

If the object revision, Subinventory and locator is not to be had & the entered vacation spot is very last. (Revision, Subinventory & Locator aren't available as a default from the object definition.)

If the early / overdue receipt date tolerance is surpassed & the exception control is about to Reject.

If Lot / Serial information is required.

If Ship-to- region isn't to be had & the vacation spot is Receiving.

If the area is not available for Expense vacation spot kind & the destination is very last vacation spot.

If PO Supplier & Receipt Header Supplier do no longer in shape.

If different receipts are pending for the specified cargo.

Q4. Where Will You Mention That Auto Numbering Is Required For Your Rfqs, Quotations And Po?

The mode of numbering of RFQs, Quotations and PO (Automatic or Manual and if Automatic, what have to be the starting quantity) must be described in the Purchasing Options.

Q5. Can The Original Purchase Order Be Viewed In Any Way Without Resorting To Sql, For A Revised Purchase Order?

The unique model of a revised PO can not be considered from the PO shape or PO summary shape. Information on the unique PO can be obtained from the PO_HEADERS_ARCHIVE and PO_LINES_ARCHIVE tables the usage of the PO_HEADER_ID column as a common reference the use of SQL best.

Q6. Explain The Receipt Routing?

Receipt Routing is of 3 sorts:

Direct, Standard and Inspection

In Direct once the products arrive at the destination, we directly circulate them to a specific Sub-Inv

In Standard once the goods are on the destination, we get hold of it on the receiving factor first and then flow them to the Sub-Inv.

In Inspection once the products are at the vacation spot, we get hold of it on the receiving point after which we perform inspection and thus we both take delivery of it or reject them.

Q7. What Is 2-manner, 3-way, 4-way Matching?

Oracle Payables shares buy order records out of your purchasing gadget to permit online matching with invoices. Invoiced or billed gadgets are matched to the unique buy orders to make certain which you pay handiest for the products or offerings you ordered and/or acquired.

Two–Way: Purchase order and invoice quantities should suit inside tolerance earlier than the corresponding bill may be paid.

Three–Way: Purchase order, receipt, and invoice portions should fit within tolerance earlier than the corresponding invoice can be paid.

Four–Way: Purchase order, receipt, ordinary, and bill quantities need to match inside tolerance before the corresponding invoice can be paid.

Q8. Can You Limit The Usage Of Quotation Information Only For Creating Requisitions?

While approving the Quotation, select the ‘Shipment Approved Type’ as Requisition so that the Quotation statistics will be used best for Requisitions.

The different Types are All Orders (may be used in POs and Requisitions), Purchase Agreements and Standard Pos.

Q9. How Will You Ensure That The Buyer Name Is Enforced In A Po?

Set the Purchasing Option ‘Enforce Buyer Name’ to Yes.

Q10. Is It Possible To Receive And Invoice Items Supplied By A Supplier On Hold?

Yes. A supplier Hold doesn’t prevent from receiving and invoicing Pos located earlier to the Hold.

Q11. Explain The P2p Process Flow?

Procure to pay (p2p) is a process of asking for, purchasing, receiving, paying for and accounting for goods and services.  Procure to Pay Lifecycle is one of the vital commercial enterprise Process in Oracle Applications. It’s the float that gets the goods required to do business.  It involves the tractional go with the flow of facts that is sent to a dealer in addition to the statistics that surrounds the success of the actual order and payment for the product or service.

Create a requisition>> create RFQ>> create a quotation from quote evaluation>> generate a PO>>receipt of fabric>> create Invoice in payables>> trfer to GL

Q12. How Will You Reassign The Buyer To Even Out The Workload Of Buyers?

If the repute is to be seen for a specific file, visit the respective record-defining window and spot the present day reputation on the Status vicinity.

If the repute of any document is to be determined out, cross either to the ‘Notification window or the Action history window (Navigation: Special > View Action History).

Q13. What Is An Approval Hierarchy?

Approval hierarchies can help you robotically course documents for approval. There are  sorts of approval hierarchies in Purchasing: role hierarchy and employee/manager relationships.

Q14. What Is Pay On Receipt Autoinvoice Program?

By strolling this program, we are able to mechanically create an invoice for a PO while we input a receipt for the respective PO.

Q15. When Will You Use Requisition Preferences?

Requisition Preferences are used to enter information which might be to be defaulted in a Requisition. When a couple of requisitions are to be created with many facts the identical, all the ones statistics may be entered as a Requisition Preference. The options defined might be defaulted in all new Requisition Lines as long as the user is exiting the Application. The described alternatives aren't saved to the database.

Q16. What Are The Different Currency Conversion Types?

Corporate: This is an trade fee, commonly a trendy market rule, decided via the senior economic management of an organization, to be able to be used all through the company.

Spot: An exchange price entered to perform conversions based totally on the fee on a particular date. It applies to the instant transport of a foreign money.

User Defined: An change fee this is unique whilst a foreign currency journal entry is made, that does not have a day by day exchange fee.

Q17. What Are The Documents That Use Po_headers_all?

The following are the files that use PO_HEADERS_ALL

RFQ’s, Quotations, Standard Purchase Order, Planned Purchase Order, Blanket Purchase Order and Contracts

Q18. If The Search Supplier Item Catalog Window Is Not Appearing While Invoking From The Requisition Or Po Entry Window, The System Will Use Which Criteria To Search?

The values which might be defaulted from the Requisition or PO may be used by the system to query the default source alternatives.

Q19. How Will You Ensure That Receipt Routing Mentioned In A Requisition Or Po Is Not Override At The Time Of Receiving?

Set the profile alternative ‘RCV: Routing Override’ to No.

(But in our example I am getting the profile option named as ‘RCV: Allow Routing Override’ and the Default price and person fee subject are grayed out, I am no longer capable of fill any element at consumer cost additionally. Why?)

Q20. What Is The Difference Between Eft & Wire?

EFT and WIRE are the most famous shape of electronic charge approach. EFT stands for digital fund trfer and it is one of the quickest mode of electronic price after WIRE. EFT is a batch oriented mechanism for trfering finances from one financial institution to any other due to which clearing & agreement takes around 2 to four days. On the opposite hand, WIRE is a RTGS i.E. Real time gross agreement system of making the fund trfer on real time and gross basis. Clearing and agreement takes place on the identical day. WIRE is greater costly and faster than EFT.

Q21. What Are The Major Tractions In Receiving?

Purchase Order Receipts

Internal Requisition Receipts

Inventory Inter-Org Trfer Receipts

Customer Return Receipts

Q22. Is It Possible To Use A Sourcing Rule Which Will Be Available In All The Organizations?

Provided that the Sourcing Rule is described as Global, it will likely be to be had in all organizations.

Q23. What Does Create Internal Order Conc Request Do?

Create inner order request will trfer the IR information to OM interface tables.

Q24. Is It Possible To Change The Supplier After Approving The Po?

No. The provider can’t be modified after approving the PO. If such situations get up, cancel the PO & create a brand new PO with the new provider.

Q25. Explain About Accounts Payable?

The Accounts Payable software aspect records and manages accounting statistics for all carriers. It is also an indispensable a part of the buying system: Deliveries and invoices are controlled according to companies. The system automatically triggers postings in reaction to the operative tractions. In the same manner, the gadget resources the Cash Management application issue with figures from invoices to be able to optimize liquidity making plans.

Q26. What Fields Will Print On The Purchase Order?

The following fields will be printed on a purchase order:

object description, unit of degree, amount, unit fee and total, supplier call and address, need via date, requestor call, deliver-to area and notes to dealer.

Q27. Where Will You Define The Line Type That Has To Be Defaulted While Creating A Purchase Document?

Enter the specified line kind inside the subject, ‘Line kind’ inside the Purchasing choice.

Q28. How Will You Decide The Life Of A Quotation To Be Expired After A Certain Period?

While approving the Quotation, enter an ‘Effective To’ date, so that the Quotation will no longer be available for reference after the entered date.

Q29. Is It Possible To Create A Po From An Internal Requisition?

No. PO can’t be created from Internal Requisition.

Q30. What Is The Use Of Sourcing Rule?

The planning system to create Purchase Requisition for Buy objects & Internal Requisitions for Make Items makes use of a Sourcing Rule.

Q31. Is It Possible To Access A Purchase Document Currently Under Approval Process Using The Entry Window By Anybody As Per The Access Level Nor Security Level?

No. Nobody can get entry to it through the Entry window.

Q32. What Factors Decide Whether The Requisition Created By The System Is Internal Or Purchase?

Sourcing : Internal or Supplier

Make / Buy : Make or Buy

Q33. An Approved Supplier Can Perform Which Four Activities (business Rules)?

PO Approval

Sourcing

Schedule Confirmation

Manufacture Link To Distributor

Q34. How Many Types Of Purchase Order Types/agreements Are There?

Standard Purchase Order: You normally create standard purchase orders for one-time buy of various gadgets. You create preferred purchase orders while you know the information of the products or offerings you require, estimated expenses, portions, shipping schedules, and accounting distributions. If you use encumbrance accounting, the acquisition order can be weighted down due to the fact that the required facts is thought

Planned PO : A deliberate purchase order is a protracted-term agreement committing to buy it

objects or services from a unmarried supply. You need to specify tentative shipping schedules and all info for items or services that you need to buy, which includes rate account, quantities and envisioned cost.

EX: Buying goods for Christmas from a particular dealer.

Contract PO : You create contract buy settlement together with your dealer to agree on specific terms and conditions without indicating the goods and services that you will be buying i.E. For $ quantity you have to deliver this a great deal amount. You can later difficulty trendy PO referencing your contracts and you could encumber those purchase orders if you use encumbrance accounting.

Blanket PO: You create blanket purchase agreements when you realize the element of products or offerings you plan to buy from a selected supplier in a duration , but you do not yet recognize the detail of your transport schedules. You can use blanket purchase agreements to specify negotiated costs for your objects earlier than definitely shopping them.

A Blanket Purchase Agreement is a form of settlement among the you and ur dealer about the charge at which you'll purchase the gadgets from the dealer in future. Here you input the price of the object no longer the amount of the gadgets. When you create the release you enter the amount of the gadgets. The charge is not updatable in the launch. The quantity * charge makes the Released Amount. Now assume your agreement together with your dealer is such that you could most effective purchase the items well worth a hard and fast amount against the agreement.

Q35. What Are The Different Purchasing Modes In Receiving?

There are three modes:

Online: Receipts are processed on-line. If there are any errors, they are proven at the FORM itself, and don’t permit you to IGNORE and PROCEED.

Immediate: Receipts are processed immediately, however no errors are proven. Errors are recorded in REC_TRANSACTION_INTERFACE desk.

Batch: Receipts are processed in batch, however no mistakes are proven. Errors are recorded in REC_TRANSACTION_INTERFACE table.

Note: In all of the above two cases, it requires Receiving Traction Processor to be run periodically.

Q36. What Are The Base Tables That Are Affected When You Create A P.O?

PO_HEADERS_ALL (SEGMENT1 column in this table represents the Document variety)

This table stores header facts of a Purchasing Document. You need one row for each record you create.

PO_LINES_ALL:

This table shops the road statistics of a Purchasing Document

PO_LINE_LOCATIONS_ALL:

This table consists of the data related to purchase order shipment schedules and blanket agreement charge breaks. You want one row for each time table or fee wreck you connect to a report line.

PO_DISTRIBUTIONS_ALL:

This table consists of the records related to accounting distribution of a purchase order shipment line. You need one row for each distribution line you attach to a buy order cargo

VENDORS_ALL:

This table stores the overall statistics approximately the providers

PO_VENDOR_SITES_ALL:

This table shops data about the provider websites. Each row includes the website deal with, dealer reference, shopping, price, bank, and fashionable facts.

PO_RELEASES_ALL:

This table stores records related to deliberate and blanket Purchase Order releases. Each row consists of the consumer, date, release reputation, and launch quantity. Each release have to have at least one buy order shipment.

PO_VENDOR_CONTACTS:

This table stores facts about contacts associated with Supplier website online. Each row consists of touch name and location.

PO_ACTION_HISTORY:

This table shops data approximately the approval and manage records of a Purchasing Document. This desk shops one report for each approval or control movement an employee takes on a purchase order, purchase settlement, launch or requisition.

Q37. How Will You Enter The Supplier Acceptance Of A Po?

Query for the desired PO and pick Acceptances from Special Menu. The type reputation can be described in Quick Codes (All Terms Accepted, Partially commonplace etc.)

Q38. What Is Invoice Validation Process?

Before you can pay or create accounting entries for any bill, the Invoice Validation technique must validate the bill.

Invoice Validation assessments the matching, tax, duration repute, exchange charge, and distribution information for invoices you enter and automatically applies holds to exception invoices. If an bill has a keep, you may release the hold with the aid of correcting the exception that brought about Invoice Validation to apply the preserve via updating the bill or the acquisition order, or changing the invoice tolerances.

Q39. Can You Give A Sample Process Flow For Procure To Pay Cycle?

Process float for Procure to pay will undergo two departmentsv(Commercial & Finance)

Procure – Commercial Department The following steps contain you purchased any object

Received Requisition from difficulty Department

Request for Quotation from Suppliers as a minimum three

Finalize the first-rate Quotation through retaining in thoughts about our organizations trendy

Check the Budget for the identical

Negotiate with supplier for more economic pricing and finalize the fee terms

Process the PO and ahead to the supplier to deliver the goods and services

Pay Cycle – Finance Department

The following steps need to be fulfil

Invoice have to be healthy with PO

Invoice must has all the helping documents which include PO reproduction,Delivery observe duly signed by way of receiver (our staff who authorized to acquired items / keep keeper)

If the bill is for offerings then it must be forwarded to the priority department head or challenge manager for his confirmation of labor executed and his approval

Even if it not the services bill, it must forwarded to the concern individual’s approval who -request the PO for the identical

Finance can reject the invoice if it is not budgeted and ask for the reasons.

After receiving all of the affirmation and approvals from the priority branch heads the bill will be replace in to the accounting device first for you to keep away from any duplication of Invoice and PO (it proven on accounting package if the bill is replica if not, altelast it tells you if the PO already used or cancel)

Q40. What Is A Purchase Requisition And Define Various Requisitions?

It is a formal request intended you purchased/buy something that is wanted by the corporation. It is created and authorized by way of the branch requiring the goods and services.

A purchase requisition usually consists of the outline and quantity of the goods or offerings to be purchased, a required shipping date, account number and the quantity of cash that the shopping department is allowed to spend for the products or offerings. Often, the names of cautioned deliver resources are also covered.

Basically, requisitions are of two types:

Internal requisition and buy requisition

Internal Requisitions are created if the Items are to be obtained from one Inventory place to another location in the identical business enterprise. Here the source of the requisition could be INVENTORY. There is no approval technique for internal requisition.

Purchase Requisitions are created if the goods are acquired from external suppliers. Here the supply of the requisition would be SUPPLIERS. The buy requisitions are sent for approvals.

Q41. What Is The Meaning Of Invoice?

An bill or bill is a business document issued by means of a supplier to the client, indicating the products, portions, and agreed charges for services or products the seller has supplied the purchaser. An invoice shows the purchaser have to pay the seller, in keeping with the payment phrases.

In the apartment enterprise, an invoice have to include a specific connection with the length of the time being billed, so in preference to amount, rate and bargain the invoicing amount is primarily based on amount, price, bargain and duration. Generally speakme each line of a condominium bill will confer with the real hours, days, weeks, months and many others being billed.