Interview Questions.

Question 1. Explain About Accounts Payable?

Answer :

The Accounts Payable application thing information and manages accounting data for all companies. It is likewise an indispensable part of the purchasing gadget: Deliveries and invoices are controlled in line with carriers. The device robotically triggers postings in reaction to the operative transactions. In the same way, the machine supplies the Cash Management software issue with figures from invoices with the intention to optimize liquidity planning.

Question 2. What Is The Meaning Of Invoice?

Answer :

An invoice or bill is a commercial record issued by a seller to the buyer, indicating the goods, quantities, and agreed fees for products or services the seller has supplied the purchaser. An invoice suggests the buyer should pay the vendor, consistent with the price phrases.

In the rental industry, an bill ought to include a particular connection with the length of the time being billed, so in preference to quantity, fee and cut price the invoicing amount is primarily based on quantity, charge, cut price and duration. Generally talking each line of a condo bill will talk to the real hours, days, weeks, months and so on being billed.

Oracle Apps ERP Interview Questions
Question 3. Can You Give A Sample Process Flow For Procure To Pay Cycle?

Answer :

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

Procure – Commercial Department The following steps involve to procure any item

Received Requisition from challenge Department
Request for Quotation from Suppliers at least three
Finalize the pleasant Quotation via preserving in thoughts approximately our agencies fashionable
Check the Budget for the same
Negotiate with provider for greater financial pricing and finalize the payment phrases
Process the PO and forward to the dealer to deliver the products and services
Pay Cycle – Finance Department

The following steps need to be fulfil

Invoice ought to be match with PO
Invoice should has all of the supporting documents inclusive of PO replica,Delivery be aware duly signed by receiver (our team of workers who legal to acquired items / keep keeper)
If the bill is for services then it need to be forwarded to the concern department head or venture manager for his confirmation of labor executed and his approval
Even if it now not the services bill, it should 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 motives.
After receiving all of the affirmation and approvals from the priority department heads the invoice can be replace in to the accounting device first for you to avoid any duplication of Invoice and PO (it shown on accounting package deal if the bill is duplicate if not, altelast it tells you if the PO already used or cancel)
Question four. What Is The Difference Between Eft & Wire?

Answer :

EFT and WIRE are the most popular shape of electronic fee approach. EFT stands for digital fund transfer and it's miles one of the quickest mode of digital fee after WIRE. EFT is a batch orientated mechanism for transfering funds from one bank to every other because of which clearing & settlement takes round 2 to four days. On the other hand, WIRE is a RTGS i.E. Real time gross agreement gadget of making the fund switch on actual time and gross foundation. Clearing and settlement occurs at the same day. WIRE is greater high priced and faster than EFT.

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

Answer :

Standard Purchase Order: You typically create general purchase orders for one-time buy of diverse objects. You create trendy purchase orders while you recognize the info of the products or services you require, envisioned prices, portions, transport schedules, and accounting distributions. If you use encumbrance accounting, the acquisition order can be laden considering the fact that the specified records is understood

Planned PO : A planned purchase order is a long-term agreement committing to shop for it

items or services from a single supply. You should specify tentative delivery schedules and all details for goods or services which you want to shop for, which includes fee account, quantities and estimated cost.

EX: Buying goods for Christmas from a specific supplier.

Contract PO : You create agreement buy agreement with your supplier to agree on specific terms and situations with out indicating the products and offerings that you may be shopping i.E. For $ quantity you ought to supply this much amount. You can later difficulty general PO referencing your contracts and you could encumber those purchase orders if you use encumbrance accounting.

Blanket PO: You create blanket purchase agreements while you understand the detail of products or offerings you plan to shop for from a specific dealer in a duration , however you do no longer but know the detail of your transport schedules. You can use blanket buy agreements to specify negotiated costs for your items earlier than virtually shopping them.

A Blanket Purchase Agreement is a type of settlement among the you and ur dealer about the rate at which you may purchase the gadgets from the supplier in future. Here you enter the rate of the item not the quantity of the objects. When you create the release you input the amount of the items. The fee isn't always updatable in the release. The amount * fee makes the Released Amount. Now think your settlement together with your dealer is such that you may simplest buy the objects really worth a fixed amount towards the settlement.

