Oracle财务报表合并及预算管理解决方案
- 格式:pdf
- 大小:3.33 MB
- 文档页数:45
ORACLE财务管理系统培训手册—总帐模块(GL)文档作者:创建日期:确认日期:控制编码:当前版本:文档控制文档控制........................................................................ 错误!未定义书签UNIT1 总帐模块概述 .......................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 总帐模块介绍................................................................. 错误!未定义书签LESSON 2 总帐模块和其他模块的关系..................................................... 错误!未定义书签LESSON 3 总帐模块的一个会计业务周期................................................... 错误!未定义书签UNIT2 基本概念 ..................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 弹性域(Flexfield)和值集(Value Set)....................................... 错误!未定义书签LESSON 2 科目结构和帐簿............................................................... 错误!未定义书签LESSON 3 菜单、职责和预制文件......................................................... 错误!未定义书签LESSON 4 关于工具栏、功能键和文件夹的使用............................................. 错误!未定义书签UNIT3 总帐业务处理流程 ...................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 业务背景和数据录入操作步骤................................................... 错误!未定义书签LESSON 2 余额查询和报表提交........................................................... 错误!未定义书签UNIT4 凭证录入管理 .......................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 凭证来源和分类,总帐会计期间................................................. 错误!未定义书签LESSON 2 凭证修改和调整............................................................... 错误!未定义书签LESSON 3 反冲凭证..................................................................... 错误!未定义书签LESSON 4 利用经常性和成批分配凭证的产生凭证........................................... 错误!未定义书签LESSON 5 通过总帐接口引入外部或子模块凭证............................................. 错误!未定义书签UNIT5 凭证复核和登帐 ......................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 总帐模块中两种凭证复核方式................................................... 错误!未定义书签LESSON 2 凭证登帐..................................................................... 错误!未定义书签UNIT6 帐户余额查询和维护 .................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 公司间和悬帐帐户的概念和使用................................................. 错误!未定义书签LESSON 2 汇总模板..................................................................... 错误!未定义书签LESSON 3 帐户余额查询和追索........................................................... 错误!未定义书签LESSON 4 帐户成批维护................................................................. 错误!未定义书签UNIT7 多公司的帐务核算 ...................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 公司间交易(CENTRA)......................................................... 错误!未定义书签LESSON 2 数据映射和帐簿合并........................................................... 错误!未定义书签LESSON 3 系统设置考虑................................................................. 错误!未定义书签UNIT8 总帐报表 ..................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 Oracle FSG ................................................................... 错误!未定义书签LESSON 2 目录集和行顺序............................................................... 错误!未定义书签LESSON 3 报表输出..................................................................... 错误!未定义书签UNIT9 总帐预算管理 .......................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 Oracle 预算和预算控制........................................................ 错误!未定义书签LESSON 2 定义、输入预算和使用预算..................................................... 错误!未定义书签UNIT10 总帐中的外币业务 ..................................................... 错误!未定义书签单元培训目标........................................................................ 错误!未定义书签LESSON 1 Oracle 总帐外币业务.......................................................... 错误!未定义书签LESSON 2 定义汇率,余额重估........................................................... 错误!未定义书签LESSON 3 币种转换和外币报表........................................................... 错误!未定义书签总结 ........................................................... 错误!未定义书签UNIT1 总帐模块概述单元培训目标了解Oracle总帐模块的主要功能和特征了解Oracle总帐模块和其他模块的关系了解Oracle总帐模块的一个会计业务周期LESSON 1 总帐模块介绍Oracle总帐模块(Oracle General Ledger)是整个Oracle应用系统的核心模块,是系统内所有财务往来的汇集地,其他子模块内的财务和现金活动都将最终反映到总帐模块中。
Oracle财务会计系统解决方案介绍目录一、内容概览 (2)1.1 财务会计系统的重要性 (3)1.2 Oracle财务会计系统的优势 (4)二、Oracle财务会计系统概述 (5)2.1 系统简介 (7)2.2 主要功能模块 (8)2.3 系统架构 (9)三、Oracle财务会计系统解决方案 (12)3.1 账户管理 (12)3.1.1 用户账户创建与管理 (14)3.1.2 权限分配与控制 (15)3.2 会计科目体系 (16)3.2.1 科目创建与维护 (17)3.2.2 科目余额管理 (19)3.3 报表编制与分析 (20)3.3.1 自动报表生成 (21)3.3.2 定制报表需求 (22)3.3.3 数据分析与可视化 (23)四、实施与部署 (25)4.1 实施步骤 (26)4.1.1 项目启动与规划 (27)4.1.2 系统配置与测试 (28)4.1.3 员工培训与上线 (30)4.2 部署环境 (30)4.2.1 硬件环境要求 (33)4.2.2 软件环境配置 (34)五、案例分享 (35)5.1 案例背景 (37)5.2 解决方案应用 (38)5.3 成效评估 (39)六、客户支持与服务 (40)6.1 技术支持 (41)6.2 培训服务 (43)6.3 售后服务 (44)七、总结与展望 (45)7.1 项目总结 (46)7.2 未来发展趋势 (47)一、内容概览本文档将全面介绍Oracle财务会计系统解决方案的应用范围、主要特点以及对于企业财务会计管理带来的改变。
Oracle财务会计解决方案是基于其强大的Oracle数据库平台开发的一套全面的管理信息系统,旨在帮助企业简化财务流程、提高会计信息的准确性和处理速度、增强财务流程的可见性,以及支持组织在快速变化的会计和税务法规环境下的合规性。
本章节首先将概述Oracle财务会计系统的核心组成部分,包括其财务会计模块、财务分析模块以及与供应链、人力资源等其他业务模块的集成能力。
Oracle ERP财务会计管理系统实施方案目录1. 总论............................................................................................................ - 2 -1.1概述 . (2)1.2建设背景 (2)2. 项目方案深化设计.................................................................................... - 3 -2.1建设目标 .. (3)2.2指导思想 (3)2.3建设原则 (5)2.4总体框架设计 (7)4. 系统实施................................................................................................... - 14 -4.2财务会计 (14)5. 分工界面及接口....................................................................................... - 69 -5.1ERP系统接口 (69)5.2SEM系统接口 (71)5.3MDM系统接口 (72)6. 系统集成技术方案................................................................................... - 73 -6.1集成总体方案.. (73)6.2应用集成解决方案 (74)6.3接口集成概述 (76)6.4ERP与其他系统集成内容概述 (78)1. 总论1.1概述项目拟建设一座综合原料场、4座焦炉、一条150万吨/年球团生产线、2台500m2烧结机、5100m3炼铁高炉2座、4×210t吨转炉炼钢车间1座、2050mm热轧带钢生产线1条、2030mm冷轧带钢生产线1条及带钢后处理设施、3500mm炉卷厚板生产线1条、搬迁4300mm 厚板生产线1条,以及配套的码头和铁路运输设施、原料制备设施、电站和炉渣综合利用设施及其它公用辅助设施等。
财会研究ORACLE软件在财务管理中存在的问题及对策内蒙古名都房地产开发有限责任公司 段红梅ORACLE系统是美国ORACLE公司提供的以分布式数据库为核心的一组软件产品,是目前最流行的客户/服务器体系结构的数据库之一。
ORACLE数据库是目前世界上使用最为广泛的数据库管理系统,作为一个通用的数据库系统,它具有完整的数据管理功能,其特点主要有:数据的大量性、数据的保存的持久性、数据的共享性、数据的可靠性。
从2003年以来,ORACEL财务管理系统在实际中的运行,被证明能有效地解决传统应收账款等财务管理问题。
一、引入ORACLE财务管理系统的优势应收账款主要指企业因销售商品、材料、提供劳务等,应向购货单位收取的款项,以及代垫运杂费和承兑到期而未能收到款的商业承兑汇票。
应收账款是伴随企业的销售行为发生而形成的一项债权,是财务管理的重要内容,也是影响企业经营活动的重要问题。
对企业的资信状况、业务开展的规模与效益甚至于企业的生存有重要的影响。
ORACEL在企业应收账款管理上的优势随着会计电算化的普遍推行,企业的应收账款核算准确性得到很大的提升,并简化了计算工作。
传统的会计软件只是实现了从手工记账向电脑记账的转变,但是没有从根本上解决业务和财务脱节的问题。
企业引入 ORACLE 财务管理系统,则会在管理理念和应用技术方面产生跨越式的发展。
它的财务管理系统不仅有效整合了企业的信息资源,而且实现业务数据和财务数据的无缝链接,这是与传统会计应用软件相比最大的优势。
利用 ORACLE 的财务管理系统,企业可以在应收账款的管理模式、过程控制和提升管理效果方面有实质性的转变,可以说ORACLE 财务管理系统给企业财务管理带来革命性的变化。
二、ORACLE在应收账款管理中存在的弊端尽管ORACLE 系统有诸多优势,但是任何财务管理系统软件都不是完美的。
企业使用 ORACLE 系统的弊端主要体现在账龄计算、系统的安全性、软件的通用性、操作难度等方面。
海波龙合并报表Oracle的海波龙系统9-财务报表解决方案,一个完全基于Web 技术的财务合并和报表应用解决方案。
它完全面对财务人员,可以由财务人员维护,同时它提供了财务管理的多方面功能,如:快速关账、快速合并计算、财务报表的展现等,以配合企业全球化发展的进程,降低合规性成本,增强财务人员对数字的信心。
关键特点z 全球化合并报表特点z 可升级的web架构z 灵活的维度设计z 完整的审计追踪线索z 强大的报表分析工具z 快速的数据整合满足今天严格的报表规则要求许多财务主管都面临着使用电子数据表(Excel )来合并公司报表这一令人恐惧的任务,并且后期维护及审计工作都十分困难。
一些财务主管被个性化的报表解决方案所困惑,这些报表不能够匹配及适应全球化的需求,其中一些数据依赖于财务的总账系统,需要相关IT 人员从众多的交易系统中抽取数据。
财务人员需要的应该是一个单一版本的真实数据,把来自于多个系统的数据整合在一起,形成真实的、及时的反映企业经营状况的唯一视图。
关键收益z 减少合并、关账和分析报告的周期至几周甚至几天,对内、对外实时发布结果。
z 降低合规性成本,通过Web发布单一版本的真实数据,提高企业内外部透明度。
通过使用海波龙合并报表,这样一个Oracle 绩效管理解决方案,你能够缩短关账时间,改进报表处理过程,减少内控风险。
财务经理可以从记录员角色转变成一个企业合伙人角色,发布财务分析报告,支持战略及运营管理决策。
海波龙合并报表是专门针对财务应用开发的产品,它可以有力支持企业灵活的架构变化,帮助公司满足各种严厉法规的报表规则要求,提高财务人员合并工作效率。
z 管理总账审计追踪,内部审核确认,增强对数字的自信心。
z 轻松实现对关键绩效和运营情况的深度分析。
z 通过分子公司、产品、品牌和客户细分等发现新的利润来源。
不像其他的解决方案依赖于特殊的交易系统,或者定位在许多不同业务过程的毫无用处的“一揽子”应用,海波龙合并报表提供了企业级财务管理的功能,专门针对合并及报表分析。
报表合并创建日期: 2007.9.20确认日期:控制编码:当前版本: 1.0报表合并的准备工作:原有账套:pc book新建账套为PC BOOK (USD) ,注意区别,本位币不同,科目结构和会计日历不变设置新的职责:General Ledger, Jiejun-001把新职责General Ledger, Jiejun-001赋予用户:jiejun(USD)为新的职责General Ledger, Jiejun-001的账套打开新的会计期报表合并概念:如果要合并多个具有不同本位币、会计日历或科目表的帐套,必须首先将子帐套的科目表映射至父帐套的科目表。
合并映射是一套用于将帐户或全部帐户段从子帐套映射至父帐套的指令。
在随后将金额从子帐套转移至父帐套时,总帐管理系统将根据子帐套的映射信息在父帐套中创建未过帐的合并日记帐批。
注:可以为每个子帐套定义一个合并映射。
如果需要更改子帐套合并至父帐套的方式,请在传送数据之前更改子帐套合并映射。
可以将多个合并映射分组为一个合并映射集。
这样可以将映射集而不是每个单独的子帐套数据传送至父帐套定义和并映射:典型的合并流程包括八个步骤1. 定义合并科目表:严密编制父科目表和子科目表将有助于简化合并流程。
2. 映射合并数据:实际合并流程的第一步为定义如何将子帐户映射至父帐户。
映射将确定如何将子帐套余额累计到合并分类帐。
3. 准备合并数据:在将子帐套余额传送至父帐套余额之前准备子帐套余额。
数据准备工作包括余额重估和外币额折算。
4. 传送合并数据:一旦准备好子帐套数据,可以将它传送至父帐套数据以进行合并。
5. 过帐合并数据:在收集所有子帐套合并数据之后,可以在传送子帐套数据时通过过帐父帐套中创建的合并日记帐,将子帐套数据与父帐套数据进行组合。
6. 创建抵销分录:一旦父帐套数据和子帐套数据组合,可以输入抵销日记帐分录。
7. 报告合并余额:在合并余额后准备报告。
8. 分析合并数据:直接将合并数据链接至多维联机分析处理(OLAP) 工具。
Data SheetFinancial Consolidation and Close in Oracle Cloud EPM For many organizations managing the financial consolidation and close process is a burden that takes time and resources that could better be used for analysis and decision-making. Financial Consolidation and Close is a purpose-built business process available in the Oracle Fusion Cloud EPM for both effectively and efficiently managing the consolidation and close, end to end. No matter what the size of company, organizations can have 100% confidence in their financial consolidation, close and reporting processes. Financial Consolidation and Close helps ensure that processes are: dependable and correct, timely and transparent, streamlined and efficient and, compliant and auditable. Consolidate based on your requirementsFinancial Consolidation and Close can be configured to fit individual organizations’ requirements. Using best practices, coupled with pre-seeded content the system allows organizations to build an application that meets their business needs without having extraneous functionality that are not required. It enables organizations to combine a world class consolidation solution with the ability to tailor the solution for the features they require.Configurable dashboards make it easy to quickly visualize data in real-timeOther consolidation solutions are often either overly complex and require features and functionality that are not needed or are too basic and require customization and building of unused features. Financial Consolidation and Close allows configuration of the features and functionality required without having to work around features not required. The out-of-box content is not just an unsupported ‘starter template’ from an ‘app store’. Instead, it’s a framework that can be tailored quickly to specific needs, yet still remains upgradable to new releases by Oracle. The framework has financial intelligence built right in. By leveraging the new framework, customers get the Key business benefitsBest practices out-of- the-box to get up and runningquicklyA configurable andupgradable consolidationand close framework totailor the solutionto specific requirementsEasy to useEasy to maintainAn end to end consolidation and close solutionPowerful analytics,dashboards, reports, andanalysis for unparalleledinsightNo infrastructureinvestments requiredbenefit of an ever-growing library of prebuilt dimensions, calculations, reports, dashboards and KPIs, that are designed to fit their consolidation and reporting processes. This maximizes the value of their investment because Oracle continues to provide value throughout the life of the solution.Be up and running in no timeThe best practice consolidation processes are designed to be up and running with minimal effort, and are easy to maintain as consolidation, close and reporting needs evolve. Organizations simply augment the predefined content with their customer specific content. The predefined content is built using best practices and is designed to work with specific consolidation requirements regardless of the size and complexity of the business.The configurable framework provides immediate value by getting organizations up and running quickly with a series of targeted questions. It then allows them to enhance and evolve their consolidation and close processes over time.Intuitive wizard makes it easy to ‘enable’ only the features requiredThe library of pre-built components such as dimensions, dashboards, reports, and KPIs will continue to be augmented. Organizations can use the items required and can add new useful components that come available with new releases.End to end close processFinancial Consolidation and Close is an end-to-end close process that not only provides a world-class consolidation solution, but also provides a solution to manage and monitor the entire close process. The solution includes the following features and functionality:Application Creation Wizard – This streamlines the creation and administration of the system. This enables significant reduction in thetime required to create and configure the application. This wizard isalso used to enable and disable features within the application.Configurable features include Intercompany Eliminations, Multi-Currency Support, Journal Workflow and Multi-GAAP Reporting.Key FeaturesApplication creationwizard– reduces the timeneeded to configureUpgradeable framework – Configure and extend thesolution as requiredIntercompanyeliminations– Automaticdefault intercompanyeliminations withadditional capabilities tocustomizeCurrency translation–Default and customizablecurrency translations alongwith automatic currencytranslation adjustmentJournals– Robust journals module includingsupported workflow andattachmentsComplex Consolidations – Out of the box, yetconfigurable, complexconsolidation support tore-classify, adjust andeliminate reported dataAutomated cash flowreporting– Usingmovement hierarchies andbolt-in calculations with noneed for additionalcalculationsTask management– Built in task orchestration andTask managementanalysisSupplemental details–Supporting schedules forcollection of detailedinformation helpingsupport balancesHybrid Clouddeployments – Supportwith deep integration tocloud and on-premisessystemsUpgradeable Framework – This enables configuration on top of the upgradable Financial Consolidation and Close framework. Allcustomer configurations built on the framework remain fullyupgradable by Oracle. This means that customer specificconfigurations will continue to work with the pre- built dimensions, reports, calculations data entry screens and future enhancements.Consolidation specific features:Intercompany eliminations – Includes default Intercompany EliminationsJournals with workflow – Includes journal capabilities with configurable workflowCurrency translation – Default, and customizable, currency translation uses PVA method for Flow activities and VAL methodfor Balance activitiesBuilt in foreign exchange/Currency translation adjustment calculations – Automatic calculation of Foreign Exchange onOpening Balance and Movements for each balance sheetaccount along with automated Currency Translation AdjustmentcalculationComplex consolidations – Out of the box, yet configurable, complex consolidation support to re-classify, adjust andeliminate reported data for any hierarchy including org-by-period.Configurable calculations – Support for any type of calculation required for an application including metrics, allocations, andunique reporting requirements.Automated cash flow reporting –The movement dimension provides automated cash flow reporting through hierarchies andsystem calculations that require no further rulesMulti-GAAP reporting – Prebuilt functionality includes reporting for Local GAAP and IFRS with the ability to add additional GAAPsfor reportingDetailed data source tracking – Using a dimension for tracking sources of data including Data Management, Journals,Intercompany Eliminations and manual inputTask management - Built in task orchestration and close management analysisManage the entire close processSupplemental details – Supporting schedules for collection of detailed information helping support statement balances. Useful for disclosures, footnotes, supporting content, and other reporting needsEnterprise Journals – Centrally manage & post journals directly to any general ledger.Reporting – Using Oracle Hyperion Financial Reports, Oracle Smart View for Microsoft Office and in-built dashboards, Financial Consolidation and Close has robust reporting capabilities to meet every requirement Integration and hybrid cloud deploymentWell-designed close and consolidation solutions are not isolated ‘data islands’. Instead, they rely on information from, and pass information to, operational and financial systems from around the enterprise. Some of these systems will reside on-premises while others may be in the cloud. Financial Consolidation and Close is architected to thrive within hybrid deployments.For example, the solution includes a range of data management options that provides organizations with flexibility to choose what is right for them. In some cases basic flat-file imports may be the tool of choice. In other cases, organizations may prefer more highly automated data transformation and load processes from source systems (on-premises or in the cloud). Finally, there are certified adapters and the ability configure rich integration using the secure RESTful API. In all cases, Financial Consolidation and Close has the right tool for the job.Oracle Fusion Cloud EPMOracle Fusion Cloud EPM is the only complete and connected EPM solution delivering the agility you need to outperform in today's constantly evolving business landscape. Related EPM business processesOracle Fusion Cloud EPM provides the following capabilities:Narrative ReportingFinancial Consolidationand CloseAccount ReconciliationPlanningProfitability and CostManagementTax ReportingEnterprise Data ManagementOther related solutionsOracle Fusion Cloud ERPOracle Fusion Cloud SCMOracle Fusion Cloud HCMOracle Fusion Cloud CXConnect with usCall +1.800.ORACLE1 or visit . Outside North America, find your local office at: /contact. /oracle /oracleCopyright © 2021, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.This device has not been authorized as required by the rules of the Federal Communications Commission. This device is not, and may not be, offered for sale or lease, or sold or leased, until authorization is obtained.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0120Disclaimer: If you are unsure whether your data sheet needs a disclaimer, read the revenue recognition policy. If you have further questions about your content and the disclaimer requirements, e-mail ********************.。