Results for “cc_next_num”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGC_CC_NUMBER_METHODS table resides in the IGC (Contract Commitment) product schema and stores the numbering methods used to generate contract numbers within Oracle EBS Contract Commitment. It is a configuration table that governs how contract identifiers are allocated, including the numbering methodology, the data type of the generated number, the prefix applied, and the next available sequence value. Because numbering policies are typically defined per operating unit, the table is organizationally partitioned by ORG_ID.
From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification for this table. It carries descriptive, versioned attributes (method, datatype, prefix, next number) attached to a business key that resolves to an operating unit. In practice, this means IGC_CC_NUMBER_METHODS behaves less like an independent hub of business entities and more like a descriptive satellite hanging off an organizational hub (HR_ALL_ORGANIZATION_UNITS), with the ORG_ID serving as the effective business key linkage.
Key Information Stored
The documented schema contains 10 columns. The most significant are:
- ORG_ID — The operating unit identifier. Combined with the surrogate key, this forms the primary key (IGC_CCT_PK) and links the numbering method to a specific organization.
- CC_NUM_METHOD — The numbering method code, defining the algorithm or scheme used to generate contract numbers (for example, manual, automatic, or sequence-based).
- CC_NUM_DATATYPE — The data type of the contract number, indicating whether the generated value is numeric, alphanumeric, or another supported format.
- CC_NEXT_NUM — The next number to be assigned in the sequence, driving automatic contract number generation.
- CC_PREFIX — A prefix string prepended to the generated contract number, useful for categorization or readability.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle WHO columns capturing the audit trail of the most recent modification.
- CREATION_DATE, CREATED_BY — Standard WHO columns recording initial record creation.
The surrogate primary key, IGC_CCT_PK, is composed with ORG_ID. Business-key candidacy is effectively the ORG_ID column, which ties the configuration to the operating unit. There is no separately documented unique index beyond the primary key constraint.
Common Use Cases and Queries
The table is most commonly queried to determine the numbering configuration for a given operating unit, or to inspect or advance the next available contract number. Typical reporting includes auditing numbering policies across organizations and validating prefix and datatype settings.
A sample query to retrieve the numbering configuration for an operating unit:
SELECT cc_num_method, cc_num_datatype, cc_prefix, cc_next_num FROM igc.igc_cc_number_methods WHERE org_id = :p_org_id;
A query to list all defined numbering methods across organizations:
SELECT org_id, cc_num_method, cc_prefix, cc_next_num FROM igc.igc_cc_number_methods ORDER BY org_id;
An audit query joining to the organization for readable names:
SELECT n.org_id, o.name, n.cc_num_method, n.cc_prefix FROM igc.igc_cc_number_methods n, hr_all_organization_units o WHERE n.org_id = o.organization_id;
Related Objects
The following objects are most significant in relation to IGC_CC_NUMBER_METHODS:
- HR_ALL_ORGANIZATION_UNITS — Referenced via the foreign key IGC_CC_NUMBER_METHODS.ORG_ID to HR_ALL_ORGANIZATION_UNITS, providing the operating unit context for each numbering method.
- IGC_CC_HEADERS / Contract Commitment header tables — Contract records consume the numbering configuration defined here to allocate CC_NEXT_NUM values.
- IGC_CC_HEADERS_V / Contract Commitment views — Reporting views that surface generated contract numbers governed by these methods.
- FND_LOOKUPS / lookup views — Frequently used to resolve CC_NUM_METHOD and CC_NUM_DATATYPE codes into descriptive meanings.
- IGC Contract Commitment public APIs — Numbering logic invoked during contract creation reads the method, prefix, and next-number values from this table.
Together these objects let the numbering configuration function as the authoritative source for contract number allocation within the Contract Commitment module.
-
Numbering methods for contracts
-
Numbering methods for contracts
-
eTRM - IGC Tables and Views 12.2.2
System parameters for contracts
-
eTRM - IGC Tables and Views 12.1.1
System parameters for contracts