1. User Guide
  2. Data Loaders
  3. Simple Dimension Loader
  4. Exception Messages

5.2.4 Exception Messages

Below are the list of error messages which can be viewed in view log from UI or fsi_messge_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: When REV_DIMENSIONS_B is not having proper setup details.

    Meaning: For Simple Dimension write_flag, simple_dimension_flag, dimension_editable_flag should be Y in rev_dimensions_b for the given Dimension id.

  • Exception 2: When FSI_DIM_LOADER_SETUP_DETAILS table is not having proper set up details.

    Meaning: Setup details are not found for the dimension id.

  • Exception 3: When Display code Column is non numeric and trying to use as a surrogate key.

    Meaning: Display code Column should be numeric as v_gen_skey_flag N