RECEIVABLES Interview Questions

Q: What kind of transactions can be created using AutoInvoice? A: Invoices, credit memos, debit memos, and on–account credits can be imported using AutoInvoice. Q: What are the underlying tables and validations required during AutoInvoice Interface? A: Interface tables: RA_INTERFACE_LINES_ALL Base tables: RA_CUSTOMER_TRX_ALL RA_BATCHES RA_CUSTOMER_TRX_LINES_ALL AR_PAYMENT_SCHEDULES_ALL RA_CUSTOMER_TRX_LINE_SALESREPS RA_CUST_TRX_GL_DIST_ALL AR_RECEIVABLES_APPLICATIONS AR_ADJUSTMENTS RA_CUSTOMER_TRX_TYPES_ALL Concurrent Program: Auto invoice master program Validations: check for amount, batch source name, conversion rate, conversion type. Validate orig_system_bill_customer_id, orig_system_bill_address_id, quantity. Validate if the amount includes tax flag. Q: Explain the different steps in implementing Autolockbox. A: Import, Validate, Post Quick Cash Q: What are the different Invoice matching types? A: 2-way matching: 2-way matching verifies that Purchase order and invoice quantities must match within your tolerances 3-way matching: 3-way matching verifies that the receipt and invoice information match with the quantity tolerances 4-way matching: 4-way matching verifies that acceptance documents and invoice information match within the quantity tolerances Q: What are the different Transaction types in AR? A: Invoice, Credit Memo, Debit Memo,Charge back, commitments Q: Tell me about TCA? A: TCA canbe used to import or modify Customers related data. Q: Name some Flexfields in AR. A: Sales Tax Location, Territory Q: Explain the steps involved in Transfer to GL from AR. A: Transfer the transactions to GL_Interface Import the Journals Post the Journals Q: What is the dbnumber of a particular cusotmer TCA? A: It is a unique number used to identify the Customers. Q: Where can you find the Customer payment terms? A: In the table hz_customer_profiles Q: What is the link between OM and AR? A: To relate the Order Number (ONT) to the Invoice (AR) we use the LINE TRANSACTION FLEX FIELDS. In RA_CUSTOMER_TRX_ALL, INTERFACE_HEADER_ATTRIBUTE1 to INTERFACE_HEADER_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order (HEADER INFO). In RA_CUSTOMER_TRX_LINES_ALL, INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order.(LINE INFO)

PAYABLES Interview Questions

Q: 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 Q: 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. Q: 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 Q: 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. Q: 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. Q: In which table we can find the vendor number? A: PO_VENDORS Q: 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) Q: What are the different types of Invoices in Payables? A: Standard, Credit Memo, Debit Memo, Expense Report,PrePayment, Mixed, PO Default Q: 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. Q: How many key flexfields are there in Payables? A: No Key Flexfields in AP Q: What is the Distribution Type while entering the Invoice? A: Item, Tax, Miscellaneous,Freight, Withholding Tax Q: What are the Prepayment types? A: Temporary and Permanent Q: 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. Q: 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. Q: 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. Q: 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. Q: How you will transfer payables to general ledger? A: Create Accounting. Transfer the transactions to GL_Interface Import the Journals Post the Journals Q: What program is used to transfer AP transactions to GL? A: Payables Transfer to General Ledger Program Q: 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. Q: 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. Q: 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. Q: What will accrue in Payables? A: Expenses and Liabilities Q: 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. Q: Which module is the owner of Vendor/Supplier tables? A: Purchasing Q: 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. Q: 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.

PURCHASING Interview Questions

Q: What is Blanket PO? A: A Blanket PO is created when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not know the detail of your delivery schedules. Q: What are different types of PO’s ? A: Standard, Blanket, Contract, Planned Q: How does workflow determines whom to send the PO for approval? A: It Depends on the setup whether it is position based or supervisor based. Q: Can you create PO in iProcurement ? A: No Q: Give me some PO tables A: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL,PO_DISTRIBUTIONS_ALL Q: Tell me about PO cycle? A: Create PO Submit it for Approval Receive Goods against the PO (when order is delivered by the vendor) Close the PO after the invoice is created in AP and teh payments have been made to the vendor. Q: Explain Approval Heirarchies in PO. A: Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships. If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it. Q: What functions you do from iProcurement? A: Create Requisition, Receive the goods. Q: What is difference between positional hierarchy and supervisor hierarchy? A: If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it. Q: What is the difference between purchasing module and iProcurement module? A: Iprocurement is a self service application with a web shopping interface. WE can only create and manage requisitions and receipts. Purchasing module is form based and also lets you create PO and many other functions are possible other than requisitions and receiving. Q: What is dollar limit and how can you change it? A: An approval group is defined which is nothing but a set of authorization rules comprised of include/exclude and amount limit criteria for the following Object Types: Document Total, Account Range, Item Range, Item Category Range, and Location that are required to approve a PO. You can always change the rules by doing the below: Navigation: Purchasing Responsibility > Setup > Approvals > Approval Groups Query the Approval group and change teh rules accordingly. Q: What is Planned PO? A: A Planned PO is a long–term agreement committing to buy 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. Q: What is backdated Receipt? A: Creating a Receipt with "Receipt Date" less than sysdate or today's date is referred to as 'Backdated Receipt". Q: Is it possible to create a backdated receipt with a receipt date falling in closed GL period? A: No. The receipt date has to be with in open GL period. Q: What is Receipt Date Tolerance? A: The buffer time during which receipts can be created with out warning/error prior or later to receipt due date. Q: How do we set the Receipt Tolerance? A: Receipt Tolerance can be set in three different places. 1. Master Item Form (Item Level) 2. setup, organization form (Organization Level) 3. Purchase Order, Receiving controls. (shipment level). Q: EXPLAIN ABOUT PO FLOW A: CREATE REQUISTION, RAISE RFQ(REQUEST FOR QUOTATION),QUOTATIONS,PURCHASE ORDER,RECIEPTS

