Oracle Apps R12 Functional (Finance) Consultant: 2013

Saturday, 21 December 2013

Join Key Conditions

Key Join Conditions

Key

GL AND AP

1) GL_CODE_COMBINATIONS --> AP_INVOICES_ALL

code_combination_id = acct_pay_code_combination_id

2) GL_CODE_COMBINATIONS ---> AP_INVOICES_DISTRIBUTIONS_ALL

code_combination_id = dist_code_combination_id

3) GL_SETS_OF_BOOKS AP_INVOICES_ALL

set_of_books_id = set_of_books_id

GL AND AR

GL_CODE_COMBINATIONS RA_CUST_TRX_LINE__GL_DIST_ALL

code_combination_id = code_combination_id

GL AND INV

GL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B

code_combination_id = cost_of_sales_account

GL AND PO

GL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL

code_combination_id = code_combination_id

PO AND AP

1) PO_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL

Po_distribution_id = po_distribution_id

2) PO_VENDORS AP_INVOICES_ALL

vendor_id = vendor_id

PO AND SHIPMENTS

1) PO_HEADERS_ALL RCV_TRANSACTIONS

Po_header_id = po_header_id

2) PO_DISTRIBUTIONS_ALL RCV_TRANSACTIONS

Po_distribution_id = po_distribution_id

SHIPMENTS AND INVOICE

RCV_TRANSACTIONS AP_INVOICE_DISTRIBUTIONS_ALL

RCV_TRANSACTION_ID = RCV_TRANSACTION_ID

PO AND INV

PO_REQUISITION_LINES_ALL MTL_SYSTEM_ITEMS_B

item_id = inventory_item_id

org_id = organization_id

PO AND HRMS

PO_HEADERS_ALL HR_EMPLOYEES
Agent_id = employee_id

PO AND REQUISITION

PO_DISTRIBUTIONS_ALL PO_REQ_DISTRIBUTIONS_ALL

req_distribution_id = distribution_id

SHIPMENTS AND INV

RCV_TRANSACTIONS MTL_SYSTEM_ITEMS_B

Organization_id = organization_id

INV AND HRMS

MTL_SYSTEM_ITEMS_B HR_EMPLOYEES

buyer_id = employee_id

OM AND AR

1) OE_ORDER_HEADERS_ALL RA_CUSTOMER_TRX_LINES_ALL

TO_CHAR( Order_number) = interface_line_attribute1

2) OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL

TO_CHAR(Line_id) = interface_line_attribute6

3) OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL

reference_customer_trx_line_id = customer_trx_line_id

OM AND SHIPPING

1) OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS

HEADER_ID = SOURCE_HEADER_ID

2) OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS

LINE_ID = SOURCE_LINE_ID

AP AND AR (BANKS)

AR_CASH_RECEIPTS_ALL AP_BANK_ACCOUNTS

REMITTANCE_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID

AP AND AR

HZ_PARTIES AP_INVOICES_ALL

PARTY_ID = PARTY_ID

OM AND CRM

OE_ORDER_LINES_ALL CSI_ITEM_INSTANCES(Install Base)

LINE_ID = LAST_OE_ORDER_LINE_ID

Table Name: Po_Requisition_Headers_All (A)

Column Names Table Name Column Name

A. REQUISITION_HEADER_ID PO_REQUISITION_LINES_ALL REQUISITION_HEADER_ID

A. TYPE_LOOKUP_CODE PO_DOCUMENT_TYPES DOCUMENT_SUBTYPE

A. PREPARER_ID PER_PEOPLE_F PERSON_ID

A. ORG_ID MTL_SYSTEM_ITEMS ORGANIZATION_ID

A. ORG_ID MTL_ORGANIZATIONS ORGANIZATION_ID

Table Name: Po_Requisition_Lines_All (B)

Column Names Table Name Column Name

B .REQUISITION_HEADER_ID PO_REQUISITION_HEADERS_ALL REQUISITION_HEADER_ID

B .REQUISITION_LINE_ID PO_REQ_DISTRIBUTIONS_ALL REQUISITION_LINE_ID

B .LINE_TYPE_ID PO_LINE_TYPES LINE_TYPE_ID

B .ITEM_ID MTL_SYSTEM_ITEMS INVENTORY_ITEM_ID

