Table of Contents
- Title and Copyright Information
- 1 Revision History
- 2 Get Help
- 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
- 8 Managing Users and Entitlements
- 9 Connecting to your Oracle ERP Service
- 10 Configuring Accounting Content
- 11 Registering Accounting Content with your ERP Service
- 12 Managing Data Catalog
-
13
Managing Data
- 13.1 File Operations
- 13.2 Data Ingress
-
13.3
Data Egress
- 13.3.1 Connectors
- 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.22 Executing Connectors
- 13.4 Quality
- 13.5 Dimensions
- 13.6 Hierarchy Management
- 13.7 Reporting Parent-Child Data Population
- 13.8 Protection
-
14
Managing Processes
- 14.1 Key Features of Process Orchestration
- 14.2 Process Pipeline Flow
- 14.3 Access Process Orchestration
- 14.4 Access Process Orchestration for New User Interface
-
14.5
Designing and Executing Pipelines
for New User Interface
- 14.5.1 Process Modeler for the New User Interface
- 14.5.2 Canvas and Components for New User Interface
- 14.5.3 Run Pipeline for the New User Interface
- 14.5.4 Add a Data Field from the New User Interface
- 14.5.5 Executing Run Pipeline from the New User Interface
- 14.5.6 PMF Dashboard for New User Interface
- 14.5.7 Scheduler Services for a PMF Process
- 14.5.8 Process Monitor for the New User Interface
-
14.6
Designing and Executing
Pipelines
- 14.6.1 Process Modeller
- 14.6.2 Canvas and Components
- 14.6.3 Design a Pipeline
- 14.6.4 Data Fields
- 14.6.5 Executing Run Pipeline
- 14.6.6 PMF Dashboard
- 14.6.7 PMF Email Notification
- 14.6.8 Process Monitor
- 14.6.9 Abort Run Pipeline
- 14.6.10 Resume Run Pipeline
- 14.6.11 Re-run Run Pipeline
-
15
Balance Computation
- 15.1 Currency Exchange Rates
- 15.2 Currency Conversion
- 15.3 Period to Date Balance
- 15.4 Period to Date Average
- 15.5 PMF Dashboard for Balance Computation
- 15.6 Hierarchy Data Refresh for Balance Computation Engine
- 15.7 Balance Computation Management Ledger Initialization
- 15.8 Revaluation
- 15.9 Beginning of Day Reversal Process
- 15.10 Translation
- 15.11 Support for Restatement
- 15.12 Data Extraction for Management Ledger Period Balances
- 15.13 Data for Balance Reconciliation of Management Ledger Period Balances
- 15.14 Initial Instrument - Grain Accounting Balance for Management Ledger
-
16
Balance Reconciliation
- 16.1 Measures List
- 16.2 Before you Begin
- 16.3 Access Balance Reconciliation UI
- 16.4 Configure Type of Reconciliation
- 16.5 Configure Entity
-
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.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.3 Reconciliation Summary
-
16.6.1
Define Reconciliation
Rules
- 16.7 Configure Adjustments
- 16.8 PMF Dashboard for Balance Reconciliation
- 16.9 Hierarchy Configuration for Reconciliation
- 16.10 Workflow of Balance Reconciliation
- 17 Issues and Actions
-
18
Dashboards and Reports
- 18.1 Overview of Balance Reconciliation Reports and Dashboards
- 18.2 Reporting Custom Mapping
- 18.3 Balance Computation Engine
- 18.4 Balance Computation Results
- 18.5 Data Quality Results
- 18.6 Data Visualization
- 18.7 Business Intelligence Publisher
- 18.8 Accounting Entries Report
- 18.9 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 Data Quality Error Report
- 19.7 OOTB Extract for Period Day YTD Balance
- 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
- 22 Frequently Asked Questions