XML Publisher supports the common programming construct “if”,”if-then-else”. This is extremely useful when you need to test a condition and conditionally show a result.

We can use if condition directly by writing <?IF?> condition <?END IF?>

Example:
<?if:P_PM_YN=’N’?> Yes <?end if?>
But for If-else we need to use extended function.
 
Method 1:

<?xdofx:if element_condition then result1 else result2 end if?>

Example:

<?xdofx:if INVOICE_AMOUNT > 5000 then ’Higher’
else
if INVOICE_AMOUNT <3000 then ’Lower’
else
’Equal’
end if?>
 
Method 2:
Syntax:

<?xdoxslt:ifelse(condition,true,false)?>

Example: 

<?xdoxslt:ifelse(20=21,’yes 20 and 21 are equal’,’No 20 and 21 are not equal’)?>

Ans: No 20 and 21 are not equal

 

Using OR Condition in XML RTF Template:

Syntax:

<?if:XMLfield=value1 or XMLfield=value2?> display value <?end if?>

Example:

<?if:sum(AVALUE)=0 or sum(BVALUE)=0?>0<?end if?>

You can use whichever is applicable to your requirement.
1.Explain about Accounts Payable. 
Ans)The Accounts Payable application component records and manages accounting data for all
vendors. It is also an integral part of the purchasing system: Deliveries and invoices are
managed according to vendors. The system automatically triggers postings in response to the
operative transactions. In the same way, the system supplies the Cash Management application
component with figures from invoices in order to optimize liquidity planning. 

2.What is the meaning of invoice?
Ans)An invoice or bill is a commercial document issued by a seller to the buyer, indicating the products, quantities, and agreed prices for products or services the seller has provided the buyer. An invoice indicates the buyer must pay the seller, according to the payment terms.

In the rental industry, an invoice must include a specific reference to the duration of the time being billed, so rather than quantity, price and discount the invoicing amount is based on quantity, price, discount and duration. Generally speaking each line of a rental invoice will refer to the actual hours, days, weeks, months etc being billed.

3Can you give a sample Process Flow for Procure to Pay Cycle?

Ans) Process flow for Procure to pay will go through two departments
(Commercial & Finance)
Procure – Commercial Department The following steps involve to procure any item
1. Received Requisition from concern Department
2. Request for Quotation from Suppliers at least three
3. Finalize the best Quotation by keeping in mind about our companies standard
4. Check the Budget for the same
5. Negotiate with supplier for more economic pricing and finalize the payment terms
6. Process the PO and forward to the supplier to supply the goods and services 

Pay Cycle – Finance Department 
The following steps need to be fulfill
1. Invoice should be match with PO
2. Invoice should has all the supporting documents such as PO copy,Delivery note duly signed by receiver (our staff who authorized to received goods / store keeper)
3. If the invoice is for services then it should be forwarded to the concern department head or project manager for his confirmation of work done and his approval 
4. Even if it not the services invoice, it should forwarded to the concern person’s approval who request the PO for the same
5. Finance can reject the invoice if it is not budgeted and ask for the reasons.
6. After receiving all the confirmation and approvals from the concern department heads the invoice will be update in to the accounting system first in order to avoid any duplication of Invoice and PO (it shown on accounting package if the invoice is duplicate if not, altelast it tells you if the PO already used or cancel)
7. Finance approved the invoice and process the payment base on payment terms with the supplier.
 

4)What are the journals entries in Procure to Pay Cycle.
Ans) 

Description                                                                             DR                                  CR

A) Po creation                                                                    No Entry                          No Entry

B)  While Receiving the goods                                       Material Receiving            Ap Accurval 

C) While Inspection                                                        No Entry                            No Entry 

D) While Trans ford the good to Inventory               Inv Org Material              Material Receiving
                                                                                     Purchase price Varience

F) While Po Is Matching to Invoices                         Ap Accurval                        Liability


G) While Making the Payment                                 Liability                               Cash Clearing 


 H) Ofter Reconciliation                                           Cash Clearing                     Cash



 I) Final Entry                                                            Inv Org Material                Cash

5)What is the difference between EFT & Wire?
Ans)EFT and WIRE are the most popular form of electronic payment method. EFT stands for electronic fund transfer and it is one of the fastest mode of electronic payment after WIRE. EFT is a batch oriented mechanism for transfering funds from one bank to another because of which clearing & settlement takes around 2 to 4 days. On the other hand, WIRE is a RTGS i.e. real time gross settlement system of making the fund transfer on real time and gross basis. Clearing and settlement happens on the same day. WIRE is more expensive and faster than EFT.  

