Friday, 26 April 2013

STEPS For AR Invoice Interface in Oracle Apps

Steps for AR Invoice Interface are:

1.    Put the data into your staging tables.


2.    Calls your package to validate the data and load into AR Interface tables (RA_INTERFACE_LINES_ALL & RA_INTERFACE_DISTRIBUTIONS_ALL).

3.    Then submits a concurrent request for AutoInvoice.

If any errors occur it can be found in ra_interface_errors_all table. The concurrent program has 2 stages. First the Master program fires which intern kicks of the Import Program. Once this is completed data is inserted into the following tables.
1) ra_customer_trx_all (Invoice Header Info)
2) ra_customer_trx_lines_all (Invoice Line Level Info)
3) ra_cust_trx_line_gl_dist_all (Accounting Info. One record for each Account Type is inserted into this… ex. Receivable Revenue Tax Freight etc)
4) ar_payment_schedules_all (All Payment related info)

Validations:
Validation are generally done on the below columns.
·             Batch_source_name
·             Set_of_books_id
·             Orig_sys_batch_name
·             orig_system_bill_customer_ref
·             orig_system_bill_address_ref
·             Line_Type
·             Currency_Code
·             Term_name
·             Transaction_type
·             Interface_line_attribute1-7
·             Account_class
·             Accounting Flexfields segments

1- AR Transaction Type Validation: Check if the Transaction type provided in data file is defined in AR transaction types (RA_CUST_TRX_TYPES_ALL)
2- Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).
3- Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).
4- Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer (RA_CUSTOMERS).
5- Primary Sales Representative Validation: Sales representative number to be hardcode to “-3” for “No Sales Credit.”
6- Term Name: Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)
7- Inventory Item Validation: Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).
8- Unit of Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table
9- Invoice Tax Code Validation: Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.
10- Invoice GL Date Validation: Check if the GL Data of provided invoices is in open period.

For MOAC:
You need to add the below columns and need to do validations if your application supports MOAC.
·             conversion_type
·             conversion_rate
·             conversion_date


Thursday, 28 March 2013

Oracle Apps Module Wise Interview Questions

AP/AR/GL/FA/CM
 
1) What are cycles of GL, AP, and AR?
2) What id recurring invoices? What are AP setup steps?
3) Interface of the transactions from legacy system to ERP – Conversion Strategy Methodology?
4) What Sub ledgers does Oracle General Ledger 11i Drilldown support?
5) What dependencies have to be loaded to with regard to the future transactions or for upload of Open Transactions in AR?
6) What is an invoice? How many types of invoices are there in AP and AR?
7) What strategy would be adopted to upload the total transactions – open & closed – specifically with regard to the upload of closed AP Invoices, Purchase Orders, and Sales Orders?
8) Explain in brief how the Reconciliation process works in AP & AR?
9)  What are different types of journal entries?
   10)  Whether the closed Purchase Orders can be uploaded with back date in PO and also the Sales Orders with back dated – whether the system would permit – what is the methodology?
   11)   How is a ‘Specific Transaction’ is entered in AR for which the Auto-Accounting / i.e. overriding an Auto Accounting rule set?
   12)  In case we need to restrict the List of segment Values of Chart of Accounts to the users – methodology – Security Rules / Cross Validations?
   13)  What is the functionality of the Dependent Value Set?
   14)  How purchase ordered entered in Oracle11i AP module.
   15)  Why not a Dependent Value Set should is used?
   16)  What are the different scenarios of Revenue Recognition in AR and the Accounting Entries, Is it possible to define a Event Based Revenue Recognition instead of ‘Period Based’ Revenue Recognition?
   17)  Once we receive the material what is the entry in Oracle Apps AP?
   18)  How are the Cross Currency Payments made in AP?
   19)  How the historical data is loaded in all the sub ledgers & as well as GL – do we need to have a separate conversion control account for each of the historical transactions in all the sub ledgers?
   20)  How are the open GL Balances loaded & reconciled?
   21)  Why a ‘Transaction Type’ does post to GL ‘NO’ is used?
   22)  How are the Receipt Classes works in AR?
   23)  Can we associate Multiple Receipt Classes to a single Payment Method?
   24)  How is the Automatic Payment Program function in AR?
   25)  Explain the Auto-accounting feature in AR How it works?
   26)  What are the standard programs for Oracle GL, AP modules open interfaces?
   27)  Explain the MRC Functionality?
   28)  If MRC is in places and the dual currency reporting is not required – how is it done?
   29)  How do we import Bank Statement in Cash Management?
   30)  How is the Asset Created through Accounts Payable Module?
   31)  How FA Account Generator Works?
   32)  There is one Account which needs to be defined completely with all the segments in place which that Account – FA?
   33)  How is the Asset Defined in FA?
 