Oracle E-Bussiness Suite Interview Questions
Question 6. Explain The P2p Process Flow?

Answer :

Procure to pay (p2p) is a manner of asking for, purchasing, receiving, deciding to buy and accounting for items and offerings.  Procure to Pay Lifecycle is one of the important business Process in Oracle Applications. It’s the go with the flow that receives the products required to do commercial enterprise.  It entails the transactional glide of information that is despatched to a dealer as well as the statistics that surrounds the fulfillment of the actual order and price 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>> transfer to GL

Question 7. What Is A Purchase Requisition And Define Various Requisitions?

Answer :

It is a formal request meant you obtain/purchase something this is wished by way of the employer. It is created and authorised by the branch requiring the products and services.
A purchase requisition normally incorporates the description and quantity of the products or offerings to be bought, a required transport date, account wide variety and the quantity of cash that the buying branch is permitted to spend for the products or services. Often, the names of suggested deliver resources are also included.

Basically, requisitions are of two sorts:

Internal requisition and buy requisition

Internal Requisitions are created if the Items are to be acquired from one Inventory region to any other region within the equal agency. Here the supply of the requisition could be INVENTORY. There is no approval process for inner requisition.
Purchase Requisitions are created if the goods are received from outside suppliers. Here the source of the requisition could be SUPPLIERS. The buy requisitions are sent for approvals.
Oracle BPM Interview Questions
Question eight. What Are The Base Tables That Are Affected When You Create A P.O?

Answer :

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

This table shops header statistics of a Purchasing Document. You want one row for each document you create.

PO_LINES_ALL:

This table stores the line statistics of a Purchasing Document

PO_LINE_LOCATIONS_ALL:

This desk contains the facts associated with purchase order cargo schedules and blanket agreement fee breaks. You need one row for each time table or price destroy you connect to a record line.

PO_DISTRIBUTIONS_ALL:

This desk carries the statistics associated with accounting distribution of a buy order shipment line. You need one row for each distribution line you attach to a buy order shipment

VENDORS_ALL:

This desk stores the general facts approximately the providers

PO_VENDOR_SITES_ALL:

This desk shops facts approximately the dealer websites. Each row includes the site deal with, supplier reference, buying, charge, bank, and popular facts.

PO_RELEASES_ALL:

This desk stores information associated with deliberate and blanket Purchase Order releases. Each row consists of the customer, date, launch fame, and release wide variety. Each release ought to have as a minimum one purchase order shipment.

PO_VENDOR_CONTACTS:

This table shops statistics approximately contacts associated with Supplier web site. Each row includes touch call and placement.

PO_ACTION_HISTORY:

This desk shops facts about the approval and manage records of a Purchasing Document. This table shops one document for every approval or control movement an employee takes on a buy order, buy settlement, release or requisition.

Question 9. What Is 2-way, three-manner, 4-manner Matching?

Answer :

Oracle Payables stocks buy order facts from your shopping gadget to permit on line matching with invoices. Invoiced or billed items are matched to the authentic purchase orders to ensure which you pay most effective for the goods or offerings you ordered and/or obtained.

Two–Way: Purchase order and bill portions have to fit within tolerance before the corresponding invoice may be paid.

Three–Way: Purchase order, receipt, and invoice portions should match inside tolerance before the corresponding invoice can be paid.

Four–Way: Purchase order, receipt, conventional, and bill quantities ought to suit within tolerance before the corresponding invoice can be paid.

Oracle Forms And Reports Interview Questions
Question 10. What Are The Major Transactions In Receiving?

Answer :

Purchase Order Receipts
Internal Requisition Receipts
Inventory Inter-Org Transfer Receipts
Customer Return Receipts
Question 11. What Is Pay On Receipt Autoinvoice Program?

Answer :

By jogging this software, we are able to robotically create an invoice for a PO when we input a receipt for the respective PO.

Oracle BI Publisher Interview Questions
Question 12. What Is Invoice Validation Process?

Answer :

Before you can pay or create accounting entries for any invoice, the Invoice Validation procedure should validate the bill.

