The LEDGER Table Is Missing From the Destination

Issue

The LEDGER table is included in the connection schema, but it is missing from the destination.

Environment

Connector: Workday Financial Management

Resolution

To resolve this issue:

1. In Workday, add the following security domains to the security group used by your connection, and confirm that GET and VIEW ONLY access are enabled for each domain:

   • For the JOURNAL_ENTRY table, add Process: Journals - View and View: Organization Journals.
   • For the LEDGER table, add Set Up: Ledger and Book.
   For more information, see our Workday Security Domains documentation. For our setup instructions, see Add domain security policies.

2. In Fivetran, ensure the LEDGER and JOURNAL_ENTRY tables are included in your connection schema.

   i. Go to your Workday Financial Management connection page.

   ii. Select the Setup tab.

   iii. Select the checkbox next to the LEDGER and JOURNAL_ENTRY tables.

   iv. Click Save changes.

3. To backfill the LEDGER table, re-sync the JOURNAL_ENTRY table.

   i. In the Setup tab, find the LEDGER table and click Re-sync.

   ii. In the confirmation pop-up window, click Start re-sync.

Cause

This issue occurs when the security group used by the connection does not have the required Workday security domains, or when the LEDGER and JOURNAL_ENTRY tables are not included in your connection schema.