Tehnical Flow of OM

Tehnical Flow of OM

Understanding data flow for “Standard Order”


1. Order Entry
This is first stage when Order in enter in system.When the order is entered it basically create a record in order headers and Order Lines table.
•oe_order_headers_all (Here the flow_status_code as entered)
•oe_order_lines_all (flow_status_code as entered) ( order number is generated)

2.Order Booking
This is next stage , when Order which is entered in step 1 is booked and Flow status changed from Entered to Booked.At this stage , these table get affected.
•oe_order_headers_all (flow_status_code as booked ,booked_flag updated)
•oe_order_lines_all (flow_status_code as awaiting shipping, booked_flag updated)
•wsh_new_deliveries (status_code OP open)
•wsh_delivery_details (released_status ‘R’ ready to release)
Same time, Demand interface program runs in background And insert into inventory tables mtl_demand

3. Reservation
This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background and quantities are reserved.Once this program get successfully get completed , the mtl_reservations table get updated.

4. Pick Release
Ideally pick release is the process which is defined in which the items on the sales order are taken out from inventory.
Normally pick release SRS program runs in background . Once the program get completed these are the table get affected:
•oe_order_lines_all (flow_status_code ‘PICKED’ )
•wsh_delivery_details (released_status ‘S’ ‘submitted for release’ )
•mtl_txn_request_headers
•mtl_txn_request_lines
(move order tables.Here request is generated to move item from saleble to staging sub inventory)
•Mtl_material_transactions_temp (link to above tables through move_order_header_id/line_id

5.Pick Confirm
Items are transferred from saleble to staging Subinventory.
•mtl_material_transactions
•mtl_transaction_accounts
•wsh_delivery_details (released_status ‘Y’‘Released’ )
•wsh_delivery_assignments

6.Ship Confirm
Here ship confirm interface program runs in background . Data removed from wsh_new_deliveries
•oe_order_lines_all (flow_status_code ‘shipped’)
•wsh_delivery_details (released_status ‘C’ ‘Shipped’)
•mtl_transaction_interface
•mtl_material_transactions(linked through Transaction source header id)
•mtl_transaction_accounts
•Data deleted from mtl_demand,mtl_reservations
•Item deducted from mtl_onhand_quantities

7.Enter Invoice
This is also called Receivables interface, that mean information moved to accounting area for invoicing details.
•Invoicing workflow activity transfers shipped item information to Oracle Receivables.
•ra_interface_lines_all (interface table into which the data is transferred from order management)T
•Then Autoinvoice program imports data from this
•Table which get affected into this stage are recievables base table.
ra_customer_trx_all (cust_trx_id is primary key to link it to trx_lines table and trx_number is the invoice number)
ra_customer_trx_lines_all (line_attribute_1 and line_attribute_6 are linked to header_id (or order number) and line_id of the orders)

8.Complete Line
In this stage order line leval table get updated with Flow status and open flag.
•oe_order_lines_all (flow_status_code ‘shipped’, open_flag “N”)
9.Close Order
This is last step of Order Processing . In this stage only oe_order_lines_all table get updated.
These are the table get affected in this step.
•oe_order_lines_all (flow_status_code ‘closed’,open_flag “N”)
These are the typically data flow of a order to cash model for a standard order.

Operating Unit and Inventory Organization link

Operating Unit and Inventory Organization link

Query which gives Operating Unit Information and corresponding Inventory Orgs related information also

SELECT hou.NAME operating_unit_name, hou.short_code,
hou.organization_id operating_unit_id, hou.set_of_books_id,
hou.business_group_id,
ood.organization_name inventory_organization_name,
ood.organization_code Inv_organization_code, ood.organization_id Inv_organization_id, ood.chart_of_accounts_id
FROM hr_operating_units hou, org_organization_definitions ood
WHERE 1 = 1 AND hou.organization_id = ood.operating_unit
ORDER BY hou.organization_id ASC

SQL Query to get Oracle HR Organization Hierarchy

SQL Query to get Oracle HR Organization Hierarchy

SQL Query to get Oracle HR Organization Hierarchy

 

 

SELECT
LPAD(' ',10*(LEVEL-1)) || org.name hierarchy,
org.organization_id
FROM
hr_all_organization_units org,
per_org_structure_elements pose
WHERE 1=1
AND porg.organization_id = pose.organization_id_child
AND pose.org_structure_version_id = 61
--and org.name  like '201.Financiale Services'
START WITH
pose.organization_id_parent = 115   -- Orgnization of parent id -- provide the id from which level the downward hierarchy should be displaed
CONNECT BY PRIOR
pose.organization_id_child = pose.organization_id_parent
ORDER SIBLINGS BY
org.location_id,
pose.organization_id_child

How to disable prompting the password for diagnostics/examine/personalization for forms

How to disable prompting the password for diagnostics/examine/personalization for forms

To disable prompting the apps password for diagnostics and examine/personalizations at form level

Set the value as Yes to the profile option "Utilities: Diagnostics" at any level

Logout and login to see the effect.