Table of Contents

• Title and Copyright Information
• 1 Revision History
• 2 Get Help
  • 2.1 Access Help Content
    • 2.1.1 Watch Video
    • 2.1.2 Additional Resources
  • 2.2 Learn About Accessibility
  • 2.3 Get Support
  • 2.4 Get Training
  • 2.5 Join Our Community
  • 2.6 Share Your Feedback
• 3 About Accounting Foundation Cloud Service
• 4 Accessing the Accounting Foundation Cloud Service
• 5 Post Upgrade Steps
• 6 Viewing the System Information
• 7 Setting Up Your Service
  • 7.1 Domain
    • 7.1.1 Select your Domain
    • 7.1.2 Add Domain
    • 7.1.3 Deploy the Domain
  • 7.2 Legal Entity
    • 7.2.1 Legal Entity Settings
  • 7.3 Fiscal Period
    • 7.3.1 Set Up Fiscal Periods
    • 7.3.2 Compile Fiscal Periods
  • 7.4 Configure Parameters
    • 7.4.1 Accessing Parameters
    • 7.4.2 Parameter Settings
    • 7.4.3 Defining a Parameter
    • 7.4.4 Modifying and Viewing a Parameter
    • 7.4.5 Deleting a Parameter
    • 7.4.6 Dependency
• 8 Managing Users and Entitlements
• 9 Connecting to your Oracle ERP Service
  • 9.1 AHCS Instance Details
    • 9.1.1 Configure ERP Settings
  • 9.2 Verification of ERP Settings
• 10 Configuring Accounting Content
  • 10.1 Sub Ledger Application Definition
    • 10.1.1 Subledger Application Summary
    • 10.1.2 Pre-packaged Subledgers
  • 10.2 Adding a Subledger Application
  • 10.3 Event and Journal Grouping
    • 10.3.1 Subledger Event Grouping Summary
    • 10.3.2 Defining an Event Group
    • 10.3.3 Managing Group Attributes
  • 10.4 Subledger Attributes
    • 10.4.1 Adding a Subledger Attribute
• 11 Registering Accounting Content with your ERP Service
  • 11.1 Registration of SLAs with Accounting Hub Service
  • 11.2 Configuring an SLA
    • 11.2.1 Ledger Name Assignment
  • 11.3 Publishing SLAs
  • 11.4 Ledger Configuration
  • 11.5 Unpublishing SLAs
  • 11.6 Segment Mapping
    • 11.6.1 Mapping Segments
  • 11.7 Accounting Balance Ingestion
    • 11.7.1 Prerequisite
    • 11.7.2 GL Balances Process
    • 11.7.3 Executing GL Balances Process
  • 11.8 Journal Ingestion
    • 11.8.1 Prerequisite
    • 11.8.2 ERP Journal Ingestion Process
    • 11.8.3 Executing ERP Journal Ingestion Process
  • 11.9 ERP GL Journal Ingestion
    • 11.9.1 Prerequisite
    • 11.9.2 ERP GL Journal Ingestion Process
    • 11.9.3 Executing ERP GL Journal Ingestion Process
  • 11.10 Copying a Subledger Application
  • 11.11 Executing the SLA Pipelines
    • 11.11.1 Prerequisite
    • 11.11.2 SLA Pipeline Process
    • 11.11.3 Executing SLA
• 12 Managing Data Catalog
  • 12.1 Accessing the Catalog
  • 12.2 Viewing Catalog Content
  • 12.3 Extending Catalog Content
