ERP-Implementation by Prashant Shrivastava

1) How many key flexfields are there in Oracle Assets module? Answer There are 3 Key Flexfields in Oracle assets and they are Asset Category, Asset Location and Asset Key. 2) What are the methods/ways in which an asset can be added ? Answer There are 4 ways in which asset can be added - Through Payables - From external system through FA_MASS_ADDITIONS - Quick Addition - Detailed Addition 3) What are the various 'Asset Types' ? Answer The various 'Asset Types' are - Capitalized - CIP  - Expense - Group 4) In the multi-org structure, where does Fixed assets module operate? Answer  Instance 5) Can we have multiple period open in Assets module? Answer In Fixed Assets only one period can be open at any given time. Multiple periods cannot be open. 6) Is it possible to set-up Assets module in such a way that accounting entries are not transferred to GL? How? In what scenario's does such requirement arise? 7) While defining 'Depreciation Calendar' what precaution ne...

Here are few of the basic Oracle General Ledger (GL) interview Questions:   Question 1 In the multi-org structure, at what level does GL operate? Answer General Ledger operates at  SOB level.   Question 2 What are the various statuses of GL Periods? And in which table this information is stored?  Answer The statuses of GL periods are below:  • Open  • Closed  • Future - Entry  • Permanently Closed  • Never Opened   The information is maintained in GL_PERIOD_STATUSES.   Question 3 If Journal Approval flag is checked while defining Set of Books (SOB) then all journals will necessarily require approval. Is this statement correct? Answer In addition to enabling Journal Approval flag at SOB level; Require Journal Approval flag at Journal Sources level for journals to require approval. Question 4 Does GL support Accrual or Cash system of accounting?   Answer GL is a central repository and all the journal...

 Questions For Oracle Payables 1. What are the types of Invoices , what is prepayment & steps to apply it to an Invoice ? 2. What are the Distribution Type while entering the Invoice? 3. What's the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program?  4.What is Debit Memo & Credit Memo in Payables? 5. What is Proxima Payment Terms? 6. What will accrue in Payables? 7. What is Tolerance? 8. What is Aging Periods? 9. What is a Payable Document? 10. What are the tables associated with Invoice? 11. Which interface tables are used for Invoice Import , give the important columns? 12. What is 2 way , 3 way and 4 way matching? 13. How you will transfer payables to general ledger? 14. You created a set of book , where you will attach this SOB in AP? 15. What is use of AP Accounting Periods? 16. What is Interest Invoice and how it can be created? 17. What is a Hold? Explain the types of Hold  18. How many key fl...

 1. How many payment methods can be assigned to a customer? a. One b. Two c. Eight d. Unlimited 2. What are the two types of commitments in Oracle Receivables? 3. While entering Invoices manually, Ship to Address of the customer is mandatory. a. True b. False 4. Name the two Invoicing Rules in Oracle Receivables 5. Assuming a payment term ‘IMMEDIATE’ is attached to a Transaction Type, can we raise an Invoice with Payment term ’30 Days’ for the transaction type? a. Yes b. No 6. In which of the following field, Standard Memo Lines appear as List of values a. Invoice Lines Description b. Transaction Type c. Miscellaneous Receipt Description d. Invoice Item Code 7. Auto Cash Rule Sets are defined to  a. Automatically apply receipts to invoices b. Automatically apply commitments to invoices c. Automatically apply credit memos to invoices d. All of the above 8. If a value in a Profile class is changed, the system will a. Automatically change the value for all existing customers with...

 Setting up Treasury in Oracle E-Business Suite (EBS) R12.3 involves configuring the Oracle Treasury module to manage financial instruments, cash management, risk management, and other treasury-related activities. Here's a step-by-step guide to set up Treasury in Oracle EBS R12.3: Step 1: Enable Treasury Responsibility Navigation: System Administrator > Security > Responsibility > Define Enable the Treasury responsibility for users who need access to the Treasury module. Step 2: Define Financial Instruments Navigation: Treasury > Instruments Set up financial instruments, such as money market instruments, bonds, or derivatives. Step 3: Set Up Market Data (Optional) Navigation: Treasury > Market Data Configure market data parameters, including interest rates, exchange rates, and security prices. Step 4: Define Counterparties Navigation: Treasury > Counterparties Set up counterparties, including banks and other financial institutions. Step 5: Configure Cash Managemen...