珠寶行業(yè)多組織在ORACLE中的應(yīng)用講義

1、PresenterPresenterPresenter Title1Presenter Title2Oracle CorporationORACLE ORACLE 多多組織組織多組織在ORACLE 11i 中的應(yīng)用目錄目錄 什么是多組織? 主要特點(diǎn) 多組織的優(yōu)點(diǎn) 多組織的定義 公司間的會(huì)計(jì) 定義組織結(jié)構(gòu) 另外的需求 問(wèn)題 & 方案什么是多組織什么是多組織? ? The Oracle Applications organization model (Multi-Org), defines the organizational structure and organizational re

2、lationships of an enterprise within Oracle Applications. The cornerstone of all Oracle Application products. Dictates how transactions flow through different organizations and how those organizations interact with each other.What is Multi-Org?What is Multi-Org? An Oracle Applications server-side con

3、figuration that enables multiple business units in an enterprise to use a single installation of Oracle Applications products. Consolidate all operations under one installation of Oracle Applications, keeping your data resident on a single database, yet keeping transaction data separate and secure w

4、ithin the logical confines of individual operating units.Major FeaturesMajor Features Many Organizations in One Installation. Multiple Legal Entities in One Installation. Secure Access to Data. Sell and Ship Products from from Different Legal Entities. Purchase and Receive Products between Organizat

5、ions. Automatic Accounting for Internal Requisitions.Advantages of Multi-OrgAdvantages of Multi-Org Multiple financials sets of books in single installation Secure access to globally combined data by operating unit Global customer and supplier registries Automatic intercompany accounting Reduced mai

6、ntenance of applications software Reporting across Operating UnitsMulti-Org DefinitionsMulti-Org DefinitionsResponsibilityResponsibility A level of authority in an Application. Determines data, forms, menus, reports, and concurrent programs users may access in Oracle Applications. Several users may

7、share a responsibility and a single user may have multiple responsibilities.OrganizationOrganization A business unit such as a plant, warehouse, division, department, company.Profile OptionsProfile Options Also called System Profiles Changeable options that control the way applications run. Assign o

8、rganizations and security profiles to responsibility. Can be set at multiple levels - Site, Application, Responsibility, UserThe Multi-Org ModelThe Multi-Org ModelThe Multi-Org Model provides a hierarchy that dictates how transactions flow through different business units and how those business unit

9、s interact.You define the organizations and the relationships between them.Human Resources Organization ModelHuman Resources Organization ModelAccounting/Distribution/Materials Management Organization Accounting/Distribution/Materials Management Organization ModelModelBusiness GroupBusiness Group An

10、 organization that represents the consolidated enterprise, a major division, or an operation company and has no accounting impact. Employee/HR information is secured by business group Partitions HR information and PO Approval Hierarchy Attached to Responsibilities via Profile Option Must have at lea

11、st one business groupHR OrganizationHR Organization An internal organization such as a department, section or project team which facilitates a complex organization structure for HR tracking. Utilized only by Oracle HR/Payroll and Projects applications and have no impact on the Financial or Manufactu

12、ring applications.Set of BooksSet of Books A financial reporting entity that partitions General Ledger information and uses a single chart of accounts, accounting calendar, and functional currency. Secures General Ledger transaction information such as journal entries and account balances. Attached

13、to Responsibility via Profile Option May have one or more within a single business group.Legal EntityLegal Entity Represents a legal company for which you prepare fiscal or tax reports. You assign tax identifiers and other legal entity information to these types of organizations. Each Legal Entity i

14、s attached to a single GL Set of Books No data is stored at the LE level Currently limited functionality Future enhancements to include greater functionalityOperating UnitOperating Unit An organization that partitions data for Oracle subledger applications (AP, AR, PO, OM) Attached to a single legal

15、 entity. Associated with a single GL Set of Books. All subledger application transaction data is secured at the Operating Unit level. Attached to Responsibility via Profile OptionBalancing EntityBalancing Entity An organization for which you prepare a balance sheet, represented as a balancing segmen