B .ORG_ID MTL_SYSTEM_ITEMS ORGANIZATION_ID

Table Name: Po_Requisition_Distributions_All (C) .

Column Names   Table Name Column Name

C .REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL REQUISITION_LINE_ID

C .DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL REQ_DISTRIBUTION_ID

C .SET_OF_BOOKS_ID GL_SETS_OF_BOOKS SET_OF_BOOKS_ID

C .CODE_COMBINATION_ID GL_CODE-COMBINATIONS CODE_COMBINATION_ID

Table Name: Po_Distributions_All (D) .

Column Names Table Name   Column Name

D .PO_LINE_ID PO_LINES PO_LINE_ID

D .REQ_DISTRIBUTION_ID PO_REQ_DISTRIBUTIONS_ALL DISTRIBUTION_ID

D .PO_DISTRIBUTION_ID AP_INVOICE_DISTRIBUTIONS_ALL PO_DISTRIBUTION_ID

Table Name: Po_Headers_All( E ).

Column Names   Table Name   Column Name

E .PO_HEADER_ID PO_LINES PO_HEADER_ID

E .PO_HEADER_ID RCV_SHIPMENT_LINES PO_HEADER_ID

E .VENDOR_ID PO_VENDORS VENDOR_ID

E .AGENT_ID PER_PEOPLE PERSON_ID

E .TYPE_LOOK_UP_CODE PO_DOCUMENT_TYPES DOCUMENT_SUBTYPE

Table Name: Po_Lines_All (F).

Column Names Table Name   Column Name

F.PO_HEADER_ID PO_HEADERS PO_HEADER_ID

F.PO_LINE_ID PO_DISTRIBUTIONS_ALL PO_LINE_ID

F.ITEM_ID MTL_SYSTEM_ITEMS ITEM_ID

Table Name: Rcv_Shipment_Lines (G).

Column Names Table Name Column Name

G.PO_HEADER_ID PO_HEADERS PO_HEADER_ID

G.SHIPMENT_HEADER_ID RCV_SHIPMENT_HEADERS SHIPMENT_HEADER_ID

Table Name: Ap_Invoices_All (H).

Column Names Table Name Column Name

H. INVOICE_ID AP_INVOICE_DISTRIBUTIONS_ALL INVOICE_ID

Table Name: Oe_Order_Headers_All (I).

Column Names Table Name Column Name

I.HEADER_ID OE_ORDER_LINES HEADER_ID

I.SOURCE_HEADER_ID WISH_DELIVERY_DETAILS SOURCE_HEADER_ID

I.PRICE_LIST_ID QP_LIST_HEADERS_TL LIST_HEADER_ID

I.ORG_ID MTL_ORGANIZATIONS ORGANIZATION_ID

I.SALESREP_ID JTF_RS_SALESREPS SALESREP_ID

I.ORDER_TYPE_ID OE_TRANSACTION_TYPES TRANSACTION_TYPE_ID

I.ORDER_SOURCE_ID OE_ORDER_SOURCES ORDER_SOURCE_ID

I.ACCOUNTING_RULE_ID RA_RULES RULE_ID

I.PAYMENT_TERM_ID RA_TERMS TERM_ID

I.SOLD_TO_ORG_ID HZ_CUST_ACCOUNTS CUST_ACCOUNT_ID

I.SHIP_FROM_ORG_ID MTL_PARAMETERS ORGANIZATION_ID

I.SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL SITE_USE_ID

Table Name: OE_Order_Lines_All (J).

Column Names Table Name   Column Name

J.LINE_TYPE_ID OE_TRANSACTION_TYPES_TL TRANSACTION_TYPE_ID

J.INVOICING_RULE_ID RA_RULES RULE_ID

Table Name: Hz_Parties (K).

Column Names Table Name   Column Name

K.PATY_ID HZ_CUST_ACCOUNTS PATY_ID

K.CUST_ACCOUNT_ID OE_ORDER_LINES SOLD_TO_ORG_ID

Table Name: Hz_Party_Sites_All (L).

Column Names Table Name Column Name

L.PATY_ID HZ_PARTIES PATY_ID

L. LOCATION_ID HZ_LOCATIONS LOCATION_ID

Table Name: Wsh_delivery_details (M).

