Configuring an Exceptions Table as a Source Table

If you want to publish data from an exceptions table and also want to use this exceptions table as the source table, you cannot use the ADB_ERROR_TEXT or ADB_OPCODE columns.

To avoid using the ADB_ERROR_TEXT or ADB_OPCODE columns in the exceptions table, you can rename these columns.

Procedure

  1. Create a database view that mirrors the exceptions table, but rename the ADB_ERROR_TEXT and ADB_OPCODE columns so that they do not begin with "ADB_."
  2. Use the Publish by Reference Object feature and select your view as the referred object. For details about Publish by Reference Object, see Specifying a Reference Object.