6) What is meant by Distribution Sets:

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

7)What is the meaning of GRN? 
Ans) GOODS RECEIPT NOTE MEANS IT PROVES THAT MATERIAL IS DELIVERED AT STORES DEPARTMENT. GRN IS THE BASE DOCUMENT AND IMPORTANT DOCUMENTS FOR PROOF OF RECEIPT OF MATERIAL AT WARE HOUSE.THIS CAN BE PREPARED BY STORES DEPARTMENT AND APPROVED BY PLANT HEAD. GRN CONTAINS ORDERED QTY,RECEIVED QTY AND ACCEPTED QTY. BILL WILL BE PASSED BASED THE GRN NOTE. ONCE THE GRN IS PREPARED AUTOMATICALLY INVENTORY WILL BE UPDATED AND ACCORDINGLY PAYMENT WILL BE RELEASED TO THE VENDOR.

GRN contains the following details.

1.Ordered quantity .
2.Received Quantity.
3.Defective quantity in received quantity .
4.Quality standards details.


8) How does the payment mechanism work?

Ans) The open items of an account can only be cleared once you post an identical offsetting amount to the account. In other words, the balance of the items assigned to each other must equal zero.During clearing, the system enters a clearing document number and the clearing date in these items. In this way, invoices in a vendor account are indicated as paid, and items in abank clearing account are indicated as cleared.

You generally use the payment program to clear invoices. Manual clearing of open items is therefore not usually necessary. However, you will sometimes have to clear items manually if, for example, you receive a refund from your vendor or you have set up a direct debit procedure.


9) Difference between interface tables and base tables?
Ans)   The difference between the interface and base tables is as below

Interface table: is the table where the data gets validated before data get posted to the base tables. There are many interfaces which are seeded with Oracle. You can consider as the entry point of the data, and the interface checks the sanity of data.

Base tables: As told earlier once the data is validated will get updated in the base tables, and is considered as the data which is in the base table is accurate and used in many ways. (Reporting..etc..)


The base tables in AP are as follows:

1) ap_invoices_all
 

2) ap_invoice_payments_all
 

3) ap_invoice_distibutions_All
 

4) ap_payment_schdules
 

5) ap_payment_dustributions_all
 

6) ap_checks_all
 

7) ap_accounting_events_all 


8) ap_bank_accounts_all
 

9) ap_bank_accounts_uses_all

   

10) What is the process of creating an Invoices and transferring it to GL?
Ans)

 1. create batch
2. create invoice
3. create distribution
4. validate the invoice
5. actions -à approve
6. if individual create accounting click ok
7. If batch go to batch create accounting.
8. Create accounting hits Payable Accounting(Transfer) ??Program which will create accounting.
9. Run Transfer to GL Concurrent Program
10. Journal Import
11. Post journals
12. Hits balances.


11) How do u Transfer from AP to GL? 
Ans)“Payables transfer to GL program” is used to transfer from AP to GL.

12) How many types of invoices are there in AP.
Ans) 
1. Standarad invoice 
2. Debit Memo
3. Credit Memo
4. Mixed Invoice
5. Retain age Invoice
6. Transportation invoice
7. Prepayment invoice
8. Expenses Report Invoice
9. Payment Request Invoice
10. Po default
13) How many types of purchase order types/agreements are there?
 

A) Standard Purchase Order: You generally create standard purchase orders for one-time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions. If you use encumbrance accounting, the purchase order may be encumbered since the required information is known

B) Planned PO : A planned purchase order is a long-term agreement committing to buy it
items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities and estimated cost.
EX: Buying goods for Christmas from a specific dealer.


C) Contract PO : You create contract purchase agreement with your supplier to agree on specific terms and conditions without indicating the goods and services that you will be purchasing i.e. for $ amount you must supply this much quantity. You can later issue standard PO referencing your contracts and you can encumber these purchase orders if you use encumbrance accounting.


D) Blanket PO : You create blanket purchase agreements when you know the detail of goods or services you plan to buy from a specific supplier in a period , but you do not yet know the detail of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them.
A Blanket Purchase Agreement is a sort of contract between the you and ur supplier about the price at which you will purchase the items from the supplier in future. Here you enter the price of the item not the quantity of the items. When you create the release you enter the quantity of the items. The price is not updatable in the release. The quantity * price makes the Released Amount. Now suppose your contract with your supplier is such that you can only purchase the items worth a fixed amount against the contract.
 



