1. Accounting Foundation Cloud Service Core Functions
  2. Managing Data
  3. Data Egress
  4. Using Target Rejection Threshold
  5. Reading the Error Table

12.3.19.1 Reading the Error Table

AFCS creates the error table in the data service execution layer/schema to store records with errors. The structure of the error table is similar to the target table but with five additional columns. You can refer to the following column for executions:

  • ORA_ERR_NUMBER$ - The error number.
  • ORA_ERR_MESG$ - The ORA error message with the description of the error.
  • ORA_ERR_ROWID$ - The row ID of the error.
  • ORA_ERR_OPTYP$ - The operation type.
  • ORA_ERR_TAG$ - This column stores the Execution ID. You can use this column to filter and view error records for a specific execution.