4.2.2 Data Loaders

Oracle Financial Services Cloud Service’s Data Loaders are used to move the data from one stage to another stage and in turn update the underlying Database Tables.

Oracle Financial Services Cloud Services support the following types of Data Loaders:

• Dimension Data Loaders: The Dimension Data Loaders are used to populate the Dimension Members, Attributes, and Hierarchies from the Staging Dimension Tables to the Dimension Tables registered with the Cloud Services.
• Instrument Data Loaders: The Instrument Data Loaders are used to move the data from the files to the staging instrument tables.
• Management Ledger Data Loaders: The Management Ledger Data Loaders are used to move the data from the files to the staging Ledger tables and then to the processing Ledger tables.

  Beginning with release 26C, the Stage DATA_SOURCE_CODE value is passed through as-is to a new DATA_SOURCE column in each of the six processing (FSI) Management Ledger tables, with no validation. This field is a free-text pass-through and is not a lookup-validated dimension.

• Transaction Summary Data Loaders: The Transaction Summary Data Loaders are used to move the data from the files to the staging Ledger tables and then to the processing Transaction Summary tables.

Note:

Ensure that the instrument and ledger data adhere to the following precision guidelines:All Balance columns – NUMBER(22,3), Rate – NUMBER(15,9), Frequency – NUMBER(5), Volume – NUMBER(30), Number – NUMBER(30), and Percent – NUMBER(10,6).

• Dimension Data Loader
  The Dimension Loader procedure populates Dimension Members, Attributes, and Hierarchies from Staging Dimension Tables into the Dimension Tables registered with the Cloud Services. You can view the Members and Hierarchies loaded by the Dimension Loader though the Cloud Service screens.
• Instrument and Ledger Data Loaders
  After the Data Files are uploaded to the Object Store, the Data Loaders are used to move the data from the files to the staging tables and then to processing tables.
• Generic Data Loader
  
• Interest Rates Loader
  The Interest Rates Data Loader allows the users to load the Interest Rate Curves that are consumed by the Oracle Financial Services Cloud Services.
• Interest Rates Definition Loader
  The Interest Rates Definition Loader allows the users to load the Interest Rate Curves definition that are consumed by the Oracle Financial Services Cloud Services.
• Rate Lock Option Volatility Loader
  This Loader is applicable only for Funds Transfer Pricing Cloud Service.
• Generating Holidays for Holiday Calendar using Scheduler
  The Generate Holidays option on the Holiday Calendar Definition page allows you to generate Holiday for a definition at a time. Using the Scheduler Service, you can generate the Holidays for multiple Calendar definitions in bulk.