烟草行业ORACLE多组织讲义(英文版)课件

书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难05 七月 2024烟草行业烟草行业ORACLE多组多组织讲义织讲义(英文版英文版)PresenterPresenter Title1Presenter Title2Oracle CorporationORACLE 多组织多组织多组织在ORACLE 11i 中的应用书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难目录目录什么是多组织?主要特点多组织的优点多组织的定义公司间的会计定义组织结构另外的需求问题&方案书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难什么是多组织什么是多组织?The Oracle Applications organization model(Multi-Org),defines the organizational structure and organizational relationships 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?An Oracle Applications server-side configuration 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 within the logical confines of individual operating units.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Major FeaturesMany 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 Organizations.Automatic Accounting for Internal Requisitions.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Advantages of Multi-OrgMultiple financials sets of books in single installationSecure access to globally combined data by operating unitGlobal customer and supplier registriesAutomatic intercompany accountingReduced maintenance of applications softwareReporting across Operating Units书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难 Multi-Org Multi-Org DefinitionsDefinitions书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难ResponsibilityA level of authority in an Application.Determines data,forms,menus,reports,and concurrent programs users may access in Oracle Applications.Several users may share a responsibility and a single user may have multiple responsibilities.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难OrganizationA business unit such as a plant,warehouse,division,department,company.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Profile OptionsAlso called System ProfilesChangeable options that control the way applications run.Assign organizations and security profiles to responsibility.Can be set at multiple levels-Site,Application,Responsibility,User书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难The Multi-Org Model INV:Vision Corp INV:Vision Corp(Inventory Org.)(Inventory Org.)Vision Corporation Vision Corporation(GL Set of Books)(GL Set of Books)LE:Vision Corp LE:Vision Corp(Legal Entity)(Legal Entity)Vision Vision CorporationCorporation (Business Group)(Business Group)OU:Vision Corp OU:Vision Corp(Operating Unit)(Operating Unit)BalancinBalancing Entity 1g Entity 1 BalancinBalancing Entity 2g Entity 2The Multi-Org Model provides a hierarchy that dictates how transactions flow through different business units and how those business units interact.You define the organizations and the relationships between them.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Human Resources Organization Model GRE/HR GRE/HR ORGORG 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 业务组业务组业务组业务组 人事组人事组人事组人事组织织织织 GRE/HR GRE/HR ORGORG 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织 人事组人事组人事组人事组织织织织书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Accounting/Distribution/Materials Management Organization Model 法律实体法律实体法律实体法律实体 经营单位经营单位经营单位经营单位 库存组织库存组织库存组织库存组织 帐套帐套帐套帐套 经营单位经营单位经营单位经营单位 经营单位经营单位经营单位经营单位 经营单位经营单位经营单位经营单位 库存组织库存组织库存组织库存组织 库存组织库存组织库存组织库存组织 库存组织库存组织库存组织库存组织 库存组织库存组织库存组织库存组织 库存组织库存组织库存组织库存组织 法律实体法律实体法律实体法律实体书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Business GroupAn 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 groupPartitions HR information and PO Approval HierarchyAttached to Responsibilities via Profile OptionMust have at least one business group书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难HR OrganizationAn 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 Manufacturing applications.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Set of BooksA 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 to Responsibility via Profile OptionMay have one or more within a single business group.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Legal EntityRepresents 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 is attached to a single GL Set of BooksNo data is stored at the LE levelCurrently limited functionalityFuture enhancements to include greater functionality书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Operating UnitAn organization that partitions data for Oracle subledger applications(AP,AR,PO,OM)Attached to a single legal 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 Option书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Balancing EntityAn organization for which you prepare a balance sheet,represented as a balancing segment 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 OrganizationAn organization that tracks inventory transactions 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 Inventory OrganizationTop-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 OPM,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 组织关系组织关系Posts to a Single Set of BooksPart of a Legal EntityPart of an Operating Unit会计日历、币种、会计弹性域Highest Level Org Controls HR Functionsand Access to employees 法律实体法律实体法律实体法律实体 经营单位经营单位经营单位经营单位 库存组织库存组织库存组织库存组织 帐套帐套帐套帐套 业务组业务组业务组业务组书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难ERP 组织结构范例组织结构范例 UK UK Division Division(LE)(LE)UK Sales UK Sales Office(OU)Office(OU)UK Plant UK Plant(INO)(INO)UK UK Operations Operations SOBSOB Pittsburgh Pittsburgh Plant(INV Plant(INV Master Org)Master Org)US US Operations Operations SOBSOB Eastern Eastern Division Division(LE)(LE)Northeast Northeast Region(OU)Region(OU)Western Western Operations Operations(LE,OU,INO)(LE,OU,INO)Southeast Southeast Region(OU)Region(OU)Orlando Orlando Plant(INO)Plant(INO)Atlanta Atlanta Plant(INO)Plant(INO)书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难公司间会计业务公司间会计业务书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Intercompany TransactionsSell and Ship Products from different Sets of Books UK Sales OfficeUK Sales Office Customer Customer InvoiceInvoice US Sales OfficeUS Sales Office CustomerCustomer Sales Sales OrderOrder Product Product ShipmentShipment PaymentPayment Interco Interco InvoiceInvoice书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Sell from One Legal Entity,Ship from AnotherSegregation of Trade COGS,Intercompany COGS and Sales RevenueEstablish Transfer pricing through ordinary price lists in Order Management.Create Automatic Intercompany AP and AR InvoicesAssign to a sales order a warehouse under a different Operating Unit posting to a different Set of Books.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Purchase and Receive Products Between OrganizationsPurchase 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 SuppliersSite 1:Redwood City,CASite 2:San Francisco,CASite 3:Phoenix,AXSite 1:Atlanta,GASite 2:Iselin,NJ US West US West Operations Operations(Operating Unit)(Operating Unit)US East US East Distribution Distribution(Operating Unit)(Operating Unit)Supplier ABC Corp书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Global Customers and SuppliersCustomer and Supplier Header records are Global.Customer and Supplier Addresses(Sites)are Operating Unit Specific.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Determining Your Organization Structure书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Determining your Multi-Org StructureBusiness GroupsSets of BooksBalancing EntitiesLegal Entities Operating UnitsInventory Organizations书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Business Unit ConsiderationsBusiness Group determines list of employees available.Must have at least One Business GroupOracle Applications comes seeded with a Business Group called Setup Business Group which can be modified to match your organization requirements.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Business Unit ConsiderationsAs 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 partitioning of employee/HR information such as for operations in different countries.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Set of Books ConsiderationsOrganizations 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 different,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 ConsiderationsLocal accounting and auditing standards or security requirements may necessitate additional 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 requirements书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Balancing EntitiesA Balancing segment valueRequired for all organizations for which a Balance Sheet is required书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Legal Entity ConsiderationsCurrently limited functionalityGreatest risk in design of architecture as the future features for legal entities are not known.EEC uses legal entityIntrastat ReportingTypically the same level as Balancing Entity书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Operating Unit ConsiderationsEvaluate the sales order entry,shipping,purchasing,accounts payable,and accounts receivable departmental requirements.Separate autonomous operations require separate Operating Units.Identify centralized and decentralized Processes.You cannot mix centralized and decentralized processes within Operating Units.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Inventory Organization ConsiderationsHow many Inventory Locations?Will you require multiple Item Master Organizations?How many child inventory organizations will be required?Will you Inventory Organization be completely functional or will it just contain inventory Master information.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Additional Considerations书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难Security ProfileSupports service bureau requirements in CRM.Uses HR organization hierarchies to restrict users to access one or more organizations.Assign security profiles with different security rules to responsibilities.书山有路勤为径，书山有路勤为径，学海无涯苦作舟学海无涯苦作舟书到用时方恨少，书到用时方恨少，事非经过不知难事非经过不知难How Security Profile Controls Access Security Security Profile 2Profile 2 Security Security Profile 1Profile 1 Operating Operating Unit BUnit B Operating Operating Unit CUnit C Operating Operating Unit AUnit A ResponsibilityResponsibility ResponsibilityResponsibility UserUser UserUserAQ&Q U E S T I O N SA N S W E R S