1. Security in Oracle Apps, Users, Menus, Responsibilities, Profile Options 2. F
ID: 1719031 • Letter: 1
Question
1. Security in Oracle Apps, Users, Menus, Responsibilities, Profile Options
2. Flex Fields – Key and Descriptive – Talk about the different KFFs and how to enable a segment on a DFF
3. Multi Org Concepts and Demo of how to setup a new org
4. What are the new features in GL from a R12 perspective
5. What does a Ledger comprise of? What would you take into consideration when designing a Chart of Account Structure – what questions would you ask the client, how would you decide how many segments,etc.
6. What are the differences between segment qualifiers and value set qualifiers? What are the two new segment qualifiers in the Accounting Flex Field in Release 12. What are the different types of Account Types in Oracle GL?
7. Auto Post and Auto Reversal process in GL
8. What is the difference between a primary ledger, secondary ledger ? Explain the 4C’s .
9. What is the Organization hierarchy and explain the Multi Org Concept and how it has evolved?
10. Revaluation and Translation
11. What are recurring journals and what are the different types of recurring journals. Explain the Journal Import process
12. What are summary templates, parent accounts and roll up groups. What goes into defining an Accounting Calendar?
13. What are the main setup steps for the GL Module? What are the key profile options that need to be defined for a new responsibility?
14. What is a Definition Access Set, Data Access Sets and What is a Ledger Set
15. Explain the different types of Mass Allocations with examples
16. Month end close process in Oracle GL
17. What is Consolidation? Explain the steps to do Consolidation
18. What are Cross Validation Rules and Security Rules ?
19. Explain the Inter-Org Transfer process. Explain the different types and pre-requisites
20. What are the different Key Flexfields in Oracle Inventory and explain the use of each
21. What are the new features of R12 Inventory
22. Explain what are Item Attributes, Item Attribute Controls, Item Status and Status Attributes
23. What are Item Templates used for? How do you use it? Explain Item Cross Referencing and Item Relationships
24. What are the different kinds of Inventory Planning Methods. Explain 2
25. What is Inventory Accuracy? Explain the different ways you can maintain accuracy in your Inventory.
26. What is Unit of Measures? Explain Classes and UOM conversions.
27. Explain the different Transactions in Inventory – Sub Inventory Transfers, Inter Org transfers, Miscellaneous Transactions and Move Orders
28. Explain the different Inventory Controls – Locator, Lot, Serial and Revision
29. Explain Receiving Functionality in Inventory
30. Vendor Managed Inventory and Consigned Inventory
31. Month End Close Process in Inventory
32. Explain the difference between Segment Qualifiers and Valueset Qualifiers
33. What goes into defining an Inventory Calendar. What is the use of creating one.
34. Transaction Types –Explain how do you create it and the importance of it
Explanation / Answer
22) Item attributes are information about an item, such as order cost, lead time, and revision control.
Item attribute control determines whether you have centralised(master level) or decentralized (organization level) control of item attributes. Both status attributes and item status can be controlledat the item level or organization levels.
Item status is defined by selecting the value check boxes for the status attributes. item status codes may be used to set or update the default values for certain item attributes. they can be used to control the functionality of an item. when you update the values for a status, all items that use that status will be updated also.
Status attributes are the item attributes that enablekey functionality for each item.
25)Inventory accuracy refers to all the discrepancies that exist between electronic records that represent the inventory and the physical state of the inventory. On of the most common form of inventory inaccuracy is phantom inventory
Different ways to maintain accuracy in an inventory are:
1)Developing an Inventory Tracking Method
2)Implementing Your Inventory Tracking Method
3)Establishing Inventory Controls
4)Restocking Your Inventory
24) There are six methods for planning inventory values:
• Forward Weeks of Supply
• Weeks of Supply
• Stock to Sales Ratio
• Sell Through Percent
• Turn
• Basic Stock
Weeks of Supply (WOS) is an inventory measure calculated by dividing current inventory by average sales. WOS helps to educate a planner to think of inventory in terms of time.
Stock to Sales Ratio (SSR) is ideal for planning appropriate inventory levels in plans to the month level. Stock to Sales Ratio forecasts how much inventory is required to achieve the projected sales. SSR represents proportion of merchandise on hand at the beginning of a period to the expected sales for that period. SSR is calculated by dividing stock at the beginning of the period by sales for the period.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.