Dow Jones Partnership for Restricted Party Trade Content

Oracle Global Trade Management is working with Dow Jones to provide restricted party trade content to GTM. Dow Jones provides 3 different sets of data to be used for restricted party screening:

  • Global sanctions and other official lists (List: SAN)
    • Provides sanctions lists across over 70 jurisdictions globally including the UN, EU, OFAC and the UK
    • Additional publicly available lists including law enforcement and other official lists
  • Sanctions control and ownership (List: SCO)
    • Lists of entities where sanctioned individuals or entities that hold shares or have a possible controlling interest
  • State owned companies (List: SOC)
    • Lists corporations with:
      • Government ownership of 1% or more
      • Government voting control
      • Government control of board of directors

This feature provides flexibility when choosing a third party content provider for restricted party, sanction, and beneficial ownership data.

Steps to Enable

To configure the SAN list:

  • Navigate to Master Data > Power Data > Data Loading > Content Source
  • Click New to create a new Content Source
    • Enter a Content Source ID =  DOWJONES_WL 
    • Enter a Source Name
    • Within the Content Source Data Type grid:
      • Add a Sequence
      • Enter a Source Data Type = DJ_WL
      • Mark the Supported checkbox 
      • Select a Content Type = RESTRICTED PARTY
      • Click Save
    • Within the Configuration grid:
      • Click the ‘New Content Source Config’ button
      • Enter a Configuration = DJ_WL
      • Mark the Active checkbox
      • Select a Communication Method = HTTPPOST
      • Add an External System including the External System ID, URL, User Name and Password provided by Dow Jones. Ensure the Content Type = text/xml.
      • Click Save 
    • Click Finished
  • Navigate to Master Data > Power Data > Data Loading > Data Load Types 
  • Click New to create a New Data Load Type
    • Enter a Data Load Type ID = DOWJONES_WL 
    • Select a Content Type ID = RESTRICTED PARTY
    • Select the Content Source = DOWJONES_WL (the content source you just created)
    • Enter Loading Process Details = gtm.server.workflow.dataload.viajava.CIDeniedPartyDataLoader
    • Within the Data Load Type Files grid:
      • Enter a Sequence Number = 1
      • Enter a File Name = SOURCE_FILE
      • Mark the Is Required checkbox
      • Click Save 
    • Click Finished

To configure the SCO list:

  • Navigate to Master Data > Power Data > Data Loading > Content Source
  • Click New to create a new Content Source
    • Enter a Content Source ID =  DOWJONES_SCO
    • Enter a Source Name
    • Within the Content Source Data Type grid:
      • Add a Sequence
      • Enter a Source Data Type = DJ_SCO
      • Mark the Supported checkbox 
      • Select a Content Type = RESTRICTED PARTY
      • Click Save
    • Within the Configuration grid:
      • Click the ‘New Content Source Config’ button
      • Enter a Configuration = DJ_SCO
      • Mark the Active checkbox
      • Select a Communication Method = HTTPPOST
      • Add an External System including the External System ID, URL, User Name and Password provided by Dow Jones. Ensure the Content Type = text/xml.
      • Click Save 
    • Click Finished
  • Navigate to Master Data > Power Data > Data Loading > Data Load Types 
  • Click New to create a New Data Load Type
    • Enter a Data Load Type ID = DOWJONES_SCO
    • Select a Content Type ID = RESTRICTED PARTY
    • Select the Content Source = DOWJONES_SCO (the content source you just created)
    • Enter Loading Process Details = gtm.server.workflow.dataload.viajava.CIDeniedPartyDataLoader
    • Within the Data Load Type Files grid:
      • Enter a Sequence Number = 1
      • Enter a File Name = SOURCE_FILE
      • Mark the Is Required checkbox
      • Click Save 
    • Click Finished

To configure the SOC list:

  • Navigate to Master Data > Power Data > Data Loading > Content Source
  • Click New to create a new Content Source
    • Enter a Content Source ID =  DOWJONES_SOC
    • Enter a Source Name
    • Within the Content Source Data Type grid:
      • Add a Sequence
      • Enter a Source Data Type = DJ_SOC
      • Mark the Supported checkbox 
      • Select a Content Type = RESTRICTED PARTY
      • Click Save
    • Within the Configuration grid:
      • Click the ‘New Content Source Config’ button
      • Enter a Configuration = DJ_SOC
      • Mark the Active checkbox
      • Select a Communication Method = HTTPPOST
      • Add an External System including the External System ID, URL, User Name and Password provided by Dow Jones. Ensure the Content Type = text/xml.
      • Click Save 
    • Click Finished
  • Navigate to Master Data > Power Data > Data Loading > Data Load Types 
  • Click New to create a New Data Load Type
    • Enter a Data Load Type ID = DOWJONES_SOC
    • Select a Content Type ID = RESTRICTED PARTY
    • Select the Content Source = DOWJONES_SOC (the content source you just created)
    • Enter Loading Process Details = gtm.server.workflow.dataload.viajava.CIDeniedPartyDataLoader
    • Within the Data Load Type Files grid:
      • Enter a Sequence Number = 1
      • Enter a File Name = SOURCE_FILE
      • Mark the Is Required checkbox
      • Click Save 
    • Click Finished

Key Resources

For more information on integrating with content providers, please refer to the Regulatory Content System Guide.

For more information about the content provided by Dow Jones, please refer to the Dow Jones website.