Important questions to be remembered by a Oracle Consultant Part2

Important questions to be remembered by a Oracle Consultant,
What is Multiple Organization technical architecture?
Multi Organization :
Using a single installation of any oracle application product , to support any number of an organization even it has different Set Of Books Business Level(It Secures Human Transaction Information) Set Of Books(It secures all Transaction Information In Oracle (General Ledger) Legal Entry(All legal Information in the Organization) Operating Unit(It Uses Order management, Cash management,AR, may be Sales Office , Division,Department) Inventory Organization(Inventory Details)
before multi-org existed, we could have only one business group,set of books, legal entity, operating unit in one installation of oracle E-business suite, and now with the multi-organization structure in place, we can have multiple business groups, set of books, legal entity and operating unit and the best part is once these are set up inter company accounting is automatically taken care of, say for example i have Two inventory organization, and these use a common set of books(to start with) , now if we have sales order on one inventory organization A1 and if that item is not available in A1, and we have inventory for the item in Inventory org A2, we need to take the order in A1 as internal order and run the order import concurrent program and for the item in inventory A1(org assignment) we need to set up the source(purchase tab) as inventory organization A2,and also specify shipping network between A1 and A2, and once we have run the order import program and Oracle applications now imports the order to organization A2, with the ship to address as A1 location. and after you perform pick release and pick confirm process, and run auto invoice in A2, it automatically sends invoice to inventory organization A1 and now we can receive the item in Inventory organization A1 from organization A2.
and all transactions are taken care of, courtesy multi organization structure.

What are different period types ?
Year Quarter Month Week

What are the different types of files used in SQL  Loader?
Different types of files are Data File,Control File,Discard File,Bad file

What is Oracle Financials?
Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with: 
Oracle Assets: Ensures that an organization's property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.

Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.

Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.

Oracle Order Entry: Provides organizations with a sophisticated order entry system for managing customer commitments.

Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment.

Oracle Personnel: Improves the management of employee- related issues by retaining and making available every form of personnel data.

Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.

Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.

Oracle Revenue Accounting: Gives an organization timely and accurate revenue and flexible commissions reporting.

Oracle Sales Analysis: Allows for better forecasting, planning. and reporting of sales information.

What is the difference between Fields and Flex Fields?
A field is a position on a form that one uses to enter, view, update, or delete information. A field prompt describes each field by telling what kind of information appears in the field, or alternatively, what kind of information should be entered in the field.

A flex field is an Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flex fields to capture information about your organization. There are two types of flex fields: key flex fields and descriptive flex fields.


No comments:

Post a Comment