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.

Loading the Interest Rate Data consists of three tasks as follows:

  • Stage Loader
  • Stage Validator
  • Processing Loader

To upload the Interest Rate Definition file:

  1. From the LHS menu, select Data Management Tools, select Data File Administration, and then select File upload and download to display the File Upload/Download screen.
  2. Click Drag and Drop to browse and select a file for upload from a local directory. You can also browse to the local directory from the File Explorer, select the file, and drop it.

    The File Upload/Download service supports uploading CSV format files.

    Name of the Data File must follow the format as given below:

    • A prefix as INPUT_YYYYMMDD where the date format is related to the As of Date (i.e., 02-October-2023 becomes 20231002).
    • A suffix as _FILENAME.CSV.
    • An example of Data File Name could be: INPUT_20231002_IRCS_<DATAFILENAME>.csv.

      The order of the columns in the input file must be as follows:

      • INTEREST_RATE_CD
      • IRC_NAME
      • IRC_DESC
      • ISO_CURRENCY_CD
      • DATE_BASED_TERM_POINTS
      • DISPLAY_FOR_ALL_CCY_FLG
      • RISK_FREE_RATE_FLG
      • TERM o MULTIPLIER
      • RATE_FORMAT
      • COMPOUNDING_BASIS
      • ACCRUAL_BASIS

    For more information about File Upload and Download, see File Upload and Download Utility section.

  3. After selecting the file to upload, click Upload.

    The UI displays a confirmation message: Upload successful and insert the data into the Stage tables.

    At this stage, the Stage Validation begins and performs the following checks:
    • INTEREST_RATE_CD: Code does not exists. Allows only numbers, max 10 digits.
    • IRC_NAME: name don’t exist. Allows only Alphanumeric space _ , . - &.
    • IRC_DESC: Description. Allow only - Alphanumeric space _ , . - & / ! # @ $ % ? ( ) [ ].
    • ISO_CURRENCY_CD: Only accept active currency.
    • DATE_BASED_TERM_POINTS: N or null for normal, Y for Date Base.
    • DISPLAY_FOR_ALL_CCY_FLG: Y for Display for all currency, N or null for not.
    • RISK_FREE_RATE_FLG: Y for Risk free rate, 0 or null for not.
    • TERM: Allows 1 to 9999.
    • MULTIPLIER: Allow D, M, Y.

    Warnings are displayed in the View Log.

  4. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Batch. For more details, see Define Batch.
  5. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Task. For more details, see Define Tasks.
    1. Task Type: REST
    2. Component:
      • IRC Data Loader (this component is a combination of Stage Loader, Stage Validator, and Processing Loader.
      • Loader Type: By default IRC Historical Data is selected. You must select IRC Definition irc definition loader.
      • File Name: INPUT_20231002_IRCS_<DATAFILENAME>.csv
  6. Select the seeded batch and click Edit Parameters. In the Dynamic Parameters pop-up window, change the date to the relevant As-of-Date, and then save the batch.
  7. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Execute Batch.
  8. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Monitor Batch. For more information, see Monitor Batch.
  9. Select the Batch and then select the MISDATE and the Batch name. There may be multiple executions of the Exchange Rate Data Loader batch. Select the latest execution and click Start Monitor.

    The UI displays the Status of the batch.