16、t value in your accounting flexfield. Each Balancing Entity must balance within itself. May have multiple balancing entities within the same operating unit. Secured by Responsibility via Segment Value security rules.Inventory OrganizationInventory Organization An organization that tracks inventory t

17、ransactions and balances, and/or that manufactures or distributes products. Manufacturing plants, warehouses, distribution centers, and sales offices. Applications that secure data by Inventory Organization include (Inventory, BOM, Engineering, WIP, MRP, Capacity, and purchasing receiving.Master Inv

18、entory OrganizationMaster Inventory Organization Top-level inventory organization that controls the attributes assigned to an item and where items and bills of materials are set up. The Master Inventory Organization dictates the costing settings of an inventory organization (this does not apply to O

19、PM, which has its own costing functionality). Cannot be shared across sets of books but can be shared across operating units within the same set of books.ERP ERP 組織關(guān)系組織關(guān)系Posts to a Single Set of BooksPart of a Legal EntityPart of an Operating Unit會(huì)計(jì)日歷、 幣種、會(huì)計(jì)彈性域Highest Level Org Controls HR Functions

20、and Access to employeesERP ERP 組織結(jié)構(gòu)范例組織結(jié)構(gòu)范例公司間會(huì)計(jì)業(yè)務(wù)公司間會(huì)計(jì)業(yè)務(wù)IntercompanyIntercompany Transactions TransactionsSell and Ship Products from different Sets of BooksSell from One Legal Entity, Ship from AnotherSell from One Legal Entity, Ship from Another Segregation of Trade COGS, Intercompany COGS and Sa

21、les Revenue Establish Transfer pricing through ordinary price lists in Order Management. Create Automatic Intercompany AP and AR Invoices Assign to a sales order a warehouse under a different Operating Unit posting to a different Set of Books.Purchase and Receive Products Between OrganizationsPurcha

22、se and Receive Products Between Organizations Purchase order operating unit and receiving inventory organization must share the same set of books. In a Future Release you will be able to receive to inventory organizations posting to a different set of books.Global Customers and SuppliersGlobal Custo

23、mers and SuppliersSite 1: Redwood City, CASite 2: San Francisco, CASite 3: Phoenix, AXSite 1: Atlanta, GASite 2: Iselin, NJSupplier ABC CorpGlobal Customers and SuppliersGlobal Customers and Suppliers Customer and Supplier Header records are Global. Customer and Supplier Addresses (Sites) are Operat

24、ing Unit Specific.Determining Your Determining Your Organization StructureOrganization StructureDetermining your Multi-Org StructureDetermining your Multi-Org Structure Business Groups Sets of Books Balancing Entities Legal Entities Operating Units Inventory OrganizationsBusiness Unit Considerations

25、Business Unit Considerations Business Group determines list of employees available. Must have at least One Business Group Oracle Applications comes seeded with a Business Group called Setup Business Group which can be modified to match your organization requirements.Business Unit ConsiderationsBusin

26、ess Unit Considerations As the highest level organization in Multi-Org, You must first setup Business Units. You must setup all of your Business Units and appropriate responsibilities prior to setting up other organizations. You need multiple business groups if your business requirements necessitate

27、 partitioning of employee/HR information such as for operations in different countries.Set of Books ConsiderationsSet of Books Considerations Organizations with common functional currency, chart of accounts, and accounting calendar may share the same Set of Books. If any one of the three Cs is diffe

28、rent, you must have a separate set of books. You may have as many GL sets of books as your enterprise requires. Sets of Books are independent of the Business Unit.Set of Books ConsiderationsSet of Books Considerations Local accounting and auditing standards or security requirements may necessitate a

29、dditional sets of books. You may set up multiple sets of books for additional security. You may consolidate any number of sets of books to a consolidation set of books for your global consolidation reporting requirementsBalancing EntitiesBalancing Entities A Balancing segment value Required for all

30、organizations for which a Balance Sheet is requiredLegal Entity ConsiderationsLegal Entity Considerations Currently limited functionality Greatest risk in design of architecture as the future features for legal entities are not known. EEC uses legal entity Intrastat Reporting Typically the same level as Balancing EntityOperating Unit ConsiderationsOperating Unit Considerations Eva