1. User Guide
  2. Data Loaders
  3. Payment Pattern Loader
  4. Exception Messages

5.19.2 Exception Messages

Below are the list of error messages which can be viewed in view log from UI or FSI_MESSAGE_LOG table from back end filtering for the given batch id. On successful completion of each task messages gets into log table.

In the event of failure, following are the list of errors that may occur during the execution:

  • Exception 1: PATTERN TYPE IS NOT MATCHING THE LIST OF VALUES
  • Exception 2: TERM TYPE IS NOT MATCHING THE LIST OF VALUES
  • Exception 3: PAYMENT MULTIPLIER FREQ IS NOT MATCHING THE LIST OF VALUES
  • Exception 4: EVENT MONTH IS NOT MATCHING THE LIST OF VALUES
  • Exception 5: PMT PATTERN IS NOT MATCHING THE LIST OF VALUES
  • Exception 6: AMOUNT TYPE IS NOT MATCHING THE LIST OF VALUES
  • Exception 7: v_amrt_type_cd range between 1000 to 69999
  • Exception 8: n_payment_event_freq_cd and n_payment_event_repeat_value should have values range between 1 to 9999
  • Exception 9: N_PCT_VALUE POSITIVE INTEGER OR DECIMAL NUMBER
  • Exception 10: N_SPLIT_ID POSITIVE NUMBER
  • Exception 11: If Term Type is PRINCIPAL AND INTEREST, then it should range from 1 to 999999999
  • Exception 12: If Term Type is INTEREST ONLY AMOUNT and AMOUNT TYPE CD should be blank
  • Exception 13: ERR while deleting stg_payment_pattern unwanted records
  • Exception 14: Month and Day pair should have valid combination. Like January 31 days
  • Exception 15: Pct value should be 100 in case of split pattern for other patterns it should be =0
  • Exception 16: Error during percentage check
  • Exception 17: Error during inserting