Column Names   Table Name Column Name

M.SOURCE_HEADER_ID OE_ORDER_HEADERS SOURCE_HEADER_ID

M.DELIVERY_DETAIL_ID WSH_DELIVERY_ASSIGNMENTS DELIVERY_DETAIL_ID

M.DELIVERY_ID WSH_NEW_DELIVERIES DELIVERY_ID

M.INVENTORY_ITEM_ID MTL_SYSTEM_ITEMS INVENTORY_ITEM_ID

Table Name: RA_CUSTOMER_TRX_ALL (N).

Column Names   Table Name   Column Name

N.CUSTOMER_TRX_ID AR_RECEIVABLE_APPLICATIONS_ALL APPLIED_CUSTOMER_TRX_ID

N.TERM_ID RA_TERMS TERM_ID

N.CUSTOMER_TRX_ID RA_CUST_TRX_LINE_GL_DIST CUSTOMER_TRX_ID

Table Name: AR_CASH_REC EIPTS_ALL (O).

Column Names Table Name Column Name

O.CASH_RECEIPT_ID AR_RECEIVABLE_APPLICATIONS_ALL CASH_RECEIPT_ID

O.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS SET_OF_BOOKS_ID

Procure To Pay(Complete Functional Flow in apps r12)..............

Stage 1: Choosing an Item

Go to Purchasing Responsibility--Items--Master Items

Click on tools and choose “Categories” to view the below screen.

Stage 2: Creation of Requisition

Create a new Requisition for the item viewed in Stage 1.

Click on Distributions to View the charge Account.

Save and Submit for Approval

Stage 3 : Checking the Status of Requisition

Query for the Requisition Number and click Find.

hence it shows the status as approved.

To see the approval status, please follow the below navigation.

Stage 4 : Creation of Purchase Order

Query for the Requisition

Click on Automatic as shown in the above figure to create a Purchase Order

Click on “Create” button to create a Purchase order

View the shipment screen to change the “Match Approval Level” to “2-Way”.

Click the “Receiving Controls” to make sure that the “Routing” is made as “Direct Routing”

Click Save and submit for Approval.

Stage 5: Creation of Receipts

Query with the Purchase order created in the above stage.

Check the check box near to the lines that are received and click save.

Click the “Header Button” to view the Receipt Number.

Stage 6: Checking the On Hand

Query for our Receipt and make sure the Organization is the same as we received.

Below screen will show that our inventory has been increased by 5 quantities.

Stage 7: Check the Material Transactions

Query for the item and date as below

Below screen shows the source and transaction Type

Below screen shows you the Serial Numbers of the items received.

Stage 8: Creation of Invoice

Navigate to any Purchasing Responsibility and view à Requests

Check the status of the program.

Stage 9: Checking the Invoice

Query for the Purchase order as below,

Click “Actions” Button then tick the “Validate Check Box” and press “Ok” to validate the invoice

Below screenshot will give you the status of the invoice

Stage 10: Creation of Accounting and Payment

Once invoice got approved, we can “Create Accounting” and “Create Payments” via “Action” Button in the “Invoice Form” as we validated the invoice.

(R12) Primary Ledger, Secondary Ledger

Primary Ledger:

1. Chart of accounts
2. Accounting calendar
3. Primary currency
4. Subledger Accounting Method (SLA)

Secondary Ledgers :

- Optional, additional accounting representations of your primary ledger
- The Secondary Ledgers are used for supplementary purposes and can be used for global companies to comply with various legal requirements.
- Can differ in one or more of the following from the primary ledger

1. Chart of accounts
2. Accounting calendar
3. Primary currency
4. Subledger Accounting Method (SLA)

Multi-Org Access Control (MOAC)

1. Multi-Org Access Control, or MOAC, enables users to access multiple operating units from a single application responsibility.

2. Operating unit security will be preserved such that companies can effectively implement security and shared services at the same time.

3. Enhanced Multi-Org Reporting provides the ability to process and report critical financial information at different levels of the enterprise.

1. Create Security Profile: HRMS Resp--Security--Profile---

2. Run Security List Maintenance program: View--Request--Single Request--ok--Program Name: Security List Manitenance--ok--ok--Submit--No--Find

3. Setup profile option MO: Security Profile (System administrator--profile--system)

