Data Queue Table

This page is accessed via Business Process Automation > Power Data > Data Queues > Data Queue Tables.

The Data Queue Table maps the queue to an Oracle table. It also allows you to specify the size of queue partitions.

Adding a Data Queue Table

1. Enter a unique identifier for the data queue table in the Identifier field.
2. Optionally, specify a Domain Name.
3. Enter a Table Name. This is the Oracle table name of the data queue table.
4. Enter an Exception Table name. This is the Oracle table name of the data queue exception table.
5. Enter the Oracle Sequence. This is the Oracle sequence generator for the data queue sequence column.
6. Enter the Oracle Exception Sequence. When an error occurs in data queue processing, a record is written to the Exception Table referenced in the data queue. These records must have a sequenced primary key which maps to the Oracle Exception Sequence column of the table.
7. Enter a number in the Partition Duration field to determine the duration for the partitions. There are 12 partitions so if you set the partition duration to 30 days, monthly partitions will be deleted after 12 months. You can set this to any number, but the 12 partitions cannot be changed.
8. Click Finished.