Use the Sequence Element Audit Report to verify that all sequence type collection element numbers generated when entering collection plan results have been used and that you can account for any deleted numbers. For example, you have entered collection plan results and the sequence numbers generated for this set of results are 101, 102, 104, and 105. If you ran the Sequence Element Audit Report over this set of results, the report would only show results associated with the missing number, 103. You can choose to list any numbers unaccounted for in a sequence for all sequence type collection elements or for one particular sequence type collection element. You can also choose to list only the sequential numbers unaccounted for within a date range or those unaccounted for on all dates. The report lists, for each sequence type collection element in alphanumeric order, the following information:

• Organization code

• Collection plan name

• Collection number

• Occurrence number

• Sequence value

• Source code

• Source ID

• Audit type meaning (such as Deleted)

• Audit date

• User name

Report Submission

In the Submit Requests window, enter Sequence Element Audit Report in the Name field.

Report Parameters

Sequence Collection Element

Choose a sequence type collection element. See: To define sequential counter information for a collection element. and Step 3 - Update of Sequence prefix and suffix (mandatory), Oracle Quality Implementation Guide.

From Date

Enter a beginning date to restrict the report to a range of dates.

To Date

Enter an ending date to restrict the report to a range of dates.

Other Sources

• Step 3 - Update of Sequence prefix and suffix (mandatory), Oracle Quality Implementation Guide.