Sunday 26 August 2012

P2P Full Cycle Implementation Setup Process

    I.            Login with OPERATIONS user
1.       select system administrator resp
2.       Creating user
3.       Attach system administrator responsibility for that user.
4.       Logout from operations account

 II.            Login with our own user( what we are created)
1.       Select system administrator resp
2.       Create the responsibilities for AP,AR,PO,GL,INV,HRMS,OM,TAX,PAYMENTS,CM,FA
3.       Attach the above responsibilities to the user.
4.       Assign HR USER profile option(HR:USER TYPE) to HRMS RESP

             III.            Switch to HRMS RESP
1         Define a new LOCATION
2         Create a NEW BUSINESS GROUP

             IV.            SWITCH TO SYSTEM ADMIN RESP
1.       ASSIGN HR:BUSINESS GROUP PROFILE OPTION TO ALL RESP
2.       ASSIGN HR: SECURITY PROFILE PROFILE OPTION TO ALL RESP
3.       ASSIGN MO: SECURITY PROFILE PROFILE OPTION TO ALL RESP
                                                                
                V.            SWITCH TO GL RESP
1.       CREATE A NEW CURENCY OR USE PRE DEFINED
2.       CREATE A CALENDER
3.       CREATE A CHART OF ACCOUNTS
4.       CREATE A LEGAL ENTITY FOR OUR ORGANISATION BY USING ACCOUNTING SETUP MANAGER
5.       CREATE A  PRIMARY LEDGER BY USING 4 C’S (currency,calendar,chart of accounts and sub ledger accounting method)
6.       CREATE A OPERATING UNITS FOR OUR BUSINESS GROUP

             VI.            SWITCH TO SYSTEM ADMIN RESP
1.       ASSIGN GL:LEDGER NAME PROFILE OPTION TO ALL RESP
2.       ASSIGN MO: OPERATING UNIT PROFILE OPTION TO ALL RESP

          VII.            SWITCH TO HRMS RESP
1.       Create a new INVENTORY ORGANISATION

       VIII.            Switch to SYSTEM ADMIN RESP
1.       RUN REPLICATE SEED DATA PROGRAM


             IX.            SWITCH TO INV RESP
1.       CREATE A INVENTORY WORK DAY CALENDER
2.       COMPLETE THE INVENTORY INFORMATION FOR OUR INVENTORY ORGANISATION
3.       CREATE SUB INVENTOTY ORGANISATIONS

                X.            SWITCH TO PO RESP
1.       DEFINE THE FINANCIAL OPTIONS
2.       DEFINE THE PURCHASING OPTIONS
3.       DEFINE THE RECEIVING OPTIONS


             XI.            SWITCH TO HRMS RESP
1.       CREATE A NEW JOB
2.       CREATE A NEW POSITIONS
3.       CREATE A POSITION HIERARCHY
4.       CREATE EMPLOYEES

          XII.            SWITCH TO SYSTEM ADMIN RESP
1.       CREATE USERS FOR EMPLOYEES
2.       ATTACH THE RESP FOR CORRESPONDING USERS

       XIII.            SWITH TO PO RESP
1.       DEFINE APPROVAL GROUP
2.       ASSIGN APPROVAL GROUP TO POSITIONS
3.       UPDATE DOCUMENT TYPES
4.       CREATE A ITEMS
5.       CREATE SUPPLIERS
6.       CONVERT EMPLOYEE AS BUYER
7.       OPEN THE PERIOD
8.       RUN  “FILL EMPLOYEE HIERARCHY “ PROGRAM

       XIV.            SWITCH TO GL RESP
1.       OPEN THE GL PERIODS


          XV.            SWITCH TO INV RESP
1.       OPEN THE PERIODS IN INVENTORY



       XVI.            SWITCH TO AP RESP
1.DEFINE PAYABLE OPTIONS

    XVII.            LOGOUT  FROM OUR OWN USER

 XVIII.            LOGIN WITH SYSADMIN
1.       SELECT USER MANAGEMENT RESP
2.       MAKE OUR LE AS RIGHT TO GET THE GRANT TO ACCESS THE BANK ACCOUNTS
3.       LOGOUT  FROM SYSADMIN

       XIX.            LOGIN WITH OUR OWN USER

          XX.            SWITCH TO AP RESP
1.       CREATE BANK
2.       CREATE BANK BRANCH
3.       CREATE BANK ACCOUNTS
4.       OPEN PAYABLE PERIODS
5.       DEFINE DISTRIBUTION SETS
6.       DEFINE PAYMENT TERMS
7.       DEFINE SCHEDULE TERMS

       XXI.            SWITCH TO TAX RESP
1.       CREATE PARTY TAX PROFILE
2.       CREATE TAX REGIME
3.       CREATE TAX
4.       CREATE TAX RATE
5.       CREATE TAX STATUS
6.       CREATE TAX JURIDICTION
7.       CREATE TAX ACCOUNTS
8.       CREATE TAX RULES
9.       MAKE TAX AVAILABLE FOR TRANSACTIONS




Thursday 23 August 2012

Oracle Receivables interview question and answers


Oracle Receivables interview questions


1. How many Address’s can have one Customer?

Primary Address, Bill – To – Address, Ship – To – Address

2. Customer Number Always Automatic / Manual?
Any thing Either Manual or Automatic

3. What are the Mandatory Address’s you should create a Customer for Communicate him?


Remit – To – Address

4. Can U Merge the Customers? If How?
Using the Merging Customer Window

5. What is Accounting Rules?
It is For Generating Revenue Recognition Programs like Monthly, Quarterly

6. What is Invoicing Rules?
The Invoicing Rules Helps you when you receive data from Outside systems like Auto Invoices how the data should insert and It contains 2 rules Advance Invoice, Arrears Invoice.

7. Where should the customers send the payments of Invoices?
Remittance Banks or Vendor Places

8. What is the Transaction Type?
It describes us Whether you want transfer the Receivables data into General Ledger or not. And also when ever you create an invoice what are the accounts should be effected and also the sign of Transaction also.

9. What is a Transaction Source?
It is For Invoice or Invoice Batch numbers whether automatically or manually

10. How many Transactions we have?
Six, Credit Transactions: Invoice: Debit Memo: Charge back: Guarantee: Deposit

11. How can i reduce the Invoice amount?
Using with Credit Transactions

12. What are the Accounts to be use in Transaction Types (Few)?
Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled

13. How can i Assign a Deposit amount to an Invoice?
In the Invoice Window “Commitment” Region

14. What is the Guarantee?
It is agreement between both sides for goods or services in the future , specific range of periods

15. Give the Navigation for Credit Transactions?
Transactions/Credit Transactions

16. How many ways you can apply the Receipt Amount?
Application: Mass Apply

17. How will you know a Customer Balance Amount?
Using with the Customer Account Overview window

18. Can U Define Customer Agreements using with AR?
No, In the Oracle Order Entry Module

19. What are Aging Buckets?
It is for Outstanding Reports purpose the no of days in various ranges

20. How will U View the Outstanding Balance of a Customer?

Generating the Aging Buckets Report

Fusion General Ledger: Currency creation Setup/ Configuration

Definition: A system of money in general use in a particular country called currency Types of currencies Functional currency/Accounted curre...