Invoice Validation exams the matching, tax, duration status, alternate price, and distribution statistics for invoices you input and mechanically applies holds to exception invoices. If an invoice has a preserve, you can release the maintain through correcting the exception that brought about Invoice Validation to apply the hold by means of updating the invoice or the acquisition order, or changing the bill tolerances.

Oracle Apps ERP Interview Questions
Question 13. What Is An Approval Hierarchy?

Answer :

Approval hierarchies allow you to robotically route files for approval. There are  sorts of approval hierarchies in Purchasing: role hierarchy and employee/manager relationships.

Question 14. What Are The Documents That Use Po_headers_all?

Answer :

The following are the files that use PO_HEADERS_ALL

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

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

Answer :

The authentic version of a revised PO cannot be considered from the PO shape or PO summary shape. Information at the unique PO may be obtained from the PO_HEADERS_ARCHIVE and PO_LINES_ARCHIVE tables using the PO_HEADER_ID column as a not unusual reference the usage of SQL best.

Oracle Application Framework Interview Questions
Question sixteen. Can We Automatically ‘near’ The Purchase Order Without Receiving The Full Quantity?

Answer :

The Receipt Close Tolerance lets you specify a amount percent inside which Purchasing closes a partially received shipment. For instance, in case your Receipt Close Tolerance is five% and also you acquire ninety six% of an anticipated cargo, Purchasing mechanically closes this shipment for receiving.

Question 17. When Does A Purchase Order Line Get The Status ‘closed For Receiving’?

Answer :

Goods have been obtained at the gadget in opposition to this line but an invoice has no longer been matched to the order.

Oracle Apex Interview Questions
Question 18. Can We Match An Invoice Against A Line Even When It Is ‘closed For Invoicing’?

Answer :

The Close for invoicing repute does not save you you from matching an invoice to a buy order or to a receipt.

Oracle E-Bussiness Suite Interview Questions
Question 19. What Does Create Internal Order Conc Request Do?

Answer :

Create inner order request will transfer the IR info to OM interface tables.

Question 20. Explain The Receipt Routing?

Answer :

Receipt Routing is of 3 sorts:

Direct, Standard and Inspection

In Direct once the products arrive at the vacation spot, we at once move them to a selected Sub-Inv
In Standard as soon as the goods are on the destination, we receive it on the receiving factor first after which move them to the Sub-Inv.
In Inspection as soon as the goods are on the vacation spot, we acquire it on the receiving factor after which we perform inspection and hence we either accept it or reject them.
Oracle Apps DBA Interview Questions
Question 21. What Are The Different Purchasing Modes In Receiving?

Answer :

There are 3 modes:

Online: Receipts are processed on line. If there are any mistakes, they are shown at the FORM itself, and don’t allow you to IGNORE and PROCEED.

Immediate: Receipts are processed at once, however no errors are proven. Errors are recorded in REC_TRANSACTION_INTERFACE table.

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

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

Question 22. What Fields Will Print On The Purchase Order?

Answer :

The following fields might be published on a purchase order:

item description, unit of measure, amount, unit rate and total, dealer name and deal with, want with the aid of date, requestor call, supply-to place and notes to provider.

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

Answer :

No. PO can’t be comprised of Internal Requisition.

Oracle D2K Interview Questions
Question 24. What Factors Decide Whether The Requisition Created By The System Is Internal Or Purchase?

Answer :

Sourcing : Internal or Supplier

Make / Buy : Make or Buy

Oracle BPM Interview Questions
Question 25. An Approved Supplier Can Perform Which Four Activities (business Rules)?

Answer :

PO Approval
Sourcing
Schedule Confirmation
Manufacture Link To Distributor
Question 26. How Will You Enter The Supplier Acceptance Of A Po?

Answer :

Query for the desired PO and pick out Acceptances from Special Menu. The type acceptance may be described in Quick Codes (All Terms Accepted, Partially typical and so forth.)

Oracle Reports Builder Interview Questions
Question 27. How Will You Approve A Quotation?

Answer :

Navigate: RFQ and Quotations > Quote Analysis.

Oracle Forms And Reports Interview Questions
Question 28. How Will You Decide The Life Of A Quotation To Be Expired After A Certain Period?