• 13 Managing Data
  • 13.1 File Operations
  • 13.2 Data Ingress
    • 13.2.1 External Data Descriptor
    • 13.2.2 Data Tab
    • 13.2.3 Control Tab
    • 13.2.4 Transformation Tab
    • 13.2.5 Defining an External Data Descriptor
    • 13.2.6 Modifying and Viewing an External Data Descriptor
    • 13.2.7 Deleting an External Data Descriptor
    • 13.2.8 Search and Filter
    • 13.2.9 Parameters in EDD Definition
  • 13.3 Data Egress
    • 13.3.1 Connectors
      • 13.3.1.1 Icons and Description
    • 13.3.2 Creating Connectors
    • 13.3.3 Ingesting Data into AFCS
    • 13.3.4 Filter
    • 13.3.5 Join
    • 13.3.6 Lookup
    • 13.3.7 Aggregation
    • 13.3.8 Reference Identifier Generator
    • 13.3.9 Transpose (Rows to Columns)
    • 13.3.10 Transpose (Columns to Rows)
    • 13.3.11 Derived Column
    • 13.3.12 Mapping
    • 13.3.13 Flattened Table to Hierarchy
    • 13.3.14 Hierarchy Data Flattening
    • 13.3.15 Specifying Alias in Connector
    • 13.3.16 Modifying and Viewing a Connector
    • 13.3.17 Copying a Connector
    • 13.3.18 Deleting a Connector
    • 13.3.19 Search and Filter
    • 13.3.20 Parameters in Connector
    • 13.3.21 Using Target Rejection Threshold
      • 13.3.21.1 Reading the Error Table
    • 13.3.22 Executing Connectors
      • 13.3.22.1 Executing Connector Using Process Modelling Framework
      • 13.3.22.2 Specifying Runtime Parameters
  • 13.4 Quality
  • 13.5 Dimensions
  • 13.6 Hierarchy Management
  • 13.7 Protection
    • 13.7.1 Data Redaction
• 14 Managing Processes
  • 14.1 Key Features of Process Orchestration
  • 14.2 Process Pipeline Flow
  • 14.3 Access Process Orchestration
  • 14.4 Designing and Executing Pipelines
    • 14.4.1 Process Modeller
    • 14.4.2 Canvas and Components
      • 14.4.2.1 Service Task
        • 14.4.2.1.1 How to Use a Service Task
          • 14.4.2.1.1.1 Activity Tab
          • 14.4.2.1.1.2 Implementation Tab
      • 14.4.2.2 Transition
        • 14.4.2.2.1 Gateways
          • 14.4.2.2.1.1 Executing Parallel Tasks
      • 14.4.2.3 Connector
      • 14.4.2.4 Widgets
        • 14.4.2.4.1 How to Use a Widget
          • 14.4.2.4.1.1 Dynamic Parameters for Widgets
    • 14.4.3 Design a Pipeline
      • 14.4.3.1 Run Pipeline
        • 14.4.3.1.1 Creating a Run Pipeline
        • 14.4.3.1.2 Creating and Executing a Custom DQ Run Pipeline
      • 14.4.3.2 Additional Functionalities
        • 14.4.3.2.1 Modifying a Pipeline
        • 14.4.3.2.2 Viewing a Pipeline
        • 14.4.3.2.3 Copying a Pipeline
        • 14.4.3.2.4 Deleting a Pipeline
    • 14.4.4 Data Fields
      • 14.4.4.1 Add a Data Field
      • 14.4.4.2 System Data Fields
    • 14.4.5 Executing Run Pipeline
    • 14.4.6 PMF Dashboard
      • 14.4.6.1 View and Filter PMF Dashboard
      • 14.4.6.2 Exporting PMF Dashboard Report
    • 14.4.7 Process Monitor
      • 14.4.7.1 Monitoring a Process
      • 14.4.7.2 Viewing Activity Execution Logs
    • 14.4.8 Abort Run Pipeline
    • 14.4.9 Resume Run Pipeline
    • 14.4.10 Re-run Run Pipeline