4. Setup profile option MO: Default Operating Unit

Note: If a responsibility has to access only one operating unit, then set the profile option - MO: Operating Unit. If a responsibility has to access multiple operating units, then define a security profile with multiple operating units assigned and assign it to the MO: Security Profile profile option

Monday, 25 November 2013

Functional Documents

Application Implementation Method is a provan approach, which specifies all the activities which are required to implement oracle applications successfully.There are eleven processes of implementation.

1. Business Process Architecture[BP]-80

This phase explains
i.Existing business practices
ii.Catalog change practices
iii.Leading practices
iv.Future practices

2. Business Requirement Definition[RD]-20

This phase explains about the
i.Base line questionnaire and
ii.The gathering of information.

3. Business Requirement Mapping[BR]-100

In this phase we can match all the requirements of business with the standard functionality of the oracle applications.

If all the requirements match with oracle standard (with out customization) functionality then, it is called as vanilla implementation).

4. Application and Technical Architecture [TA]

Explains the infrastructure requirements to implement oracle applications.
For example:
desktops
software
hardware

people...etc

5. Build and Module Design[MD]-50

In this phase concentrate on developing the new functionality which is required by the client.
This is called customization.
In this phase explains how to design a forms, database and reports...

6. Data Conversion:[CV]-40

Is the process of converting or transferring the data from legacy system to oracle applications? This is called as data migration.
Ex: transferring the closing balances of the previous year as an opening balances to next year.

7. Documentation:[DO]
In this phase we have to prepare module wise user guides and implementation manuals which helps in the implementation.

8. Business System Testing:[TE]-40

A process of validating the setup’s and the functionality by a tester to certify its status is allied business system testing. It is done by a functional consultant.

9. Performance Testing:[PT]

Performance testing means evaluation of transaction saving time, transaction retrieval times. It is done by a technical team.

10; Adoption and Learning.[AP]

This phase explains about the removal of the legacy system of the client. The entire user should be trained with new oracle applications. In this phase we have to prepare user manuals.

11. Production Migration[PM]

A process of decommissioning of legacy system and the usage of new oracle application system begins in this phase.

Tuesday, 19 November 2013

AP Interview Questions

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.

3)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 Approval

C) While Inspection No Entry No Entry

D) While Transford the good to Inventory Inv Org Material Material Receiving

E) 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

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

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

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

7) 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 a bank 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.

8) 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

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

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

11) 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

12) How many types of purchase order types/agreements are there?

A) Standard PO: 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.

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

14).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 recurringinvoice 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

15): What is the process/steps for Vendor Conversion?

A: 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

16): What is Debit Memo & Credit Memo in Payables?

A: Credit Memo is a negative amount invoice you receive from a supplier representing a credit.

Debit Memo is a negative amount invoice you send to notify a supplier of a credit you recorded for

goods or services purchased.

17): Explain the set up used for Automatic or Manual Supplier Numbering.

A: 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

18): What is Contract PO?

A: 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.

19) What is a Payable Document?

A: 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.

20) In which table we can find the vendor number?

A: PO_VENDORS

21) Give the cycle from creating an invoice to transferring it to GL in AP.

A: 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)

22) What are the different types of Invoices in Payables?

A: Standard, Credit Memo, Debit Memo, Expense Report,PrePayment, Mixed, PO Default

23) You have created a new SOB. How will you attach this SOB to AP?

A: Go to Payables Manager for the appropriate Operating Unit.
Navigation:Setup--->Set of Books--->choose.

24) How many key flexfields are there in Payables?

A: No Key Flexfields in AP

25)What is the Distribution Type while entering the Invoice?

A: Item, Tax, Miscellaneous,Freight, Withholding Tax

26) What are the Prepayment types?

A: Temporary and Permanent

27) What is Aging Periods?

A: Aging Periods window are the time periods for the Invoice Aging Report. The Invoice Aging Report provides information about invoice payments due during four periods you specify.

28) Whats the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program?

A: Payables Open Interface -- for importing regular invoices Payables Invoice Import -- for importing expense reports. In 11i renamed as Expense Report Import.

29): What is prepayment & steps to apply it to an Invoice?

A: Prepayment is a type pf 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.

30) Can you hold the partial payment if yes then how?

A: 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.

