Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-07-25
Steps: Create Consolidation Data Capture Integration in AP&C

Steps: Create Consolidation Data Capture Integration in AP&C

  • Access to a Document Retrieval Service server (Example: SFTP), including user ID and password that contains the consolidation data files.
  • Consolidation data files must be in the Workday-defined Comma-Separated Value (CSV) format.
  • Create source systems.
    Create 1 source for each external Enterprise Resource Planning (ERP) endpoint task.
    When you have different instances of an ERP endpoint, Workday recommends that you create separate source systems to secure, and better manage Mapping Table Definitions and Mapping Tables.
You can create integrations in Adaptive Planning and Consolidation (AP&C) to load consolidation data in the form of summarized trial balance lines into Workday from various external endpoints.
To upload unbalanced journal lines, you must have configured a suspense account rule for the account set used by the company for which you upload consolidation data.
  1. Enter
    Consolidation Data - Inbound
    at the
    New using Template
     prompt.
  2. (Optional) Configure integration services. As you complete this section, consider:
    Option
    Description
    Consolidation Data - Inbound/Import Consolidation Data Configurations
    Enable this service to provide these additional configuration options in Message Audit:
    • Input File Tag
       integration attribute.
    • Include Web Service Requests in Message Audit
       integration attribute.
    This service also provides the:
    • Launch parameter for auto submit and
      Parallel Thread Count Override
       configurations.
    • Enable Suspense Accounting
       integration attribute that enables the uploading of unbalanced journals.
    Consolidation Data - Inbound/Financials Document Retrieval Service
    Enable this service to retrieve files for processing through the related integration system.
    Select the
    Configure Files for External Delivery
     integration attribute to enable this service to deliver the
    CSV Audit Diagnostic File
     output file to external endpoints.
    To deliver this file, you must select the
    Create Audit File in CSV Format
     integration attribute.
    To deliver files to external endpoints, configure a document delivery step on a business process in the integration system.
    We don't support backslashes on these fields when you generate an audit file on a CSV import file:
    • Journal Entry Memo
    • Journal External Reference ID
    • Journal Line External Reference ID
    • Journal Line Memo
    Filter Import Process Messages
    This service provides technical processing that isn’t impactful to your integration. You can either enable or disable it with no meaningful impact.
  5. Create an Integration System User (ISU) and grant the ISU
    Get
     and
    Put
     access to these domains:
    • Process: Consolidation Data Capture
    • Integration Event
  6. Select
    Integration System
    Configure Integration Attributes
     as a related action on the integration system.
    If required, enter these integration service attributes:
    • For the Import Trial Balance Configurations attribute provider:
      • Input File Tag
      • Include Web Service Requests in Message Audit
    • For the Integration Document Retention attribute provider:
      • Document Retention Policy
    • To enable the uploading of unbalanced consolidation journals:
      • Enable Suspense Accounting
    Security:
    Integration Build
     and
    Integration Configure
     domains in the Integration functional area.
  7. Select
    Integration System
     >
    Configure Integration Maps
     as a related action on the integration system to map tables to external values in the input file.
    Security:
    Integration Build
     and
    Integration Configure
     domains in the Integration functional area.
    As you configure the integration map, consider:
    Option
    Description
    Internal Value
    Select the name of the mapping tables you defined on the
    Create Consolidation Data  Mapping Table
     task to match the external codes to:
    • Company
    • Workday Ledger Accounts
    • Worktags
    External Value
    Provide a value that will correspond to the column header values for the Table Name in the input file. It must be an exact match to what displays in the input file. Workday doesn't support special characters.
    Each mapped column must follow this format:
    • EC. indicates that the column is a Mapping Table column.
    • TableName is the exact name of the external value in the
      Map: Apply Mapping Tables
       located on the integration system.
    • ColumnName is the exact name of the column within the Referenced Mapping Table in Workday.