Answer :

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

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

Answer :

While approving the Quotation, pick out the ‘Shipment Approved Type’ as Requisition so that the Quotation facts will be used handiest for Requisitions.

The other Types are All Orders (can be utilized in POs and Requisitions), Purchase Agreements and Standard Pos.

Oracle Purchasing Interview Questions
Question 30. Where Will You Mention That Auto Numbering Is Required For Your Rfqs, Quotations And Po?

Answer :

The mode of numbering of RFQs, Quotations and PO (Automatic or Manual and if Automatic, what should be the starting wide variety) should be described in the Purchasing Options.

Question 31. While Creating The Purchase Documents In The ‘auto Create’ Mode, Within It, There Is A ‘manual Mode’. This Manual Mode Is Required For What?

Answer :

If the numbering approach selected for the document being created is manual, we are able to enter the document variety in the ‘Manual’ mode. More over, we will determine which Requisition strains we need to combine and where we want them to seem on the file.

Question 32. Is It Possible To Enter Price Break Information In An Rfq, If The Rfq Header Type Is Selected ‘bid’?

Answer :

No. The Price Break window can be to be had simplest for Catalog Quotation Class.

Question 33. What Are The Different Currency Conversion Types?

Answer :

Corporate: This is an trade charge, generally a trendy market rule, decided by way of the senior economic management of an business enterprise, on the way to be used at some stage in the enterprise.

Spot: An trade charge entered to carry out conversions primarily based on the fee on a specific date. It applies to the instantaneous transport of a foreign money.

User Defined: An exchange charge this is particular while a overseas foreign money journal access is made, that does not have a day by day alternate price.

Oracle BI Publisher Interview Questions
Question 34. How Will You Ensure That Receipt Routing Mentioned In A Requisition Or Po Is Not Override At The Time Of Receiving?

Answer :

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 value and person price discipline are grayed out, I am not capable of fill any component at person price also. Why?)

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

Answer :

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

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

Answer :

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

Oracle Application Framework Interview Questions
Question 37. How Will You Find Out The Number Of Documents Assigned To A Particular Buyer?

Answer :

Navigation: Management > Manage Buyer Workload

Select the sector ‘Action’ > Review

Enter the alternative required search standards and press FIND

In the popup window we see the subsequent information:

Buyer Assigned   Urgent Late Needed   Open Pos

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

Answer :

If the repute is to be seen for a specific file, go to the respective report-defining window and notice the present day fame at the Status location.

If the reputation of any record is to be located out, cross both to the ‘Notification window or the Action records window (Navigation: Special > View Action History).

Question 39. What Is The Use Of Sourcing Rule?

Answer :

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

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

Answer :

Provided that the Sourcing Rule is defined as Global, it'll be available in all companies.

Oracle Apex Interview Questions
Question 41. 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?

Answer :

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

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

Answer :

If the item revision, Subinventory and locator isn't available & the entered vacation spot is very last. (Revision, Subinventory & Locator aren't available as a default from the item definition.)
If the early / past due receipt date tolerance is surpassed & the exception manipulate is ready to Reject.
If Lot / Serial facts is needed.
If Ship-to- location isn't to be had & the vacation spot is Receiving.
If the place isn't always to be had for Expense vacation spot kind & the destination is final destination.
If PO Supplier & Receipt Header Supplier do no longer match.
If different receipts are pending for the required shipment.
Oracle Apps DBA Interview Questions
Question forty three. 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?

Answer :

The values which might be defaulted from the Requisition or PO could be used by the device to question the default source options.

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

Answer :

No. The supplier can’t be changed after approving the PO. If such conditions arise, cancel the PO & create a brand new PO with the new dealer.

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

Answer :

Enter the desired line type in the discipline, ‘Line type’ inside the Purchasing choice.

Question 46. When Will You Use Requisition Preferences?

Answer :

Requisition Preferences are used to enter information that are to be defaulted in a Requisition. When multiple requisitions are to be created with many information the same, all those data can be entered as a Requisition Preference. The choices defined may be defaulted in all new Requisition Lines so long as the consumer is exiting the Application. The described choices aren't stored to the database.