14.Payment Method:
A funds disbursement payment method is a medium by which the first party payer, or deploying company, makes a payment to a third party payee, such as a supplier. You can use a payment method to pay one or more suppliers. Oracle Payments supports several payment methods for funds disbursement, including the following:

  • Check
  • Electronic
  • wire
  • Clearing

Check:
You can pay with a manual payment, a Quick payment, or in a payment batch.

Electornic:
Electronic An electronic funds transfer to the bank of a supplier.You create electronic payments either through the e- Commerce Gateway, or by delivering a payment batch file to your bank. For both methods, Payables creates a file during payment batch creation. If you are using the e-Commerce Gateway to create the file of payments, an EDI translator is required to create the EDI Formatted file prior to delivering it to your bank.For electronic funds transfers, the file is formatted and delivered to your ap.out directory for delivery to your bank.

Wire:
Wire Funds transfer initiated be contacting the bank and requesting wire payment to the bank of a suplier.A payment method where you pay invoices outside of Payables by notifying your bank that you want to debit your account and credit your supplier’s account with appropriate funds. You provide your bank with your supplier’s bank information, and your bank sends you confirmation of your transaction. Your supplier’s bank sends your supplier confirmation of the payment. You then record the transaction manually.

Clearing:

Clearing Payment for invoices transferred from another entity within the company without creating a payment document.Payment method you use to account for intercompany expenses when you do not actually disburse funds through banks. You do not generate a payment document with the Clearing payment method. When you enter the invoice, you enter Clearing for the payment method.You can record a Clearing payment using a Manual type payment only. 

15.What id recurring invoices? What are AP setup steps? 
  
Ans) some times suppliers would not be sending any invoices. but still the payment have to made to home: rent, lease rentals. in this situation we have to create invoice every period wise. For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices is called template. Here we are creating the one invoice master copy is formally known as recurring invoice or recurring invoice template.

 SET UP:
 1)we have to create one special calendar 
2)we have to create one full distribution set 
3)we have to enter payment terms in the recurring invoice window 
4)enter the template no, first invoice amount, special invoice amounts
iExpenses is basically an extension Oracle Payables. Employee and Contingent Worker expense reports become supplier invoices and get paid from Payables. You will need following responsibilties to set up Internet Expenses: Payables Manager, Internet Expenses Setup and Administration, System Administration, Application Developer, and AX Developer. If you are also planning on charging expense reports to projects, you will also need Project Billing Super User and General Ledger Super User responsibilities. You will also need access to Oracle Workflow Builder to customize the Expenses workflow and Project Expense Reports Account Generator.

Setups for IExpenses : 

1.Define MOAC
2.Define Job
3.Define Position.
4.Define Employee.
5.Define Financial Options.
6.Define Expenses Template.
7.Define Payable Options.  
8.Assign Cost Center Flexfiedl qualifier to Department segment or Costcenter segment.
9.Define Signing Limits.
10.Assign Profile Option to IExpenses Responsibility.

 1.Define MOAC – See this article
  • Define Responsibilities for GL, AP,PO,HRMS,IEXPENSES
  • Define Business Group.
  • Define Ledger.
  • Define Operating Unit.
  • Define Security Profile.
  • Run Security List Maintenance Program. 
  • Assign Security Profile to Responsibilities. 
  • Run Replicate Seed Data Program.  

2.Define Job
Navigation: HRMS –> Work structures –> Job –> Description.
Click on New button. 


Enter the Job Name and Code.


 Save.
 3.Define Position.
Click on New button. 



Enter Position number and name ,type, Organization,job,and Status of the position.



Save.

Note: If you want create more position please follow same as above procedure.

4.Define Employee.

Navigation: HRMS –> People –> Enter and Maintain.

Click on New. 

 Enter Employee Last name,gender,action and birth date.


Save and click on Assignments. 

Enter HR Organization name,job name and Position name.

Save.

Click left lov button and select the purchase order information.

 Enter the primary ledger name and default expenses account.


Save. 

5.Define Financial Options.

Use the Financials Options window to define the options and defaults that you use for your Oracle Financial Application(s). Values you enter in this window are shared by Oracle Payables, Oracle Purchasing, and Oracle Assets. You can define defaults in this window to simplify supplier entry, requisition entry, purchase order entry, invoice entry, and automatic payments. Depending on your application, you may not be required to enter all fields.
Although you only need to define these options and defaults once, you can update them at any time. If you change an option and it is used as a default value elsewhere in the system, it will only be used as a default for subsequent transactions. For example, if you change the Payment Terms from Immediate to Net 30, Net 30 will be used as a default for any new suppliers you enter, but the change will not affect the Payment Terms of existing suppliers.