• 15 Balance Computation
  • 15.1 Currency Exchange Rates
    • 15.1.1 About Currency Exchange Rates
    • 15.1.2 Staging
      • 15.1.2.1 Currency Exchange Rates at Time Granularity
      • 15.1.2.2 Currency Rate Type with Seeded List of Values
      • 15.1.2.3 Currency Rate Nature with Seeded List of Values
    • 15.1.3 Preparation
    • 15.1.4 Currency Exchange Rates Workflow
  • 15.2 Currency Conversion
  • 15.3 Period to Date Balance
  • 15.4 Period to Date Average
    • 15.4.1 Resave Hierarchies
    • 15.4.2 Use and Execute the Balance Computation Management Ledger Process
  • 15.5 Revaluation
    • 15.5.1 Use and Execute Revaluation Preparation Pipeline
    • 15.5.2 Use and Execute the Revaluation Process
  • 15.6 Translation
  • 15.7 Support for Restatement
    • 15.7.1 Overview
      • 15.7.1.1 Data Identification Criteria
      • 15.7.1.2 Process Details
  • 15.8 Data Extraction for Management Ledger Period Balances
  • 15.9 Data for Balance Reconciliation of Management Ledger Period Balances
  • 15.10 Initial Instrument - Grain Accounting Balance for Management Ledger
    • 15.10.1 Ingest Initial Balance
    • 15.10.2 Migration of Historical Balances
• 16 Balance Reconciliation
  • 16.1 Measures List
    • 16.1.1 Enable Custom Measures
  • 16.2 Before you Begin
  • 16.3 Access Balance Reconciliation UI
  • 16.4 Configure Type of Reconciliation
    • 16.4.1 Type Configuration
      • 16.4.1.1 General Ledger to Product Processor
        • 16.4.1.1.1 Settings
        • 16.4.1.1.2 Dimensions
        • 16.4.1.1.3 Editing Dimensions
      • 16.4.1.2 General Ledger to Management Ledger
        • 16.4.1.2.1 Settings
        • 16.4.1.2.2 Dimensions Section
        • 16.4.1.2.3 Editing Dimension
      • 16.4.1.3 Management Ledger to Product Processor
        • 16.4.1.3.1 Settings
        • 16.4.1.3.2 Dimensions Section
        • 16.4.1.3.3 Editing Dimension
  • 16.5 Configure Entity
    • 16.5.1 Entity Configuration
  • 16.6 Reconciliation Rules
    • 16.6.1 Define Reconciliation Rules
      • 16.6.1.1 Reconciliation Rule
      • 16.6.1.2 Search Reconciliation Rule
        • 16.6.1.2.1 Definition List
      • 16.6.1.3 Add a Reconciliation Definition
        • 16.6.1.3.1 Settings
        • 16.6.1.3.2 GL Parameters (Source Ledger Parameters)
        • 16.6.1.3.3 Target Parameters
        • 16.6.1.3.4 GL Level Reconciliation (If GL Level is selected in the Settings Tab)
        • 16.6.1.3.5 Map Level Reconciliation (If Map Level is selected in the Settings Tab)
        • 16.6.1.3.6 Dimensions
        • 16.6.1.3.7 Allocation
        • 16.6.1.3.8 GL Level Reconciliation (if GL Level Reconciliation is selected in the Settings window)
        • 16.6.1.3.9 Map Level Reconciliation (if Map Level Reconciliation is selected in the Setting pane)
        • 16.6.1.3.10 Adjustment Attributes
    • 16.6.2 Execution of Rule
      • 16.6.2.1 Prerequisite
      • 16.6.2.2 Process Modeller
      • 16.6.2.3 Process Monitor
    • 16.6.3 Reconciliation Summary
      • 16.6.3.1 Exporting Adjustments
      • 16.6.3.2 Importing Adjustments
      • 16.6.3.3 Publishing
  • 16.7 Configure Adjustments
    • 16.7.1 Adjustments Summary
    • 16.7.2 Search Adjustment Rule
    • 16.7.3 Add Adjustment Template
    • 16.7.4 Update Adjustment Template
  • 16.8 Resave Hierarchies
  • 16.9 Workflow of Balance Reconciliation
