Using a Sequence in a Forward Crossedition Trigger

During the patching cycle for R12.2, we are upgrading our custom application by adding columns and updating existing columns in a specific table. We are also creating a new sequence to create a unique ID for each row in the table.

For example, our table currently has the following structure:

CREATE TABLE xxaventx_license (

     SEQ           NUMBER,

     VALUE       VARCHAR2 (2000)

)

where the sequence indicates the order in which to attempt to apply the license and the value actually stores the license key.

During the upgrade, we are updating the table to have the following structure:

CREATE TABLE xxaventx_license (

     ID                         NUMBER,

     SEQ                     NUMBER,