4.4.5 Exception Messages

The SYNCHRONIZE_INSTRUMENT procedure may cause some exceptions to appear. The text and explanation for each of these exceptions follows. If you call the procedure from a PL/SQL block you may want to handle them so that your program can proceed.

• Exception 1: Table is not an Instrument or LEDGER_STAT table

  The exception message reads:

  ORA-20002 Cannot process: table_name is not an OFSA Instrument or Ledger type table having all leaf columns.

  This exception occurs when the table_name parameter is not designated as an Instrument table or LEDGER_STAT table in the OFSAA Metadata. The procedure identified such tables based upon the Table Classification (Instrument or LEDGER_STAT).

• Exception 2: Table has invalid seeded FINANCIAL_ELEM_ID values

  The exception message reads:

  ORA-20004 Cannot process: table_name has new FINANCIAL_ELEM_ID values that are within seeded range (less than 10000).

  This error occurs when user-defined leaf values are found in the DIM_FINANCIAL_ELEMENTS_B table within the FDM Reserved seeded data range. The FDM seeded data range for OFSA_LEAF_DESC is WHERE LEAF_NUM_ID=0 and LEAF_NODE<10000. If more records are found in this range than the seeded count for FDM version, the Synchronize Instrument procedure displays the error message and terminates. Delete any user-defined Financial Element leaf values within the FDM seeded data range in order to resolve this problem.

• Exception 3: Description table does not exist
  The exception message reads:

  Note:

  'Description Table Name' code table could not be synchronized due to :ORA-00942: table or view does not exist. These tables must be synchronized manually. Failure to do so may result in inaccurate reports.

  This error occurs while inserting into the description table when user defined values are found in the Code column in dimension member and description table does not exist.