31) How you will transfer payables to general ledger?

A: Create Accounting. Transfer the transactions to GL_Interface Import the Journals Post the Journals

32) What program is used to transfer AP transactions to GL?

A: Payables Transfer to General Ledger Program

33) What is use of AP Accounting Periods?

A: 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.

34) What are the different interface programs in AP?

A: 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.

35)What is Invoice Tolerance?

A: 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.

36) What will accrue in Payables?

A: Expenses and Liabilities

37) What is a Hold? Explain the types of Hold.

A: 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.

38) Which module is the owner of Vendor/Supplier tables?

A: Purchasing

39) What is Payment Terms?

A: Payment Terms let you define the due date or the discount date , due amount or discount amount. Once the payment terms are defined, you can attach these to the suppliers and supplier sites and these terms will be automatically populated once the invoice is entered for a supplier site.

40) In AP the suppliers didn’t visible in India Creditors Ledger Report Parameter?

A: pls check whether that particular supplier is available in Suppliers addition inforamtion or not.

GL Interview Question

1) Can a flexfield qualifier be changed after it has been created?

Ans) No.

Once a segment qualifier has been designated for a specific segment and has been saved, it will permanently have the attributes with that qualifier.

For example, you accidentally designate the cost center segment as the natural account segment. Even though you do not compile this, the system saves the changes. And once it has been saved, it will have all the attributes designated for the natural account qualifier, even after it has been changed back, resaved with the correct qualifier and compiled. This is the inherent functionality of the software. Unfortunately, there is no real easy solution for this issue. The only option is to create a new chart of accounts and attach a new set of books.

2) How to delete a segment value?

Ans) There is no supported way to delete a segment value. Segment values can only be disabled not deleted.

3) Is there a way to load values for a specific segment outside of the form?

Ans) iSetup is the Oracle product that provides supported APIs to load values into Oracle Applications flexfields.
To load code combinations ADI may be used. Uploading zero amount journals will create new code combinations.
In this case Dynamic Insertion should be enabled and all account segment values need to exist before the new account code combinations will be dynamically created.

4) What are the different types of Journals in General Ledger ?

Ans) 1. Functional Currency Jv: This Journal, we enter Local Currency transaction purpose.

2. Foreign Currency Jv: this Journal, we enter other than local currency transaction purpose...before we define exchange rates

3.Suspense Jv: this Journal, whenever debit is not equal to credit that time, we enable in set of books window Suspense button, then it works otherwise it's not working

4.Tax Jv: this Journal, calculate taxation of Purchased items

5.Reverse Jv: this Journal whenever we enter recurring journal, at the time of we using..We have two methods...one is Debit to Credit and second one is sign (+ to -)

6.Recurring Jv :this one is We define one template, we use Periodically, these are 3 types
1.Standard 2.Skeleton 3.Formula

7.Mass Allocation Jv :Set of Expenses or Set of Revenue allocate different parts using Formula A*B/C
A is Total Cost Pool..B is Usage Factor...C is Total Usage Factor...

8. Batch JV: Group of Journal we enter at a time, We Define Control Amount

9. Stat JV: This JV we have one side of Amount either debit or Credit.....

5) What is average Balance In Oracle Financials?

Ans) The Average Balance feature of Oracle General Ledger provides organizations with the ability to track average and end-of-day balances, report average balance sheets, and create custom reports using both standard and average balances. Average balance processing is particularly important for financial institutions, since average balance sheets are required, in addition to standard balance sheets, by many regulatory agencies. Many organizations also use average balances for internal management reporting and Profitability analysis.

6) Is there a limit to the number of periods in a budget year or how many years a budget can span?

Ans) One can define budgetary control for n number of years however, one year can have maximum of 60 fiscal periods.

7) What is a funding budget?

Ans) A budget against which accounting transactions are checked for available funds when budgetary control is enable for your set of books.

8) What is planning budget

Ans) The plan for the future expenses is planning budget. It is a paper work. There is no funds requirement. It does not require journals. There are no restrictions for estimating of funds.

9) I was able to post a budget journal to a closed period, why?

Ans) Yes you can do so, reason being budget journal is not linked with your accounting period. Once you have open the budget period then you can book budget journal for that whole period.

10) What are the interface tables in General Ledger ?

Ans) GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY

11) What is DFF.

Answer: DFF is a mechanism that lets us create new fields in screens that are delivered by Oracle

12) What is Journal Import?

Ans) Journal import is an interface used to bring journal entries from legacy systems and other modules into the General Ledger.(Specifically Journal Import gets entries from legacy data into the GL base tables.
The tables populated during journal Import are
GL_JE_BATCHES,
GL_JE_HEADERS,
GL_JE_LINES,
GL_IMPORT_REFERENCES

13) What is the use of GL_Interface?

Ans) Gl_Interface is the primary interface table of General ledger. It acts as an interface between data originating from other modules such as AP,AR, Legacy data and the Gl Base tables.

14) What is Actual Flag?

Ans) Actual flag represents the Journal type.
A-Actual
B-Budget
E- Encumbrance.

15) What is Encumbrance?

Ans: It is a process of Reservation of funds for anticipated expenditure from a budget. Encumbrance integrates GL, Purchasing and Payables modules.

16) How many Key Flex Fields are there in General Ledger?

Ans) One. Accounting Key Flex Field.

17) How many types of Budgets are there?

Ans) Two Types.
Expenditure Budgets
Revenue Budgets.

18)What are Spot Rate, Corporate Rate, Transaction Calendar and Accounting Calendar?

Ans) Spot Rate:
An exchange rate which you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of currency.

Corporate Rate:
An Exchange rate that we define to standardize rates for our company. This rate is the standard market rate determined by the senior financial management for use through out the organization.

User Rate:
Conversion rate that is defined by the user.
EMU Fixed Rate: An exchange rate that is provided automatically by the General Ledger while entering journals. It uses a foreign currency that has a fixed relationship with the euro.
Transaction Calendar: Defines the business days and holidays for any calendar.
Accounting Calendar: Defines different types of calendars namely Fiscal, Federal Fiscal, Month etc.

19)What is Security Rule?

Ans) Security Rules are defined to control the access of a flexfield segment value (Financial information) at a responsibility level.

20) What are Cross Validation & ADI?

Ans) CVS – Cross validate segments – Allows only valid code combinations.
ADI – Allow dynamic inserts. – Allows any code combination irrespective of validity.
ADI would prevail if both of CVS and ADI are checked.

21)What is Translation?

Ans) Translation is a process used to convert functional currency to other reporting currencies at the account balances level.

22)What is Revaluation?

Ans) It is process used to revalue assets and liabilities denominated in foreign currency into functional currency based on period end exchange rate we specify. Unrealized gains/losses are resulted because of exchange rate fluctuations which are recorded in unrealized gain/loss account in GL.

23)What is FSG (Financial Statement Generator)?

Ans) Financial statement generator feature helps us to generate reports such as balance sheets and income statements with out programming. It also provides a high degree of control on the rows, columns, contents and calculations on the report. Different components such as row set, column set, content set, row order, display set have to be defined before a statement is generated, of which row set and column set are mandatory.

24) What is Consolidation?

Ans) Consolidation is a period-end process of combining the financial results of separate business subsidiaries with the parent company to form a single combined statement of financial results.

25) At what level General Ledger data is secured?

Ans) GL data is secured at Set of Book level. Subledger module data is secured at Responsibility level (i.e., at Operating Unit Level).

26) Difference between Primary Ledger and Secondary Ledger in R12 ?

Ans) Primary ledger:

The primary ledger acts as the primary accounting representation

Secondary Leger:
Secondary ledgers represent the primary ledger's accounting data in another accounting representation that differs in one or more of the following ways:
i. chart of accounts
ii. accounting calendar/period type combination
iii. currency
iv. subledger accounting method
v. ledger processing options

Use secondary ledgers for supplementary purposes, such as consolidation, statutory reporting, or adjustments for one or more legal entities within the same accounting setup. For example, use a primary ledger for corporate accounting purposes that uses the corporate chart of accounts and subledger accounting method, and use a secondary ledger for statutory reporting purposes that uses the statutory chart of accounts and subledger accounting method. This allows you to maintain both a corporate and statutory representation of the same legal entity's transactions in parallel.
Assign one or more secondary ledgers to each primary ledger for an accounting setup.
The secondary ledgers assigned can only perform the accounting for the legal entities within the same accounting setup.