After upgrading to Madrid, existing sn_hr_integrations_schema_mapping records migrated to Global scope can not be edited properly, as the Staging table field does not show any tables in the list.

Steps to Reproduce

  1. Log in to a Kingston or London instance.
  2. Install the com.sn_hr_integrations plugin.
  3. Upgrade to Madrid.
  4. Navigate to HR Integrations -> HR Service Mapping.
  5. Select the 'Workday - Worker Profiles' service.
  6. Switch to the 'Human Resources: Integrations' application scope.
  7. Open a record from the 'HR Integrations Schema Mapping' related list.
  8. Switch back to the global scope to edit the corresponding record.

Notice that there are no tables in the list for the Staging Table field.


  1. Go to the Dictionary module.
  2. Search for the record with Table "sn_hr_integrations_schema_mapping" and Column name "staging_table"
  3. Open the record and click the "Advanced View" related link
  4. Add "allow_public=true" to the Attributes field and save the form.

Related Problem: PRB1332063

Seen In

There is no data to report.

Fixed In

Madrid Patch 4
New York

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-07-11 02:17:33