Welcome to PeopleSoft Global Consolidations 9.1 PeopleBook. This PeopleBook describes how to set up and use Oracle's PeopleSoft Global Consolidations.
This chapter discusses:
PeopleSoft Global Consolidations PeopleBook.
Oracle's PeopleSoft Products
Related PeopleBooks.
Deferred processing.
Common elements used in PeopleSoft Global Consolidations.
This PeopleBook discusses how to set up and use Oracle's PeopleSoft Global Consolidations. Documentation is divided into the following chapters:
Preface.
This chapter explains the structure of the Oracle's PeopleSoft Global Consolidations 9.1 PeopleBook. It also provides details of related documentation, additional resources, deferred processing mode, and common elements used in the documentation.
Getting Started with Global Consolidations.
This chapter introduces PeopleSoft Global Consolidations and presents Global Consolidations integrations and the implementation tasks.
Understanding Global Consolidations.
This chapter presents an overview of Global Consolidations components, phases, processes, data flow, and security.
Loading Ledger Data and Establishing Required Record Objects.
This chapter describes considerations for Global Consolidations when loading ledger data into the operational warehouse staging (OWS) and operational warehouse enriched (OWE) tables, and establishing the required record objects.
Defining Your Organizational Structure.
This chapter describes how to set up the basic structure for your consolidated organization including general options, business units, elimination entities, account types, account nodes, ledger templates, ledgers, models, scenarios, and consolidation trees.
Establishing Consolidation Options and Supporting Objects .
This chapter provides an overview of consolidation options and supporting objects and discusses how to define system-wide security and processing options, user preferences, and ChartField value sets, and how to establish book code functionality.
Preparing Data for Consolidations.
This chapter describes how to define rules for ledger verification, calendar mapping, ChartField mapping, currency mapping, and ledger preparation, and how to run ledger preparation and currency adjustment processes.
Defining Required Consolidation Rules.
This chapter provides an overview of required consolidation rules and discusses how to how to establish and validate balancing account type rules, tolerance rules, ownership rules, close process rules, and consolidation models.
Defining Elimination, Non-Controlling Interest , and Equitization Rules.
This chapter provides an overview and describes how to establish elimination, non-controlling interest, and equitization rules.
Managing Journals.
This chapter describes how to establish journal approval processes and how to define, validate, post, unpost, and publish manual, recurring, and reversing journals.
Using Spreadsheet Journal Import
This chapter describes how to import manual journals using a delivered spreadsheet.
Defining and Managing Flows.
This chapter describes how to set up, process, and manage flows to track account activity related to cash flow, fixed assets, and other accounts.
Processing Consolidations.
This chapter describes how validate the consolidation setup, process eliminations, equitization, and closing rules, run the tree flattener, review application engine messages, and lock scenarios from further processing.
Monitoring Consolidations.
This chapter describes how to manage and view the status of consolidation processes for nodes on the consolidation tree during ledger preparation, ledger enrichment, and consolidation.
Analyzing Consolidations.
This chapter describes how to audit consolidation data, review ledger balances, trial balances, proforma trial balances, and ownership hierarchies, how to match intercompany transactions for elimination, and how to run Global Consolidations reports.
Appendix A: Global Consolidations Reports
This appendix lists the delivered reports for PeopleSoft Global Consolidations.
Appendix B: Global Consolidations Source Codes
This appendix lists the source codes for PeopleSoft Global Consolidations data.
This PeopleBook refers to the following PeopleSoft Products:
PeopleSoft Scorecard.
PeopleSoft Project Portfolio Management.
PeopleSoft Planning and Budgeting.
PeopleSoft General Ledger.
The following companion PeopleBooks apply specifically to PeopleSoft Global Consolidations.
PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook.
Provides information needed to complete the core setup for all PeopleSoft Enterprise Performance Management (PeopleSoft EPM) applications. This PeopleBook also discusses the system architecture, the mapping of data into the warehouse, and the EPM foundation tools.
PeopleSoft Common Components 9.1 PeopleBook
Provides information on common components in the PeopleSoft EPM database.
PeopleTools PeopleBook: PeopleSoft Integration Broker
Provides information about setting up Oracle's PeopleSoft Integration Broker to work with journal publishing features in PeopleSoft Global Consolidations.
Several pages in the PeopleSoft Global Consolidations applications operate in deferred processing mode. Most fields on these pages are not updated or validated until you save the page or refresh it by clicking a button, link, or tab. This delayed processing has various implications for the field values on the page. For example, if a field contains a default value, any value that you enter before the system updates the page overrides the default. Another implication is that the system updates quantity balances or totals only when you save or otherwise refresh the page.
This section lists common elements used in PeopleSoft Global Consolidations.
Provides the ID code for a tableset. A tableset is a group of tables (records) necessary to define your company's structure and processing options. |
|
Establishes the date on which the row in the table becomes effective. It determines when you can view and change the information. Pages and batch processes that use the information use the current row. |
|
Indicates whether a row in a table is active or inactive. You cannot select inactive rows on pages or use them for running batch processes. |
|
Allows free-form text of up to 30 characters that describes what you are defining. |
|
Identifies specific run control settings for a process or report. |
|
Identifies the report. |
|
Provides the PeopleSoft Enterprise Performance Management program name for which you are running the report or process. |
|
Specifies the frequency with which you want to run a process. You can select Once, Always, or Don't. |
|
Indicates the date on which the report or process was last run. |
|
Indicates the last date for which the report or process includes data. |
|
Provides an identifier for a specific scenario. |
|
Provides an identifier for a model. A model uniquely identifies the types of data that you want to include in a scenario. For example, you might want to review revenue by region—a broad scope. If you use Oracle's PeopleSoft Activity-Based Management, you might want to review only those activities that relate to a certain product line for certain types of resources—a narrow scope. |
|
Specifies the fiscal year for your scenario or process run. |
|
Specifies the accounting period for the object or process. |
|
Specifies an instance of an engine. |
A companion PeopleBook called PeopleBooks and the PeopleSoft Online Library contains general information, including:
Understanding the PeopleSoft online library and related documentation.
How to send PeopleSoft documentation comments and suggestions to Oracle.
How to access hosted PeopleBooks, downloadable HTML PeopleBooks, and downloadable PDF PeopleBooks as well as documentation updates.
Understanding PeopleBook structure.
Typographical conventions and visual cues used in PeopleBooks.
ISO country codes and currency codes.
PeopleBooks that are common across multiple applications.
Common elements used in PeopleBooks.
Navigating the PeopleBooks interface and searching the PeopleSoft online library.
Displaying and printing screen shots and graphics in PeopleBooks.
How to manage the locally installed PeopleSoft online library, including web site folders.
Understanding documentation integration and how to integrate customized documentation into the library.
Application abbreviations found in application fields.
You can find PeopleBooks and the PeopleSoft Online Library in the online PeopleBooks Library for your PeopleTools release.