Search Results create_sequence_with_new_value

Overview

MODIFY_ABM_SEQUENCES is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name associates it with the ABM (Activity-Based Management) product family, and its documented procedures indicate that it provides a utility layer for adjusting table columns and database sequence objects within that schema area. The package is classified as OTHER in the ETRM API classification, meaning it is not a published, supported public API for external integration but an internal helper whose use is largely confined to Oracle's own ABM code paths and, in practice, to controlled administrative or migration scripts.

The three documented programs—GET_TABCOL_AND_SEQ, MODIFY_TABLE_COLUMN_BY_VALUE, and CREATE_SEQUENCE_WITH_NEW_VALUE—describe a coherent purpose: reading the current value held in an ABM table column, altering that value, and creating or recreating a sequence so that it continues from the corrected position. This is characteristic of data-conversion, data-repair, and cutover tooling, where a target table's identifier column and its backing sequence must be kept in agreement after rows have been loaded, purged, or renumbered outside the normal application flow.

Key Procedures and Functions

• GET_TABCOL_AND_SEQ — a retrieval routine that returns the table/column and sequence pairing relevant to the caller's request. It is the discovery step: callers use it to determine the current column value and the sequence associated with it before any change is attempted.
• MODIFY_TABLE_COLUMN_BY_VALUE — a maintenance routine that updates a named table column to a supplied value. In the ABM context this is used to correct or reseed the identifier held in the table so that it matches the intended high-water mark.
• CREATE_SEQUENCE_WITH_NEW_VALUE — creates a sequence (or recreates it) starting at a specified value, so that subsequently generated identifiers do not collide with existing rows and continue contiguously from the corrected column value.

The three programs are complementary rather than independent: GET_TABCOL_AND_SEQ establishes the current state, MODIFY_TABLE_COLUMN_BY_VALUE adjusts the stored state, and CREATE_SEQUENCE_WITH_NEW_VALUE realigns the generator. The documented dependency list records only SYS and the STANDARD package, confirming that the package is written against core PL/SQL and does not depend on other APPS packages.

Tables Accessed

The ETRM metadata for this object records no tables accessed through APPS synonyms. Any table and column names handled by the package are therefore resolved dynamically at runtime—passed in as arguments or read from the ABM data dictionary—in the same manner as GET_TABCOL_AND_SEQ suggests. Because the package performs dynamic SQL against whatever table it is pointed at, it can affect any ABM table whose identifying column and sequence are supplied by the caller; administrators should treat it as a privileged utility and confirm the target object before execution.

Usage Notes

No other package is documented as referencing MODIFY_ABM_SEQUENCES, and the only documented inbound reference is to itself (recursive or overloaded invocation). It is not exposed through a standard concurrent program in the documented metadata. In Oracle EBS 12.1.1 and 12.2.2 it is therefore expected to be invoked from ABM application logic, from one-off SQL*Plus scripts during upgrade or conversion activities, or from custom code that needs to reseed an ABM sequence after bulk data movement. Because it executes DDL (sequence creation) and direct column updates, it should be run only by users with the appropriate APPS privileges, during a maintenance window, and with a validated backup of the affected table and sequence.