• 17 Issues and Actions
  • 17.1 Issues
  • 17.2 Actions
  • 17.3 Tracking and Work flow
    • 17.3.1 Manage an Issue
      • 17.3.1.1 Create or Log an Issue
      • 17.3.1.2 Update an Issue
      • 17.3.1.3 Close an Issue
      • 17.3.1.4 Reopen an Issue
      • 17.3.1.5 Delete an Issue
    • 17.3.2 Manage an Action
      • 17.3.2.1 Create an Action
      • 17.3.2.2 Update an Action
      • 17.3.2.3 Approval Work flow for Issues and Actions
        • 17.3.2.3.1 Catalog Extension
          • 17.3.2.3.1.1 Approve an Action
          • 17.3.2.3.1.2 Return an Action
          • 17.3.2.3.1.3 Close an Action
          • 17.3.2.3.1.4 Reopen an Action
          • 17.3.2.3.1.5 Delete an Action
    • 17.3.3 Create or Update a Business Term
• 18 Dashboards and Reports
  • 18.1 Overview of Balance Reconciliation Reports and Dashboards
  • 18.2 Accessing the Standard Reports and Dashboards
    • 18.2.1 Report Descriptions
      • 18.2.1.1 Dashboard: Home
      • 18.2.1.2 Dashboard: Threshold Breach
      • 18.2.1.3 Dashboard: Reconciliation Execution Audit Trail
      • 18.2.1.4 Dashboard: Map Filter Report
  • 18.3 Custom Attributes
  • 18.4 Balance Computation Engine Reports
    • 18.4.1 Accessing the Standard Reports and Dashboards
    • 18.4.2 Report Descriptions
      • 18.4.2.1 Dashboard: Translated
      • 18.4.2.2 Dashboard: Day and PTD
      • 18.4.2.3 Dashboard: Revalued
      • 18.4.2.4 Dashboard: Day
  • 18.5 Balance Computation Results
    • 18.5.1 Accessing the Standard Reports and Dashboards
    • 18.5.2 Report Descriptions
      • 18.5.2.1 Dashboard: Period to Date
  • 18.6 Data Quality Results Reports
    • 18.6.1 Accessing the Standard Reports and Dashboards
    • 18.6.2 Report Descriptions
      • 18.6.2.1 Data Quality Results
  • 18.7 Data Visualization Reports
    • 18.7.1 Access to Data via Data Visualization
      • 18.7.1.1 User Roles
    • 18.7.2 Accessing the Data Visualization Reports
    • 18.7.3 Data Ingestion Query
  • 18.8 Optional Lineage from ERP Cloud FAH to AFCS
• 19 Data Extraction
  • 19.1 Adding a Data Extraction
  • 19.2 OOTB Extract for Management Ledger
  • 19.3 OOTB Extract for Management Ledger As Of Date
  • 19.4 OOTB Extract for Management Ledger As Of Effective Date
  • 19.5 Extracting the maximum version of ML balances
  • 19.6 OOTB Extract for Period Day YTD Balance
    • 19.6.1 Prerequisite
    • 19.6.2 Period Day YTD Balance Extraction Process
    • 19.6.3 Executing Period Day YTD Balance Extraction Process
• 20 Obtaining Support for Your Service
• 21 Key Terms and Concepts
  • 21.1 Adjustment Entry
  • 21.2 Adjustment Entry Floor
  • 21.3 Attributed Dimension
  • 21.4 Data set
  • 21.5 Dimension
  • 21.6 Dimension Attributes
  • 21.7 Hierarchy
  • 21.8 Global Threshold
  • 21.9 Inherit to Child
  • 21.10 Reconciliation
  • 21.11 Reconciliation Difference
  • 21.12 Threshold
  • 21.13 Positive Threshold
  • 21.14 Negative Threshold
  • 21.15 Threshold Breached Type
  • 21.16 General Ledger to Product Processor
  • 21.17 General Ledger to Product Management Ledger
  • 21.18 Consolidation Type
    • 21.18.1 Solo
    • 21.18.2 Consolidated
    • 21.18.3 Inherit to Child
    • 21.18.4 Manual Reconciliation Definition
    • 21.18.5 GL Level Reconciliation
    • 21.18.6 Map Level Reconciliation
• 22 Frequently Asked Questions