1. Accounting Foundation Cloud Service Core Functions
  2. Managing Data
  3. Data Egress
  4. Using Target Rejection Threshold

12.3.19 Using Target Rejection Threshold

Target Rejection Threshold is a value defined for the number or percentage of records with errors that are allowed before the execution is configured to fail when you move records from the source database to the target database. It can be entered as an absolute value or as a percentage in the Connector Properties window.

AFCS creates an error table by duplicating the target table name and appending it with _ERR during the execution process. The erroneous records are logged into the error table and valid records are moved to the relevant table in the target. The errors can be of the types notional, public key, or data. For example, if the target table name is STG_CASA, then the error table name is created as STG_CASA_ERR. The objective is to log only a required number of errors and then correct them in the source table. After correcting the errors, rerun the execution. In the process, you can iteratively collect the errors and correct them, making the task of correcting the errors in the source table much simpler.

You can also move records from file table to the target database and the structure of the table remains same as file table added with five additional columns. For example, if the file table name is EDD12_THRESHOLD_VOLUMETEST, then the error table name is created as EDD12_THRESHOLD_VOLUMETEST_ERR.

Let us understand this process with the help of the following example.
  1. Enter 10 in the Target Rejection Threshold field.

    Note:

    1. To specify the value as 10 percent of the records in the execution, enter 10%.
    2. If you leave the field blank or enter 0, AFCS reads the threshold as 0 and the execution fails when an error is encountered.

      On execution of the process, AFCS permits up to 10 records with errors to process to the target table and any number of valid records. If the number exceeds 10, the execution process fails and stops. The erroneous records are available in the target table name appended with _ERR.

  2. In the SLA home page, under any SLA, click Data Ingestion and select View Data. This will display Data Visualization window where you can search for the target table name appended with _ERR.
  3. Check the details in the error table.

    For information on how to read the error table, see the Reading the Error Table. section.

  4. After checking the error table details, navigate to the source table and troubleshoot the errors.
  5. After correcting the errors, rerun the execution.
  6. Repeat the process iteratively and correct the errors.