Navigation: Payables –> Setup –> Options –> Financial.

  
 Click on New button.

Accounting Tab:
You are required to enter defaults for the Accounting Financials Options in the Accounting region. 

Accounts Like:
Liability, Prepayment, Discount Taken.  

Supplier-Purchasing Tab:
If you do not also have Oracle Purchasing installed, you do not need to enter defaults in the Supplier- Purchasing region.


 Encumbrance Tab:
If you do not use encumbrance accounting or budgetary control, you do not need to enter defaults in the Encumbrance region. 


Tax Tab:

If your enterprise does not need to record a VAT registration number, you don’t need to enter defaults in the Tax region.

Human Resources Tab:
If you do not have Oracle Human Resources installed, you are not required to enter defaults in the Human Resources region.

 Save.

 6.Define Expenses Template.
Navigation: Payables –> Setup –> Invoice –> Expenses Report Templates.

Enter operating unit name,template name and enable the enable for internet expenses. 
And finally enter your expenses.


Save. 

7.Define Payable Options.  
Navigation: Payables –> Setup –> Options –> Payable Options.

Click on Find. 

  
Click on Expense Report Tab. 


Default Template. The default expense report template that you want to use in the Payables Expense Reports window. You can override this value in the Expense Reports window. A default expense report template appears in the Expense Reports window only if the expense report template is active.

Apply Advances. Default value for the Apply Advances option in the Expense Reports window in Payables. If you enable this option, Payables applies advances to employee expense reports if the employee has any outstanding, available advances. You can override this default during expense report entry.
If you use Internet Expenses and you enable this option, then Expense Report Export applies all outstanding, available advances, starting with the oldest, up to the amount of the Internet expense report.

Automatically Create Employee as Supplier. If you enable this option, when you import Payables expense reports, Payables automatically creates a supplier for any expense report where an employee does not already exist as a supplier. If the supplier site you are paying (HOME or OFFICE) does not yet exist, Payables adds the supplier site to an existing supplier. Payables creates a HOME or OFFICE supplier site with the appropriate address, depending on where you are paying the expense report. The Home address is from the PER_ADDRESSES table, and the Office address is from the HR_LOCATIONS table. Payables creates suppliers based on the defaults you select in this region and employee information from the Enter Person window. You can review suppliers and adjust any defaults in the Suppliers window.
If you do not enable this option, enter an employee as a supplier in the Suppliers window and link the Employee Name/Number to the supplier before you use Expense Report Export. Payables cannot export expense reports without corresponding suppliers, and lists them on Export Results page.
Payment Terms. Payment terms you want to assign to any suppliers that you create from employees during Expense Report Export.

Suggestion: Define and assign immediate payment terms for your employee suppliers.

Pay Group. Pay Group you want to assign to any suppliers that you create from employees during Expense Report Export. You can define additional values for Pay Group in the Purchasing Lookups window.
Payment Priority. Payment priority you want to assign to any suppliers that you create from employees during Expense Report Export. A number, between 1 (high) and 99 (low), which represents the priority of payment for a supplier.

Hold Unmatched Expense Reports. This option defaults to the Hold Unmatched Invoices option for the supplier and supplier site for any suppliers Payables creates during Expense Report Export.
When Hold Unmatched Invoices for a supplier site is enabled, Payables requires that you match each invoice for the supplier site to either a purchase order or receipt. If you enable this option for a site, then Payables applies a Matching Required hold to an invoice if it has Item type distributions that are not matched to a purchase order or receipt. Payables applies the hold to the invoice during Invoice Validation. You cannot pay the invoice until you release the hold. You can release this hold by matching the invoice to a purchase order or receipt and resubmitting Invoice Validation, or you can manually release the hold in the Holds tab of the Invoice Workbench. Payables will not apply a hold if the sum of the invoice distributions by accounting code combination is zero.

Save. 
 8.Assign Cost Center Flexfiedl qualifier to Department segment or Costcenter segment. 

Navigation: Payables –> Setup –> Flexfield –> Key –> Segments.

Query your COA

Un Freeze Flexfield Definition and click on segments.

 select Cost Center segment and then click on the Flexfield Qualifiers.

Enable cost center segment. 
Save.

 9.Define Signing Limits.
Navigation: Payables –> Employees –> Signing Limits.



10.Assign Profile Option to iExpenses Responsibility.


Navigation: System Administrator –> Profile –> Systems.

Please set the following Profile options in Site level as well as Responsibility level.