Q/A | Details |
Question | How many types of Invoices we can create in Oracle Payables? |
Answer | A. Standard B. Debit Memo C. Credit Memo D. Pre-Payment E. Expense Report F. Withholding Tax Invoice G. Miscellaneous Invoice |
Question | Describe the 4-Way Matching? |
Answer | 2 – Way Matching: The Invoice Amount Should match with PO, (Invoice with PO) 3 – Way Matching: The Receipts Should match with Invoice, (Invoice, PO with Receipts) 4 – Way Match: The Goods Should match with Inspection/Accepted (Invoice, PO, Inspections & Receipts) |
Question | How many Holds we have? |
Answer | System Hold and Manual Hold. Payables lets you apply holds manually on an invoice, Payments etc to prevent the payment from being made or to prevent the accounting entries to be created etc. Some of the Payable holds are -- Invoice Hold, Accounts Hold, Funds Hold, Matching Hold, Variance Hold, Misc hold. |
Question | Can you Release Manual Holds? If Yes, How? |
Answer | Yes. Holds – Release Holds |
Question | How many ways you can pay the Invoice Amount? |
Answer | Apply in Full Schedule Payments Installments |
Question | What is the difference between Debit and Credit Memo? |
Answer | Debit Memo will raise the Customer Credit Memo will raise the Vendor |
Question | Can you create a Duplicate Vendor ? |
Answer | No |
Question | Vendor Number Should be Generate Automatic or Manually? |
Answer | Both, Manual And Automatic |
Question | How many key flexfields are there in Payables? |
Answer | No key flexfields in PO,AP |
Question | What are Payment Terms? |
Answer | Payables uses payment terms to automatically calculate due dates, discount dates, and discount amounts for each invoice you enter. Payment terms will default from the supplier site. If you need to change the payment terms and the terms you want to use are not on the list of values, you can define additional terms in the Payment Terms window. |
Question | What are the Payment Methods available? |
Answer | • Check – You can pay with a manual payment, a Quick payment, or in a payment batch. • Clearing – Used for recording invoice payments to internal suppliers. • Electronic – You generate an electronic payment file that you deliver to your bank to create payments. Use Electronic if the invoice will be paid using EFT or EDI. • Wire – Used to manually record a wire transfer of funds between your bank and your supplier’s bank. |
Question | What are the line types of an Invoice? |
Answer | Item: Item lines capture the details of the goods and services billed on your invoice. Freight: Freight lines capture the details of your freight charges. Miscellaneous: Miscellaneous lines capture the details of other charges on your invoices such as installation or service. Tax: Payables integrates with Oracle E-Business Tax to automatically determine and calculate the applicable tax lines for your invoices. |
Question | What are the Invoice Distribution Types? |
Answer | Item Freight Miscellaneous Tax Withholding Prepayment |
Question | What are Holds in AP? |
Answer | Holds can be placed by the system and some holds can be placed manually. Holds prevent payment and, sometimes, accounting of an invoice. Payables applies holds to invoices that fail the Invoice Validation process. Release holds from invoices to allow payment and accounting entry creation for the invoices. |
Question | What are the Interface Tables in AP? |
Answer | AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE AP_INTERFACE_CONTROLS ————————————– AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT AP_SUPPLIER_INT_REJECTIONS |
Question | What is the API to cancel single AP Invoice? |
Answer | AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE |
Question | What is the API to find invoice status? |
Answer | AP_INVOICES_PKG.GET_APPROVAL_STATUS |
Question | Give some of the Oracle Payables interface? |
Answer | a) Credit Card Transaction Interface b) Invoice Import Interface c) Payables Open Interface d) Purchase Order Matching |
Question | What are the key tables where supplier bank information are stored? |
Answer | IBY_EXTERNAL_PAYEES_ALL IBY_EXTERNAL_PAYERS_ALL IBY_EXT_BANK_ACCOUNTS IBY_PMT_INSTR_USES_ALL |
Question | What is meant by with-holding tax invoice? |
Answer | A separate tax invoice generated for withholding tax amount. Later this invoice will be knocked of when making the payment made to the authority. |
Question | What are all the Modules Interacting with AP? |
Answer | Cash Management Oracle iExpenses General Ledger Oracle Assets Subledger Accounting (R12) HRMS Project Accounting Purchasing/iprocurement Global Accounting Engine (11i) |
Question | What are the mandatory setups in AP? |
Answer | 1- Financial Options 2- Define Suppliers 3- Define Payment Terms 4- Define Payment Methods 5- Define Banks and Banks Accounts And Banks Accounts Documents 6- Open AP Accounts Periods |
Question | What is pay date basis? |
Answer | The Pay Date Basis for a supplier determines the pay date for a supplier’s invoices. • Due • Discount |
Question | What is the difference between quick payment and manual payment? |
Answer | Quick Payment: It allows you to make a single payment against one or more invoices at a time to one supplier through payables. Manual Payment: This is the process of entering the check details which has been paid manually in some emergency requirements into the payment form and selecting the invoices of the concerned supplier and check whether the total of the invoices and the paid amount at the header are same and save. |
Question | What is terms date basis? |
Answer | Terms Date Basis is to calculate due date. Due date is calculated 4way. Eg: payment term is 30days Due date = Sysdate + 30days Due date = Invoice date + 30days Due date = Goods Receive Date + 30days Due date = Invoice Received date + 30days |
Question | What are Aging Periods? |
Answer | Aging periods are nothing but the periods that we setup to control and maintain the supplier outstanding bill towards the invoice. From this we can able to study the due date of the supplier form the generation of invoice. |
Question | Types of Invoices |
Answer | 1. Standard Invoices: Standard invoices are the invoices issued by a supplier to the buyer, representing the amount due for the products or services the supplier has provided to the buyer. Standard invoices can be either matched to a purchase order or not matched. A standard invoice must be positive amount. |
| 2. Mixed Invoices: Mixed invoices are the invoices which can have either positive or negative amounts and can be matched to both purchase orders and invoices. For example, if there is a mixed invoice for $-1000, you can either match it to an invoice with $-1000 or to a purchase order with an amount $1000. |
| 3. Credit Memo: Credit memo is an invoice raised by the supplier to the buyer with negative amount. It reduces the supplier balance and reduces the liability. For example the customer has returned some of the goods that he purchased, the supplier sends a credit memo to the buyer to adjust the balance. |
| 4. Debit Memo: Debit memo is an invoice raised by the customer to supplier with negative amount. The functionality of Debit Memo is same as Credit Memo. Both are to reduce the liability. The purpose of Debit Memos is to record a credit for a supplier who does not send you a credit memo. Unlike in AR, both Credit memo and Debit memo are with negative signs in Payables. |
| 5. Prepayment: Prepayments are the invoices raised to record advance payments to a supplier or employee. |
| 6. Expense Reports: Expense reports are the invoices that represent amount due to an employee for all his business related expenses. |
| 7. Retainage Release Invoices: Retainage release is the act of releasing, or paying, that portion of a payment that was withheld until a substantial portion or all of the service procurement work is completed. The amounts retained during the life of the contract must be released and paid to the supplier or sub-contractor once all or a substantial portion of the work is completed. Oracle Payables uses the Retainage Release Request to create a type of invoice called Retainage Release. A retainage release invoice has lines, which are copied from the original standard progress invoices, which show an amount left to be released. Retainage release invoices can only be entered manually in the Invoice Workbench window. |
| 8. Withholding Tax: After you apply withholding tax to an invoice, you can optionally create invoices to remit withheld tax to the tax authority. Payables can automatically create withholding tax invoices, or you can perform this task manually. If you choose to automatically create withholding tax invoices, you must choose whether to do this during Invoice Validation or during payment processing. |
| 9. PO Price Adjustment Invoices: PO Price Adjustment Invoices are used for recording the difference in price between the original invoice and the new purchase order price. For example, If a supplier sends an invoice for a change in unit price for an invoice you have matched to a purchase order, PO Price Adjustment Invoices can be used to adjust the invoiced unit price of previously matched purchase order shipments or distributions without adjusting the quantity billed. PO price adjustment invoices can be matched to both purchase orders and invoices. |
| 10. Quick invoices: Used for quick, high-volume invoice entry for invoices that do not require extensive validation and defaults. After entry, you import these into the Payables system. Validation and defaulting occur during import |
Question | What is the process/steps for Vendor Conversion? |
Answer | Insert the Vendor info into the interface tables and perform the required validations: AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT Run the below programs to load the data into the Base tables: Supplier Open Interface Import Supplier Sites Open Interface Import Supplier Site Contacts Open Interface Import |
Question | Explain the set up used for Automatic or Manual Supplier Numbering. |
Answer | In the Financials Options window, you can set the Supplier Number entry option to either Autimoatic or Manual • Automatic: The system automatically assigns a unique sequential number to each supplier when you enter a new supplier. • Manual: You enter the supplier number when you enter a supplier |
Question | What is Contract PO? |
Answer | Contract PO is created when you agree with your suppliers on specific terms and conditions without indicating the goods and services that you will be purchasing. |
Question | What is a Payable Document? |
Answer | A medium you use to instruct your bank to disburse funds from your bank account to the bank account or site location of a supplier. |
Question | In which table we can find the vendor number? |
Answer | PO_VENDORS |
Question | Give the cycle from creating an invoice to transferring it to GL in AP. |
Answer | )Create Invoice 2)Validate Invoice 3)Create Accounting entries using Payables Accounting Process 4)Submit the Payables Transfer to General Ledger program to send invoice and payment accounting entries to the General Ledger interface. 4)Journal Import (GL) 5)Journal Post (GL) |
Question | What are the Prepayment types? |
Answer | Temporary and Permanent |
Question | What is Aging Periods? |
Answer | Aging Periods window are the time periods for the Invoice Aging Report. The Invoice Aging Report provides information about invoice payments due during the periods you specify. |
Question | Whats the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program? |
Answer | Payables Open Interface -- for importing regular invoices Payables Invoice Import -- for importing expense reports. In 11i renamed as Expense Report Import. In R12 renamed as Expense Report Export. |
Question | What is prepayment & steps to apply it to an Invoice? |
Answer | Prepayment is a type of invoice that you enter to make an advance payment to a supplier or employee. To Apply it to an Invoice ,in the Invoices window, query either the prepayment or the invoice to which you want to apply it. Choose the Actions button and select the Apply/Unapply Prepayment check box. Click OK. |
Question | Can you hold the partial payment if yes then how? |
Answer | Yes. 1.Go to the Invoice window. Go to the scheduled payments tab. 2.Click "Split" to split the scheduled payment into as many payments as you wish. 3.Check "Hold" against the Payment line you wish to hold. |
Question | What program is used to transfer AP transactions to GL? |
Answer | In 11i "Payables Transfer to General Ledger" Program. In R12 "Transfer Journal Entries to GL" Program. |
Question | What is use of AP Accounting Periods? |
Answer | In Payables accounting periods have to be defined to enter and account for transactions in these open periods. Payables does not allow transaction processing in a period that has never been opened. These periods are restricted to Payables only. The period statuses available in Payables are Never Opened, Future,Open, Closed, and Permanently Closed. |
Question | What are the different interface programs in AP? |
Answer | Payables Open Interface Import to load Invoices and other transactions. Supplier Open Interface Import to load Suppliers. Supplier Sites Open Interface Import to load Supplier sites. Supplier Site Contacts Open Interface Import to load Supplier Site contacts. |
Question | What is Invoice Tolerance? |
Answer | We can define the matching and tax tolerances i.e how much to allow for variances between invoice, purchase order, receipt, and tax information during matching. You can define both percentage–based and amount–based tolerances. |
Question | What will accrue in Payables? |
Answer | Expenses and Liabilities |
Question | Which module is the owner of Vendor/Supplier tables? |
Answer | PO |
Question | In AP the suppliers didn’t visible in India Creditors Ledger Report Parameter? |
Answer | Please check whether that particular supplier is available in Suppliers addition inforamtion or not. |
Question | 1. Describe the Payment Terms and Discounts? |
Answer | In the Payment Terms window, you define payment terms that you can assign to an invoice to automatically create scheduled payments when you submit Approval for the invoice. You can define payment terms to create multiple scheduled payment lines and multiple levels of discounts. You can create an unlimited number of payment terms. Payment terms have one or more payment terms lines, each of which creates one scheduled payment. Each payment terms line and each corresponding scheduled payment has a due date or a discount date based on one of the following: o a specific day of a month, such as the 15th of the month o a specific date, for example, March 15, 2002. o a number of days added to your terms date, such as 14 days after the terms date o a special calendar that specifies a due date for the period that includes the invoice terms date. Only due dates can be based on a special calendar. Discount dates cannot be based on a special calendar. Each payment terms line also defines the due or discount amount on a scheduled payment. When you define payment terms you specify payment amounts either by percentages or by fixed amounts.After you define your payment terms, in the Payables Options window you can select default payment terms that Payables automatically assigns to the suppliers and supplier sites you enter. The payment terms for a supplier site default to the invoices you enter for the site.The Payment Terms Which tells us The Installments of a Purchased Goods Are Services. And the Discount is it will depends upon the Discount dates. |
Question | A Vendor must compulsory have what? |
Answer | Primary Address |
Question | Is there any chance to create Vendor only once? If Where should you create? |
Answer | Yes, Enable the check box in the Vendor Classification Screen |
Question | Can you cancel an Invoice? How? |
Answer | Yes, Actions1 – Cancel Invoice |
Question | How can you match PO with Invoice? What you should not take in the Invoice? |
Answer | Match/Po Number,Distribution Set should not be taken care at this point. When you enter an invoice and match it to a purchase order, Payables automatically creates distributions for you and checks that your match is within the tolerance you define. After you save the match, Payables updates the quantity billed for each matched shipment and its corresponding distribution(s) by the amount you enter in the Quantity Invoiced field. Payables also updates the amount billed on the purchase order distribution(s). |
Question | What you should take care When you Match Debit/Credit Memo with an Invoice? |
Answer | The Invoice Should match with Po. When you enter a credit/debit memo, you can match it to existing invoice(s) to have Payables automatically copy the accounting information and create invoice distributions for the credit/debit memo. You can match the credit memo to multiple invoices, and at different levels of detail. Your available choices depend on whether the originating invoice was matched to a purchase order or not. For example, if you receive a credit for items you returned to a supplier, you can enter a credit memo and match it to the original invoice you entered to ensure that the credit memo distributes the credit to the same accounts originally charged. If the original invoice is not purchase order matched (basic invoice), you can: o Match to an invoice. Payables prorates your credit amount based on the invoice distribution amounts of the original invoice. Payables automatically creates invoice distributions for the credit/debit memo based on the distributions of the original invoice. o Match to specific invoice distributions. You can allocate the credit amount to specific invoice distributions of the original invoice. Payables automatically creates invoice distributions for the credit/debit memo based on the original invoice distribution that you select. For example, you may order three chairs for three different departments and return one. You can match a credit/debit invoice to the original distribution for that department to ensure that the credit matches the charge. If the original invoice is purchase order matched, you can: o Match to specific invoice distributions. You can allocate the credit amount to specific invoice distributions of the original invoice. Payables automatically creates invoice distributions for the credit/debit memo based on the original invoice distributions that you select. Payables updates the quantity billed for each of the originally matched purchase order shipments and their corresponding distributions by the credit quantity you enter. Payables also updates the amount billed on the purchase order distributions. o Match to purchase order shipments. Payables prorates, based on the quantity billed, your credit amount across all purchase order distributions associated with the purchase order shipment to which you match the credit/debit memo. Payables automatically creates invoice distributions for the credit/debit memo based on the purchase order distributions associated with the purchase order shipment you match to. Payables updates the quantity billed for each purchase order shipment and its corresponding distributions by the amount of the credit/debit memo. Payables also updates the amount billed on the originally matched purchase order distributions. o Record a Price Correction. Use a price correction when a supplier sends an invoice for a change in unit price for an invoice you have matched to a purchase order. You can record a price correction by checking Price Correction when you match a credit/debit memo to a purchase order shipment or purchase order matched invoice distribution. When you record a price correction for a credit/debit memo, you are recording a price decrease from the original invoice. Payables updates the invoiced unit price of previously matched purchase order shipment or distributions without adjusting the quantity billed so you can track price variances; Payables also updates the amount billed on the originally matched purchase order distributions. To match a credit /debit memo to an invoice, invoice distribution, or a purchase order shipment: 1. Enter a Credit Memo or Debit Memo type invoice. Enter a negative invoice amount and all basic invoice information but do not manually enter the distributions. 2. Choose the Match button. In the Find Invoices to Match window, query the invoices you want to match and choose Find. If the credit/debit memo pertains to an invoice matched to a certain purchase order, query by purchase order number to see all invoices matched to that purchase order. Payables navigates to the Match to Invoice window. Optionally choose the Invoice Overview button to review more information about an invoice. 3. Create invoice distributions by matching to one or more invoices. If you are matching to a non-purchase order matched (basic) invoice, select the invoice and enter a Credit Amount. If you want to match in further detail, continue the match at the invoice distribution or purchase order shipment level: o To match to invoice distributions, choose Distribute. For each invoice distribution you want to match to, select the distribution and enter a Credit Amount. o To match to purchase order shipments, choose Match PO. For each shipment you want to match to, select the shipment and enter either a Quantity Invoiced or Match Amount. Payables automatically calculates the remaining field (Quantity Invoiced x Unit Price = Match Amount). You can optionally change the Unit Price, which defaults from the purchase order. 4. Choose Match to create invoice distributions for the credit/debit memo based on the matches you made. To review the new invoice distributions, choose the Distributions button from the Invoices Summary. |
Question | How Will you group a similar type of Items? |
Answer | Items List |
Question | How many Payment Types U have? |
Answer | Quick, Manual, Refund – for refunding an amt - Refund, Manual, Quick, Automatic Payment |
Question | How will the system calculate the Discount? |
Answer | Discount date. Invoice payments terms where we have to define the discount rates & dates- 1st discount, 2nd discount & 3rd discount In the Payment Terms window, you define payment terms that you can assign to an invoice to automatically create scheduled payments when you submit Approval for the invoice. You can define payment terms to create multiple scheduled payment lines and multiple levels of discounts. You can create an unlimited number of payment terms. Payment terms have one or more payment terms lines, each of which creates one scheduled payment. Each payment terms line and each corresponding scheduled payment has a due date or a discount date based on either a specific day of a month, such as the 15th of the month, or a number of days added to your terms date, such as 14 days after the terms date. Each payment terms line also defines the due or discount amount on a scheduled payment. When you define Payment Terms you specify payment amounts either by percentages or by fixed amounts. Payables provides a predefined, unalterable payment term, called Prepayment Immediate, which Payables automatically assigns to all prepayments you enter. After you define your payment terms, you can select default system payment terms that Payables automatically assigns to the suppliers and supplier sites you enter. The payment terms for a supplier site default to the invoices you enter for the site. Attention: If you update the payment terms on an invoice, Payables recalculates the scheduled payment for the invoice. Thus, you must reenter any manual adjustments you made to the previous scheduled payment. For example, if you updated the payment priority on a particular scheduled payment and then changed the payment terms, Payables would recalculate the scheduled payment using the same payment priority defaults as before and you would need to redo your updates. To define payment terms: 1. In the Payment Terms window, enter a unique Payment Term name and a description which will appear on a list of values whenever you select payment terms. For detailed information on any field. If you are entering Day of Month terms, enter a Cutoff Day. If you enable Automatic Interest, enter a unique value in the Rank field. If you want to invalidate this payment term after a certain date, enter that date in the Effective Date/To field. 2. Enter each payment terms line. Enter one of the following to determine the portion of an invoice due on the scheduled payment: o % Due. o Amount. In the Due region, enter one of the following to determine the due date on the scheduled payment line: o Fixed Date o Days o Day of Month, and Months Ahead. 3. If you are using discount terms, define payment terms lines in the First, Second, and Third Discount regions. Define your discounts so that the first discount has an earlier discount date than the second and so on. You can realize only one discount on a payment terms line. Enter one of the following to determine the portion of the invoice to discount on the scheduled payment: o % Discount. o Amount. In the Discount region, enter the discount percent. Enter one of the following to determine the due date on the scheduled payment line: o Due Days o Day of Month, and Months Ahead. 4. Save your work. |
Question | What is a Distribution Set? |
Answer | The Components of the Invoice like COGS, Freight, Tax… You can use a Distribution Set to automatically enter distributions for an invoice when you are not matching it to a purchase order. For example, you can create for an advertising supplier a Distribution Set that allocates advertising expense on an invoice to four advertising departments. You can assign a default Distribution Set to a supplier site so Payables will use it for every invoice you enter for that supplier site. If you do not assign a default Distribution Set to a supplier site, you can always assign a Distribution Set to an invoice when you enter it. Use Full Distribution Sets to create distributions with set percentage amounts, or use Skeleton Distribution Sets to create distributions with no set distribution amounts. For example, a Full Distribution Set for a rent invoice assigns 70% of the invoice amount to the Sales facility expense account and 30% to the Administration facility expense account. A Skeleton Distribution Set for the same invoice would create one distribution for the Sales facility expense account and one distribution for the Administration facility expense account, leaving the amounts zero. You could then enter amounts during invoice entry depending on variables such as that month’s headcount for each group.If you enable and use a descriptive flexfield with your distribution set lines, the data in the flexfield will be copied to the invoice distributions created by the Distribution Set. Note: Taxable distributions created by distribution sets are always inclusive of tax when you use Automatic Tax Calculation even if you have not checked the Includes Tax check box at the supplier site. Creating Distribution Sets To create a Full Distribution Set: 1. In the Distribution Sets window, enter the Name and Description of the Distribution Set you are creating. 2. Enter the Account and Description for each distribution and enter the Percentage of the invoice amount that you want to distribute to the Account. You can enter positive and negative percentages. Create as many distributions as you need. The sum of the distribution percentages must equal 100 or 0. If you are creating a Distribution Set for a federally reportable supplier, optionally enter an Income Tax Type. Optionally enter an Invoice Tax Code. The Tax Code will default based on the Tax Code Defaults hierarchy you defined in the Payables Options window. If the source Payables uses is Template, then Payables uses the value from the Distribution Set, even if the value is null. 3. Save your work. Payables automatically assigns type Full to your Distribution Set. To create a Skeleton Distribution Set: 1. In the Distribution Sets window enter the Name and Description of the Distribution Set you are creating. Attention: If you create a skeleton Distribution Set, include skeleton in the name to remind you to enter the line amounts. 2. Enter the Account and Description for each distribution and leave the Percentage at zero. Create as many distributions as you need. If you are creating a Distribution Set for a federally reportable supplier, optionally enter an Income Tax Type. 3. Save your work. Payables automatically assigns type Skeleton to your Distribution Set. |
Question | What is a Prepayment? Describe? How many we have? |
Answer | Pay a prepayment just as you would any other invoice. However, you cannot partially pay a prepayment; you must fully pay it. You must fully pay a prepayment before you can apply the prepayment to an invoice. You can enter a Prepayment type invoice only in the Invoices window. You cannot enter a Prepayment type invoice in the Invoice Gateway The Advance Amount, Vendor, Employee Select a Prepayment Type: o Temporary. You can apply this prepayment to invoices after you approve and pay it. o Permanent. You cannot apply this prepayment to invoices. |
Question | How will the Endures knows on a Particular Supplier How many prepayments have Describe? |
Answer | The Invoice screen after selecting the Vendor Name |
Question | How will you apply the Prepayment? |
Answer | Actions1 – Apply / Unapply Prepayment |
Question | Can you pay unapproved Invoice Amount, if yes How? |
Answer | No, You have to Approve it then only U can Pay |
Question | What is Expense Report? and Template? |
Answer | The Template is the Expense Items on an Employee, the Expense Report gives the Anticipated Expenses of an Employee in Your Organization.Use the Expense Reports window in Payables to enter expense reports for your employees. You can also use this window to review and modify expense reports that you entered in the Expense Reports window, that your organization’s employees entered in Oracle Web Employees, or that you have transferred from Projects. You can apply advances to expense reports to reduce the amount you pay. You can also apply a hold to an expense report to prevent payment. Before you can pay expense reports you must submit the Payables Invoice Import program to have Payables automatically create invoices from the expense reports. You can then create journal entries for posting to your general ledger. The following are the steps you follow to process an expense report: 1. Enter employees, their locations, and their expense addresses in the Enter Person window. 2. Define the employee as a supplier using either of the following methods: o Enable the Create Employee As Supplier Payables option to automatically create suppliers from employees when you submit Payables Invoice Import o Enter the employee as a supplier in the Suppliers window before submitting Payables Invoice Import for expense reports. 3. Define expense report templates that model the different expense report formats you receive. 4. Enter expense reports. 5. Submit Payables Invoice Import to create invoices and invoice distributions for the expense reports. Review the Invoice Import reports, then correct any expense reports that caused exceptions and resubmit Payables Invoice Import. 6. Pay the invoices. |
Question | What are the 2 important points you should take, when You are raising a Expense Report of Invoice? |
Answer | One is In the Vendor Screen You have to take Type is “Employee”, The second one is In the Prepayment Invoice the settlement Date You should take care |
Question | Can U allow Zero Payments? If yes, How? |
Answer | Yes, if you enabled the Allow Zero Payments Check box in the Bank Screen the Payments Options |
Question | Can U pay Debit & Credit Memos Amount? |
Answer | No |
Question | Can U Enter Backdated Recurring Invoices? If how? |
Answer | No |
Question | What is the Prerequisite for Recurring Invoices? |
Answer | Special Calendar |
Question | How many sites exists for payment of invoices to employees? |
Answer | Home, Office |
Question | How will you transfer The payable data to GL? What is the Interface Name? |
Answer | Payables Transfers to GL, It is Feeder System Interface |
Question | Oracle Payables does not allow entry of invoices if the period status is |
Answer | CLOSED |
Question | How to Adjust Average Cost with Invoice Price Variances (IPV) |
Answer | If you want to get your inventory cost, and ultimately your cost of goods, to reflect the actual cost you paid for your items, then you will want to interface the Invoice Price Variance (IPV) from Oracle Payables to Oracle Inventory/Cost Management. The ability to perform this update of inventory cost is only for inventory organizations using the average cost costing method. To understand this process, let’s look at the flow of cost from PO receipt to Transfer of Invoice Variances. Here’s an overview of each step: 1. Create and approve a PO 2. Receive the item 3. Enter and match an AP invoice (release any holds if necessary) 4. Generate accounting for the AP invoice 5. Transfer invoice variances to Inventory Step 2 in the process (PO receipt) sets the initial average cost. This cost will be used on all issues or shipments out of inventory. Remember in average costing, we receive at PO price and issue out at average. Once steps 3 (enter and match an AP invoice) and 4 (generate accounting) are complete, we are ready to run the Transfer Invoice Variance to Inventory program. You can run the program from Cost Management for one inventory organization at a time. This program will sum the difference between the invoice price and the PO price for each item/organization combination and then create an average cost update transaction. This transaction will have an amount but not a quantity. This amount is then applied to the remaining inventory on-hand. So let’s look at a couple of examples and how your average cost will change. Example 1: * PO Price $10 * Receipt Quantity 100 * Invoice Price $12 * On-Hand 100 * Beginning Average Cost $10 * Ending Average Cost $12 In this example, we will apply the IPV of $2 to all 100 units in inventory. So the average cost before the IPV transfer is $10 and the average cost after the IPV transfer is $12. This would correctly value our inventory at actual cost. Example 2: * PO Price $10 * Receipt Quantity 100 * Invoice Price $12 * On-Hand 10 (sold 90 units) * Beginning Average Cost $10 * Ending Average Cost $30 (($200/10) + $10 = $30 In this example, we will apply the IPV of $2 to remaining 20 units in inventory. So the average cost before the IPV transfer is $10 and the average cost after the IPV transfer is $30. This would result in lower margins the next time we sell and ship this item. Example 3: * PO Price $10 * Receipt Quantity 100 * Invoice Price $12 * On-Hand 0 (sold 100 units) * Beginning Average Cost $10 * Ending Average Cost $10 In this example, we wouldn’t apply the IPV of $2 because the on-hand quantity is zero. So the average cost before the IPV transfer is $10 and the average cost after the IPV transfer would also be $10. |
Question | Helpful Tips for a Successful R12 Oracle Payables Implementation |
Answer | Please read the entire list before starting your R12 implementation or upgrade. 1. Create a realistic schedule for your R12 implementation or upgrade. 2. Conduct your implementation or upgrade on a parallel system. 3. Allow yourself sufficient time to implement and perform user acceptance testing (UAT). This will give you time to assure that your system has been designed and setup to meet your business needs. 4. Assure that as much data as possible is accounted and ALL accounting is transferred. 5. Clear up any data issues in 11i before upgrading (i.e., Run the Accounting Health Check), 6. Use the Maintenance Wizard for the upgrade. 7. If possible, implement the most current version of R12 (i.e., R12.0.4 — see Metalink Note: 465776.1 / Patch 6435000. In addition, apply the Oracle Financials and Oracle HRMS Release Update Packs 12.0.5 (RUP5) — see Metalink Note: 565898.1 / Patch 6836355 8. Review the Oracle Financials Critical Patches Alert, see Note:557869.1. The alert includes the links to the R12 Known Issues documents, which list the critical patches for Oracle Payables, Subledger Accounting, E-Business Tax, and other Financials applications. Apply the critical patches to prevent encountering issues that have already been addressed. 9. Apply the pre-upgrade patches BEFORE upgrading to R12. 10. Apply the post-upgrade patches ASAP after completing the upgrade. 11. Perform several month-end closes before considering a Go-Live date. |
Question | How Payables Payment Terms Logic Works ? |
Answer | How Payment Terms Work And What Is The Functionality Of Payment Terms When ? The Payment Terms defined works on three basic fields on which you have entered/defined information. The below combinations along with Invoice date defaults your Invoice Due Date. In the Define Payment terms screen Method 1) --------- Invoice Date and No of Days entered in Payment term Days field a)Days Say, Invoice date is 28-Nov-2001 then if you enter 60 days then due date will be 27-Jan-2001. It means it calculates no of days from the Invoice date. Method 2) --------- Invoice Date + Cut Off day + Day of month with Months ahead. 1) Cut-off Day 2) Day of Month with Months ahead For example : If you enter Payment Terms like this: Cut of day 31 (Last day of a Month) Means even though invoice is 28th 1st what so ever, it calculates from the last day of month. Day of a month 29 Months ahead 2 ( Two Months) If invoice is dated 28-Nov-2001, with the above setup you get Due date as 29-Jan-2001 as due date. It will always calculate from the End of Nov ie 30th Nov and Then it takes Two Months here it gives you always 29th of Second month from Invoice date. ie Invoice Date Due Date 28-Nov-2001 29-Jan-2002 28-Dec-2001 28-Feb-2002 28-Jan-2002 29-Mar-2002 So on and so forth. Either you give 29th or 30th what so ever, once you give the Day of Month you will get only that day as due date after Months specified in the Months ahead field. This is how application works and desinged to work. Please refer documentation for the following terms Cutoff Day. Days. Day of Month Months Ahead. Further, In case, you have two invoice payment terms which you are not able to define in AP and the due dates are not defaulting as expected; The two terms are:- (1) 60 DAYS END OF MONTH go to month end and add 60 days E.G: invoice dated 28 NOV, due date is 29 JAN (2) 90 DAYS END OF MONTH go to month end and add 90 days E.G: invoice dated 28 NOV, due date is 28 FEB How would you define these? The Payment Terms functionality does not support the above example |
Question | R12 How to get Payment Method Defaulted In Supplier Creation page? |
Answer | 1. To ensure correct Setup, please perform the following: a) Go to Setup > Payment > Payment Administrator > Payment Methods b) Choose Payment Methods and then press Go To Task c) Query for your Payment Method which you want to be defaulted and then press Go Button d) Press Update (Not Update Usage Rules) e) Under (Usage Rules) region you will find (Automatically assign Payment Method to all Payees) Check Box,Click on this Check Box to enable that option and then press Apply Button 2)Also follow the following setup steps in a (1): a) Go to Setup> Payment> Payment Administrator > Disbursement System Options and then press Go To Task b) Under (Enterprise Level) region press View Settings c) Under (Disbursement System Options: Enterprise-wide) you will find the option (Default Payment Method), press Update Button d) There are two Options: > Based Only on Payment Method Defaulting Rules Setup > Override Defaulting Rules when Default Method Set for Payee > Please choose the first option (Based Only on Payment Method Defaulting Rules Setup) and then press Apply Button 3) Retest your issue again and feed us back if your issue is resolved. |
Question | iRececivables Uptake Of Oracle Payment |
Answer | About the Integration: Oracle Payments is a new product in release 12. The product known as iPayment will no longer exist in release 12, however all functionality that existed in it is contained within Oracle Payments. The objective of the new product is to give any deploying company a highly configurable and robust solution to disburse and receive payments. Oracle Payments is a fundamental part of the Oracle Applications architecture, and is provided with multiple products that require support for payment processing services. Oracle Payments provides the infrastructure needed to connect other products with third party payment systems and financial institutions. The product supports a number of payment features. Some features support just disbursement, some just capture, and other features are common to both. In iReceivables we can pay for the customers invoices . After selecting the payment method ( Bank Transfer / Credit Card Payment) a receipt would be created in AR . In earlier releases for the capture of funds the iPayments extensions were used . iReceivables would now call the Oracle Payment API’s for the funds capture. This is entirely in the background and there are no visible changes in the iReceivables user interface because of this integration. |
Question | What has changed? |
Answer | 1. The receipt class set up (in AR) has changed requiring the Oracle Payments ‘Payment Method’ to be attached to this kind of payments. 2. Payment attributes of transactions will be stored in a centralized transaction payment-extension entity owned by Oracle Payments. 3. In release 12, Oracle Payments owns the data model where all third party payment instruments are stored (these are instruments like customer credit cards and supplier bank accounts). |
Question | What happens during the Transaction Entry and Authorization ? |
Answer | A) During the Transaction Entry The following are captured in iReceivables during the transaction entry ( paying the Invoice in iReceivables) for the funds capture. * Payment method * Payment instrument * Payment attributes These values are passed on to Oracle Payments before the Authorization & Settlement API’s are Called.The transaction authorization information is stored in Payments and linked with the extension entity, this is no longer stored in AR tables. B) During Authorization Oracle Payments mandates that authorization is invoked before a transaction can be settled in Oracle Receivables. Oracle Payments will enforce that the settled amount is equal to or less than the authorized amount. Based on the payment method passed to the Authorize API, Oracle Payments will perform different functions that depend on the nature of that payment method. For example, for payment methods in the credit card category, Oracle Payments will attempt to validate the credit card and reserve the transaction amounts for settlement. For payment methods in the bank account transfer category, Oracle Payments will not attempt to reserve the funds, but will try to validate the bank account information. |
Question | What is the set up required ? |
Answer | In Oracle Payments: A (funds capture) payment method may be set up or a seeded payment method used. It is required for funds capture within Oracle Payments to set up a funds capture process profile, a payment system, and a payee (the definition of the internal organization that will receive the funds, also known as the first party payee). Set up Oracle Payments, if you intend to use the Pay Invoice function for credit cards or for bank account transfers using the ACH network. In Receivables: Define Receipt Class and Payment Method If you are using the Pay Invoice function, define at least one receipt class and payment method for each iReceivables payment instrument that you intend to use: • Bank account transfers using Receivables direct debit. • Credit card payments using Payments. • ACH bank account transfers using Payments. In iReceivables: Go the iReceivable Setup Responcibility > System Parameters and select the ‘Credit Card Receipt Method’ and ‘Bank Account Payment Method’ defined above . These would default to the receipts created from iReceivables. Note: iReceivables does not support cross-currency payments. Though a user can still pay invoices with a credit card or bank account that has a different currency from that of the invoice, the receipt created in iReceivables will have the same currency as the invoice. |
Question | How to disable Create Online Accounting in Payables |
Answer | (1) Log on to System Administrator Responsibility (2) Navigate Applications->Menu (3) Query up Menu “AP_APXINWKB_MENU” (4) In the child records of AP_APXINWKB_MENU, you should see “Invoice Accounting” (5) Uncheck the grant checkbox for “Invoice Accounting”. (6) Log on to Payables Responsibility (7) Create a invoice and approve it. (8) Click on the Actions button. (9) You should see “Online Accounting” checkbox disabled. |
Question | Difference between Match and Quick Match |
Answer | PO Default : Enter PO Default as the invoice type if you know th purchase order you want to match to, but you do not know to which purchase order shipments or distributions you want to match. When you enter a PO Default invoice in the Invoice Workbench, Payables prompts you to enter the purchase order number and automatically enters the supplier name, supplier number, supplier site, and the purchase order currency for the invoice currency. When you choose the Match button,Payables will retrieve all purchase order shipments associated with the specified purchase order. You can then match to any shipment or distribution. Quick Match: Enter Quick Match as the invoice type if you want to match an invoice to all shipments on a purchase order. When you enter a Quick Match invoice in the Invoice Workbench, Payables prompts you to enter the purchase order number and automatically enters the supplier name, supplier number,supplier site, and the purchase order currency for the invoice currency. When you choose the Match button, Payables automatically matches to each shipment. You can choose to complete the match or override the matching information. |
Question | Bank Account Access Options And Bank Account Grant Access Organizations |
Answer | When we define Bank account we assign: Bank Account: Account Owner and Use 1. Bank Account Owner and Use: 1). Bank Account Owner: The name of the source account holder. 2). Account Use: Select the checkboxes that apply to your account: Payables, Payroll, Receivables, Treasury. |
Question | Bank accounts can be given Organization Access to other organizations under any Legal Entities as long as those Legal Entities are owned by the same Ledger of the Legal Entity that owns the bank account? What it means? |
Answer | Yes..The LE and OU’s are indirectly tied with the ledger.. The ledger of the operating unit must be same as the primarly ledger of the Legal entity. Additionally, the user should have access to the operating units. |
Question | why an Organization is not listed in the LOV of the Bank Account Grant Access Organizations window? Is it because the LE owning the bank account has its Ledger and that ledger do not have other OU since those are not linked to this ledger? |
Answer | Yes, that is one reason.. another reason could be that user might not have access to that OU. |
Question | Explain the concept of the ERS. Also give relevant set-ups and programs related to it. |
Answer | Evaluated Receipt Settlement (ERS) also referred to as 'Pay on Receipt'. While defining supplier site in Purchasing tab, the "Pay on" field should be 'Receipt'. |
Question | Can an invoice be accounted if there are holds applicable to the invoice? |
Answer | Yes! An invoice can be accounted even if the holds are applied against it provided, Accounting Allowed check-box is enabled while defining the Invoice Hold. |
Question | Can the same Invoice Number be entered for two different suppliers in Payables? |
Answer | The invoice number should be unique for a given supplier; hence, the same Invoice Number can be used by multiple suppliers |
Question | Control of Payables (AP) periods is at what level? At Operating Unit? |
Answer | Though Payables (AP) operates at Operating Unit level, the control of period is at set of books level. |
Question | Can the same bank account be assigned to multiple suppliers? What is the alternative if same bank account is to be shared across multiple suppliers (e.g. part of same group)? |
Answer | Yes, While defining Internal bank accounts, "Allow Assignment to Multiple Suppliers" check-box should be enabled. |
Question | What is "Zero Payment"? And what are the set-ups required to make a Zero Payment? Is it possible to ensure that only zero payments are allowed using a payable document? |
Answer | While defining Bank Accounts, in Payable Options tab "Allow Zero Payments" check-box to be enabled. To ensure that only zero payments are allowed using a payable document, attach a payment format to the same which has "Zero Amount Payments Only" check-box enabled. |
Question | A supplier is available in Invoice Inquiry; however, the supplier is not available while entering Invoices. What are the possible reasons for the same? |
Answer | he possible for the unavailability of supplier are - The 'Pay' check-box at supplier site (General tab) is disabled - 'Inactive On' date is entered at the supplier site level i.e. supplier site is end-dated. |
Question | While doing future dated payments, is the future dated payment account at the supplier site used? |
Answer | It depends on the Payable Options's Accounting tab. There we have option to select whether the future dated payments account should be selected either from Supplier site or Payable documents. |
Question | When the 'Payment Method' at invoice level is given as 'Electronic', sytem requires some additional details? What are they? |
Answer | When the 'Payment Method' is selected as 'Electronic' system additionally requires a Bank account in the invoice currency to be assigned to the supplier. |
Question | If there is a requirement that for specific supplier, each invoice should be paid by a separate check? Can that be achieved? If yes, how? |
Answer | While defining supplier site in the Payments tab, the "Pay Alone" need to be checked so that each invoice is paid by a separate check. |
Question | Let us assume that a check issued to supplier has become time-barred. And supplier returns it requesting for a new check. Can the existing check be voided and a new check be issued simultaneously? |
Answer | |
Question | Can the payment date be before the system date i.e, is it possible to issue back-dated checks? |
Answer | Yes |
Question | While defining payable documents, document number is given as 1 to 4999. And an user has issued checks till 4999. What happens when 5000th check is being created using the same payable document? |
Answer | Error: The provided payment document is exhausted. Select a different payment document or select skipped document number, if any. |
Question | Can you create an Invoice in USD, while the Standard PO has been created in EUR? |
Answer | |
Question | What are the various possible period statuses in AP? |
Answer | Various period statuses of AP module are - Never Opened - Open - Closed |
Question | Period Close Exception Report' lists some payments under the heading 'Future Dated Payments Requiring Maturity Event and Account'. What action should be taken to resolve this? |
Answer | To resolve this issue 'Update Matured Future Payment Status' program needs to be submitted with appropriate Maturity Date. |
Question | Can a period be closed if the Payment Batch in that period is in the status 'Formatted'? |
Answer | Yes, If a period can be closed only after the payment is accounted and transferred to GL. Since, the status of payment is not 'Confirmed'; this payment will not allow for AP period closure. |
Question | Will an Invoice without a Distribution Line come in the 'Period Close Exception Report'? What action will be required to resolve it |
Answer | An Invoice without a distribution will not hinder period closing process. Hence, no action will be required. However, it is recommended to enter distributions, if a valid invoice; else delete such invoices. |
Question | What are the most common issues encountered while AP Period Closing process? |
Answer | Without going to technicalility, on a broader level the most common issues are: - Invoice (Distributions) not Validated - Invoices on Hold - Invoices not Accounted - Payments not Accounted - Invoices & Payments accounting entries not transferred to GL - Maturity Accounting not done for Future Dated payments The above issues may arise either because users forgot to run relevant programs or because of bugs (which are quite many in AP) and awaiting resolution from Oracle (after Service Request i.e SR is raised). |
Question | Is is mandatory to resolve the issues in All the Operating Units of a given Legal Entity? Or the period can be closed once issues of one Operating Unit are resolved? |
Answer | It is mandatory to resolve all the issues of ALL the Operating of a given Legal Entity/ Set of Books (SOB). |
Question | Explain the Interface process. |
Answer | The interface process starts with uploading the legacy data, which is in the form of flat file to the temporary table, and validating the data in the temporary. After that the data to be transferred to the Interface tables. From there by running the Customer Open Interface concurrent program, the data that is in the interface tables are transferred to main tables. |
Question | What are the various tables involved in AP Interface? |
Answer | AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE |
Question | What is the program used to import invoices from interface tables? |
Answer | Payables Open Interface Import |
Question | Invoices vs Invoice Batches |
Answer | |
Question | Number of Tabs in Invoice Entry screen and what are they? |
Answer | General, Lines, Holds, Veiw Payaments, Scheduled Payments, Veiw Prepayment Applicatons |
Question | Where is the method of Supplier Number set? At what level is the supplier numbering controlled? |
Answer | |
Question | What are the various statuses of invoices? |
Answer | |
Question | How many key flexfileds are there in Payables |
Answer | Payables doesn't have any key flexfield |
Question | What are AP Accounting periods? How are they different from GL periods? Are there adjusting periods in AP? |
Answer | |
Question | Can a partial payment of Prepayment be done? |
Answer | No Error: The Prepayment amount cannot be different from the total invoice amount which are selected for payment |
Question | Can you hold partial payments? And how can that be achieved? |
Answer | |
Question | How can the Invoice distributions' which can be transferred to Fixed Assets be identified in AP? Is there is any field explains/indicates the same? |
Answer | Track as Assets |
Question | When you return goods to supplier (RTS) whether system created Debit Memo or Credit Memo? And what is the set-up required for the system to create the relevant document automatically? |
Answer | Debit Mome |
Question | What does Accrual mean? |
Answer | |
Question | An invoice is entered, validated and accounted. And thereafter, the invoice is cancelled; what will be the accounting status? |
Answer | |
Question | How can we link an Employee to Supplier? |
Answer | |
Question | Can you explain the concept of Automatic Offset in Payables? And how is this different from Autoaccounting in AR? |
Answer | |
Question | Can two users use same payable document simultaneously? If yes, which user will get the document number assigned first? |
Answer | |
Question | What are the various statuses of payment batch? |
Answer | |
Question | Can the payment date be before invoice date? |
Answer | |
Question | Can accounting of Payment be done before accounting invoice? |
Answer | No |
Question | Explain the concept of Proxima payment terms. |
Answer | |
Question | What are the various type of Distribution sets? And what is thier purpose? |
Answer | |
Question | Can an Invoice in INR be paid in USD currency? What are the alternatives available? |
Answer | |
Question | Can multiple currency payments be done using same bank account? If yes, what are the relevant set-ups required? |
Answer | |
Question | Can PO level DFF be transferred to AP Invoice? Any set-ups are required for the same? |
Answer | |
Question | What is the name of program which is used to transfer accounting entries from AP to GL and what are the options available during submitting the program? |
Answer | |
Question | Explain the concept of withholding tax along with relevant set-ups. |
Answer | |
Question | What's the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program? |
Answer | |
Question | What are the tables associated with Invoice? |
Answer | ap_invoices_all ap_distributions_all ap_holds_all ap_interface_rejections |
Question | What is Interest Invoice and how it can be created? |
Answer | |
Question | Explain the set up used for Automatic or Manual Supplier Numbering. |
Answer | |
Question | What is Accounting periods? |
Answer | Accounting periods are the periods in which you perform your operations.Accounting periods are closed so as to ensure that no accounting entries can be passed in that period after they are clsoed.Suppose you have issued your results without closing your accounting periods and then you chnage some entries in that period thus in turn misleading the public at large.So it is important to close your accounting periods.Also, if accounting periods in Ap are not closed it shall not allow you to run GL.Prior to closng the periods it is important to ensure that all your invoices are validated and no hold exists on any one of them.If hold exists it shall not allow you to run GL. |
Question | Types of Invoice in Payables? |
Answer | 1. Standard invoice 2. Debit memo 3. Credit memo 4. Prepayment 5. Expenses Report 6.PO defualt 7. Quick match 8. Mixed invoice 9. Withholding Tax 10. Interest invoice 11. Recurring invoice |
Question | Use of recurring invoice? |
Answer | |
Question | When does the Invoice price variance arise? What is the accounting entry? |
Answer | Purchasing and Inventory provide you with visibility and control of your invoice price and exchange rate variances. Payables automatically calculates and records invoice price and exchange rate variances in your general ledger when you have matched, approved and posted your invoices. You can use the Invoice Price Variance Report to review the accuracy of your purchase order prices. IPV= difference between invoice price and po price. These IPV, PPV only for inventory and wip transactions. |
Question | What is the difference between Standard Remittance and Factoring Remittance? |
Answer | |
Question | How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12 |
Answer | |
Question | What is Allow Zero Invoice. Give a example? |
Answer | |
Question | What various types of matching. Explain them? |
Answer | |
Question | Match/Hold: How do I remove a Final Matching hold so that I can pay the invoice? |
Answer | This hold is in effect because the invoice was matched to a PO line that has a status of Final Closed. There is no way to manually remove the hold; the system must remove the hold. There are two workarounds for this situation: Workaround #1: You need to reverse the distribution line that has the final match hold. You can then create a new PO line, and match to that line. Workaround #2: You can manually create a distribution line on the invoice that is not matched to the PO, but is charged to the correct GL account. For More information on Final Match Holds see Note 1026090.6. |
Question | How do I create a Withholding Tax invoice? |
Answer | After you apply withholding tax to an invoice, you can optionally create invoices to remit withheld tax to the tax authority. Payables can automatically create withholding tax invoices, or you can perform this task manually. If you chose to automatically create withholding tax invoices, you must choose whether to do this during Approval or during payment processing. Indicate this choice in the Withholding Tax region of the Payables Options window. See: Withholding Tax Payables Options. If you choose to create withholding tax invoice manually, create an invoice for each Withholding Tax type invoice distribution on an invoice. Create the invoice for the tax authority supplier and site assigned to the Withholding Tax type tax name and for the amount of the Withholding Tax type invoice distribution. |
Question | What is Purchase Price Variance? |
Answer | Purchasing and Inventory provide you with visibility and control of your purchase price variances. When you use standard costing, Purchasing and Inventory automatically calculate and record purchase price variances as you receive your inventory items into inventory. If desired, Purchasing and Inventory automatically calculate and record purchase price variances for your outside processing receipts into work in process. You can use the Purchase Price Variance Report to review the accuracy of the standard costs for your purchased items and services. PPV= standard cost - actual cost ie:difference between standard cost and po price. |
Question | What is the process/steps for Vendor Conversion? |
Answer | Insert the Vendor info into the interface tables and perform the required validations: AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT Run the below programs to load the data into the Base tables: Supplier Open Interface Import Supplier Sites Open Interface Import Supplier Site Contacts Open Interface Import |
Question | Explain the set up used for Automatic or Manual Supplier Numbering. |
Answer | In the Financials Options window, you can set the Supplier Number entry option to either Autimoatic or Manual • Automatic: The system automatically assigns a unique sequential number to each supplier when you enter a new supplier. • Manual: You enter the supplier number when you enter a supplier |
Question | Give the cycle from creating an invoice to transferring it to GL in AP. |
Answer | 1)Create Invoice 2)Validate Invoice 3)Create Accounting entries using Payables Accounting Process 4)Submit the Payables Transfer to General Ledger program to send invoice and payment accounting entries to the General Ledger interface. 4)Journal Import (GL) 5)Journal Post (GL) |
Question | You have created a new SOB. How will you attach this SOB to AP? |
Answer | Go to Payables Manager for the appropriate Operating Unit. Navigation:Setup--->Set of Books--->choose. |
add
About Me
Friday, February 22
Oracle Account payables interview Qs
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment