Tuesday, June 3, 2014

Brazil P2P - Part 1


Integration: RI to AP; RI to Inventory; RI to GL; RI to AP to FA. Explain with flow-chart and example screen shots.
Periods: Which periods are required to be Open for us to perform transactions in RI? AP/GL/INV? Inventory period is required to be Open even when the RI receipt is done for consumable i.e. non-stock items? This should be explained with the error screen shots and a table should be drawn giving different period status (i.e.– Open/Closed/Future etc.) of different modules.
PO’s: All PO should have match option as ‘PO’.  Implications if the match option is not PO – Invoices stuck in AP Interface? Personalization that we are working on. Any other points unique to Brazil?

Tables: Key tables and their integration with the AP and PO tables (CLL_F189_INVOICES,CLL_F189_INVOICE_LINES and CLL_F189_DISTRIBUTIONS)

Sunday, February 17, 2013

Oracle Asset Conversion Questions (Web ADI)

1) What is the accounting entry when I add an asset using Web ADI with cost as $ 1000 and accumulated depreciation as $600 and YTD depreciation as $ 200? 

2) What is the depreciation amount in the first month i.e. FEB-13 after conversion when below asset is added: 
Cost:  $1000
Date Placed in Service: 01-FEB-12
Prorate Date: 01-FEB-12
Accumulated Depreciation: $600
YTD Depreciation: $ 100
Depreciation Calendar: Calendar i.e. JAN to DEC
Current Month in FA Books: FEB-13
FEB-13 Depreciation is how much???

If I change the cost of Asset to $1000.01 and change it back to $1000, then what is the FEB-13 depreciation?

Monday, September 6, 2010

Oracle Distribution Functional Interview Questions - 3 years of experience

1. Explain Order to Cash process? And Procure to Pay cycle?

2. What is the use of Differ interface check box in Ship confirm?

3. The item attribute ‘Reservable’ is No - what is the impact?

4. Even though Item attributes are correctly set and item is assigned to OE Item validation organization still the item in not available while creating SO. What is the cause?

5. Can one ‘operating unit’ user see the sales order of other operating? How can we achieve this?

6. Where do you define Set of Books? Where can you assign set of books?

7. What are the attributes we need to define for BOM to raise configuration sales order?

8. Auto pick confirm whether required or not where is that set-up done?

• Other than OM System parameters where else?

9. If any delivery grouping attributes in a sales order lines are different then what is the impact during pick release in shipping transaction form

• What changes you observe?

10. If user wants to ship the lines in single delivery when there are different delivery id created for a Sales order, then what process has to be followed

11. What is the difference between Drop ship and back to back order?

12. How do you define an expense item?

13. What are the dependent activities for receiving expense item? What is the accounting? And how is it generated?

14. Is there a way to update schedule ship date for all lines of SO in one go?

15. What is the functionality of Ship set?

16. What are the ‘status control’ attributes of an Item? Explain one attribute in detail.

17. What are the different inventory controls for an item?

18. What are the pre-requisites for Pick release to be successful?

19. Navigation to change the serial numbers from Shipping Transaction form.

20. What are the Item attributes in the ‘Main’ tab.

21. What is meant by Primary UOM and Secondary UOM? Can we change UOM at SO level? If yes, what are the pre-requisites?

22. Explain PO Approval Hierarchy. If owner wants to self approve then what the set-ups required?

23. Do you have knowledge of Inter-Company Invoicing? If yes, explain the process.

24. How many types of Excise Bond registers are there in your current project?

25. What is the use of LC? How is it useful in export sales?

26. What are the different types of excise exemptions?

27. Once the SO was booked, the line status changed to ‘Closed. What could be the cause?

28. In India Localization how are generating Excise and VAT Invoice number both shippable and non-shippable Sales Orders/Transactions.

29. After Ship confirm, what programs are submitted by system. What accounting entries/transactions are created?

30. How many KFF are there in Order management? What is the use of Sales Order Flex-Field?

31. What is the link between Inventory and Order Management?

32. What are the various statuses of Sales Order Line? What the corresponding statuses in Shipping Transaction form? Do sales order header also have all those statuses?

33. When does Sales order header get closed?

34. Have you handled SR and worked with Oracle for resolution of issues? If yes, how do you assign the priority while raising a SR?

35. What is the issue of VAT calculation mentioned in your resume?

36. Are you involved in Month-end closing? If yes, what are the challenges you faced? What could be reasons for an inventory period not getting closed?

37. Do you have any idea of Cycle Counting and Physical Inventory?

38. What is the WIP process – from SO to Shipment?

39. What are the three C’s in 11i? What are the changes in SOB’s in R12? What is the 4th C in R12?

40. Have you done Inventory organization set-up?

41. Explain the IRISO (Stock-Transfer) set-up?

42. What is receipt routing? How many types of receipt routing are there? What is the accounting in ‘Standard Receipt’ routing?

43. What are the different types of RG Registers?

44. Where the option to determine whether to use – Approval Position Hierarchy/ Employee-Supervisor Hierarchy?

45. What are profile options? Explain at what levels profile options can be set?

46. What do you meant by modifiers? How do you define modifiers?

47. Have you worked on Advanced Pricing?

India Localization Interview Questions - Excise and VAT

1) How many excise registers are there in India localization? What are they?

2) When the shipment of finished goods is done, does it affect PLA register or RG23 Part II register?

3) Excise Invoice number is not generated for a given shipment. Explain any 5 reasons which could lead to this scenario/issue.

5) In RG 23 Part II register, for every receipt there is a debit amount and equal credit amount i.e. the CENVAT credit is getting reversed. Have you faced such a scenario? If yes, what could be the possible reason for this?

6) Is Excise Invoice Generation Setup mandatory in India Localization?

7) What are the difference between 'Excise Flag' and 'CENVAT Flag' while defining Items?

8) What set-up determines whether an organization is Manufacturing or Trading organization?

9) Can we do PO receipt of an item with classification FGIN in Excise Organization? Can we do Misc. Receipt (RG Update)? If no, what is the alternative?

10) Explain three transactions in Oracle which effect RG1 register?

11) Have you faced a scenario where the Excise/VAT invoice is there in Shipment Localized form but not available in Transaction localized in AR? Is it possible to rectify this? Does this kind of issue happen even in case of Billy Only lines (where shipment is not required)? How about RMA transaction?

12) In trading organization, receipts can be matched to shipments. Which form/ report gives details of the receipts matched to shipments? Which India Localization table records this information?

13) From India localization perspective, what needs to be checked before 'Transferring accounting entries' to GL from AR? Is there any tax interface table to be checked?

14) What is meant by RG consolidation? Otherwise referred to as excise settlement?

15) Is it possible to carry-forward negative PLA balances while doing RG Consolidation? If no, is there a work-around? Is is possible to carry-forward positive PLA balances?

16) Can you explain the concept of 'Supplementary Invoices'? What are its uses?

17) Is India Localization VAT settlement process used in your current project? Are there any limitations in the current design? How was the requirement met?

18) What are the two stages where the VAT Credit can be claimed (in PO Receipts process)?

19) Are there any India Localization entries created when 'Ship Confirm' of a SO is done? If yes, there entries are created with the source 'Order Entry' in GL? Or with a different journal source?

Sunday, September 5, 2010

Orace Apps Financials Functional Interview Questions (6 Years Experience)

1) Tell about your Oracle experiences?


2) Elabore for me what are the phases of the Implementation project?

3) For how many implementation were you part of End-To-End Implementation?

4) How would you rate yourself in oracle financial modules on a scale of 5?

5) Can you walk me through the Procure to Pay accounting entries?

6) At the receive system creates accounting entries. Are those entries created in Purchasing or Inventory module. What is the program that you run to transfer accounting entries from purchasing to GL?

7) Have you worked on R12? What are the major changes in R12?

8) How many C's are there while defining COA? What the 4 C's?

9) What are the mandatory segments while defining Chart of Accounts?

10) Explain Secondary Tracking Segments.

11) What is the additional qualifier in R12 while defing COA?

12) What the steps involved in consolidation?

13) What is the difference between Revaluation and Translation?

14) Can you translate the balances of SOB in GBP currencies into multiple currencies or only in one different currency?

15) I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done?

15a) When we run the translation we can give only one rate type, then how can we run it for two different exchange rates?

16) What is the difference between realized gain/loss and unrealized gain /loss?

17) I have requirement where the Invoice given by supplier is in USD, but the payment can be done in GBP. Is it possible in AP?

17a) If there is any work-around, explain me the work around.

18) In IExpenses, there are two kind of approval/types approvals, what are they?

19) There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

20) Have you used AME for IExpense? What is AME?

21) What is the significance of Iprocurement? Why is it important?

22) Can I Depreciate CIP ? Can I Retire CIP Asset? Can I Revalue CIP Asset?

23) What is Auto-Accounting in AR?

24) If the client is totally dependent on manual on Manual transactions then Is the auto-accounting rules Mandatory?

25) What is the significance of Line Ordering and Line Grouping? Explain.

26) In cash management, when I do reconciliation, the accounting entries are generated. Where are these accounting entries created?

27) Can you walk me through Order to Cash Cycle.

28) Explain the various entries in O2C

29) What is the value/Amount Oracle takes for COGS Account (while shipment is done)? What is the value the Oracle taken when the revenue account is created during AR Invoice creation?

30) What is the difference between Unidentified and Unapplied Receipts?

31) In Purchasing and Inventory there are two type of Items - Inventory and Expense Item. Expense item can further divided into two - what are they?

32) For expense items I want the accounting to flow in the same way as Inventory item. What set-up needs to be done to achieve this?

33) What are the pre-requisites for an AP Invoice line to move to FA module?

34) Why do you define the pro-rate calendar in FA?

35) Out of your experience, how many years of your experience in client facing i.e. not offshore?

Saturday, September 4, 2010

Oracle Applications Financial Interview of a candidate with 6 years of experience

1) Explain Multi-Org structure.


2) What is Dynamic insert option in Chart of Accounts?

3) How can the new account combinations be defined when dynamic insert option is not enabled?

4) What the mandatory segments in a Chart of Accounts?

5) What is the way in which a Trial Balance of a company be loaded into Oracle; assuming that there are no sub-ledger transactions to be loaded?

6) Have you worked on Conversions? Which conversions have you worked on?

7) A company has acquired another company which has been in operations for last 10 years. How will you load the assets of that company? Assuming the life of an asset to be loaded in 20 years, Will the system calculate the depreciation since the start or only for the remaining life of asset?

8) What is the difference between Amortize and Expense depreciation?

9) What is deferred depreciation in FA?

10) What is the accounting entry when an asset is retired?

11) What are the mandatory columns while developing AP Interface?

12) Explain automatic offset in AP.

13) What is Autoaccounting in AR?

14) If the COA of the parent and child are difference then how will the consolidation be done?

15) Explain the various steps in the Consolidation process

16) What are the two major differences between Revaluation and consolidation?

Thursday, November 26, 2009

Oracle Apps Finance Functional Interview Questions

Below were the questions asked recently in an Interview for Finance Functional of 5+ years experience

General
- Tell about yourself and your experience
- How many implementations & Support projects?

Accounts Receivable
- Explain Quote to Cash Process with Accounting Entries
- What are the parameters of the Auto-Invoice Program?
- How is the GL Date derived by AutoInvoice process? Any set-ups?
- What is the use of the Default GL Date given in parameters of the Autoinvoice import program?
- Can it be set that the GL date is the Sale Order date or Ship to Date?
- Can multiple Sales Orders be invoiced under one Invoice?
- Can Adjustments be imported?
- Can Credit memo be imported and applied to the transactions via Autoinvoice?
- Grouping Rules and Line Ordering Rules
- Allow Overapplication option
- Invoice in Arrears
- Is it possible to import invoices of a specific Sales Order?
- Can closed AR Invoices be imported using AutoInvoice?

Payables
- Can Supplier numbering be set to automatic?
- P2P process along with accounting entries
- Allow Final Match option & Match PO Distribution level
- Substitute receipts and Unordered Receipts
- What is the difference between Recurring Journals and Recurring Invoices? What is the need for the Recurring Journals in GL when Recurring invoices exist in AP?
- How is a foreign currency invoice entered in AP?
- When does the Invoice price variance arise? What is the accounting entry?
- What is the concept of ERS?

General Ledger
- Set-ups required from GIS / Inter-company & the process
- Consolidation; What kind of consolidation have you worked on?
- Is there a need to have separate responsibility for MRC?
- Separate set of books required for translation?
- Can journals imported from sub-ledger, if unposted, be modified?
- What is the significance of 'Import journal references' option at journal source?
- What are the options available to import Exchange rates into Oracle Application?
- What kind of budgets have you worked on?
- How can FSG be generated to provide dynamic report i.e. current month, previous month and 2 months before balances for a given period?