OM / PO / INV
   34)  Which attributes need to be checked in order to get the item in PO form?
   35)  Where do we setup Receiving A/c (Inventory/Purchasing)?
   36)  Explain Matching Concept – PO?
   37)  How to get ‘Direct Receipts’ with 4 Way Match Option is in places (Inventory/Purchasing)?
   38)  How to receive items with less than PO price?
   39)  Where does PPV & IPV get hit?
   40)  PO Gain or Loss Account rate is used?
   41)  Methods of Approvals in Purchasing?
   42)  Case – ‘User A’ Approval Assignment is assigned to User B – How does it affect the approval process?
   43)  How to retrieve PO which is lost due to the above approval assignments?
   44)  What are the different kinds of Purchase Orders?
   45)  How does Internal Requisition works –setups?
   46)  When you setup Shipping Network – What is direct / In-transit type – impact?
   47)  Does it matter if Item is lot controlled in one and not lot controlled in another?
   48)  How does material Overhead work?
   49)  How does Drop Shipment process work?
   50)  After doing purchase release, what happens if changes are made in order?
   51)  Any Report on discrepancies between SO & PO?
   52)  Distribution methodology of Drop shipment?
   53)  Do PPV & IPV come into play for Drop Shipment?
   54)  Difference between‘Delivery’ & ‘Delivery Line’?
   55)  What does Release to‘Warehouse’ means?
 
GL & SYS ADMIN
   56)  What is Dependent Validation? When do you use it? Is it advisable to use while defining your Account flex field? What could be the situation where you can use it while defining the AFF?
   57)  What are Security and Cross Validation Rules? How do you set them up?
   58)  How do you setup document sequencing?
   59)  How do associate the category and the sequence to the Transaction for which you are defining the same in the first place?
 
AP & PO
   60)  Why is my purchase order closing before a receipt is processed?
   61)  Explain the AP Invoice processing cycle right from Invoice creation to transfer to GL in Release 11i?
   62)  Explain the Payment Batch process in detail?
   63)  On what parameters does the system build up the payment batch?
   64)  If U wants to exclude payments to any particular supplier, how do you do it?
   65)   In case U want to exclude payment to only one Invoice of any supplier, how do you do it?
   66)  What are the entries passed when an AP Invoice is created?
   67)  What entries passed for the purchase of an Inventory Item from PO to Invoice?
   68)  Where do you setup the AP Accrual account?
   69)  In case the PO has 4 way matching and the Item has direct routing attached to it. Then what entries are created when the goods are received and invoiced?
   70)  What is 4 ways matching?
   71)  Can we make payment for a Yen Invoice from a USD Bank? If so how?
   72)  What are EFT Payments, What is the Setup Involved and how the data gets transferred to Bank?
   73)   Is it possible to make a cross currency payment in AP?
   74)  In case a foreign currency Invoice is paid, what are the entries passed?
   75)  From where does the ship to site in the PO flow?
   76)  What is ERS and what are the setups required for ERS?
 
AR & OM
   77)  What are the entries passed when U create an Invoice and receive payment for it in AR?
   78)  Explain all the entries from Receipt in AR to clearing in Cash Mgmt?
   79)  How do you setup automatic receipts in AR?
   80)  What is a Lockbox? How do you set it up in AR?
   81)  What are cross currency payments in AR? How do enable the receipt of the same?
   82)  In case a customer requires the part of the shipment to be shipped to another customer, who should be billed for it?
   83)  What are the setups required in AR for integrating it to OM?
   84)  How do you setup the document sequencing for the transactions flowing in from OM?
 
FA
   85)  Explain the total process for asset creation from AP route?
   86)  What is the flex builder/account generator in FA? And how does it work?
   87)  What should be done to modify the Flex builder?
   88)  Explain the total process for transferring transactions from FA to the GL?
   89)  How do you convert the opening balances for FA?
   90)  How do you bring in the Accumulated Depreciation for expensed assets in FA?
 

Friday, 16 November 2012

Oracle HRMS: Setups Relating to Core HR


Setups Relating to Core HR

The following are the setups relating to Core HR.
Creating Location:
We can create locations using the Work Structures => Location window.
Create Business Group
  • We can use either the start up BG or we can create a new BG.
  • The start up BG has a default legislation code of US and has a default currency of USD.
  • For a BG, we need to define the Org Classifications as:
    • Business Group
    • HR Organization
    • GRE/ Legal Entity
 Click on others for business group and give the details relating to BG.
 
 You must set up the following profile options
  • HR: User Type
  • HR: Security Profile and the
  • HR: Business Group
  • Help Localization
  • GL Set of Books
Switch to System Administrator Responsibility and set the above said Profile Options.
We can create the legal entities and operating companies you require to represent your enterprise.
 Click on others.
Create Inventory Organisation.
Click on others.
Go to Sys Admin Responsibility and attach operating unit to MO:Operating Unit to all Responsibilities of the user.
Create Org Hierarchy.
  • Use the Org => Hierarchy window.
 
 
 View the Hierarchy using the Organization => Diagrammer window.  
Click on Open Editor. 
 
Job Group 
The Job Group is used to store jobs of a similar type together in one group.
The default Job Group is automatically created for your business group.
Define Jobs:
 
 Define Positions:
Use the Position window to define positions. Assign the jobs to the positions.
Define Position Heirarchy
 View the Position Hierarchy Diagrammer.
 

Define Grades:
Creating an Employee.
Navigate to People ==>Enter and Maintain Window.
Click on Assignments.
Assign Job and Position of the Employee in this window.