Search Results seq_grw_rate_code

Overview

The table OKI.OKI_SEQ_GROWTH_RATE is a valid Oracle E-Business Suite object residing in the OKI (Oracle Contracts) schema. It stores summarized contract growth rate information, derived by aggregating contract values across accounting periods and comparing current-period amounts against prior-period amounts. The table functions as a periodic snapshot of contract value growth at the intersection of customer, product category, and service or contract classification (SCS_CODE) dimensions. In the context of Oracle EBS 12.1.1 and 12.2.2, it supports contract analytics, renewal forecasting, and period-over-period performance reporting.

Under a heuristic Data Vault classification, this object is modeled as a satellite. It carries descriptive measures and descriptive attributes (current and previous base contract amounts, party and organization names, rate codes) that change over time and are keyed by a composite business key combining period, organization, customer, and product attributes. No modeled foreign keys to parent hubs beyond SECURITY_GROUP_ID were identified, consistent with a standalone, denormalized summary table rather than a transactional detail table.

Key Information Stored

The table contains 20 documented columns. The most significant are:

• PERIOD_NAME, PERIOD_SET_NAME, PERIOD_TYPE — The accounting period context for the summarized snapshot, using a designated period set and type.
• SUMMARY_BUILD_DATE — The date on which the summary row was generated, distinguishing successive builds of the same period.
• AUTHORING_ORG_ID / AUTHORING_ORG_NAME — The operating unit or authoring organization responsible for the contract data.
• CUSTOMER_PARTY_ID / CUSTOMER_NAME — The internal party identifier of the contract customer and its display name.
• SEQ_GRW_RATE_CODE — The growth rate classification code (the attribute referenced by the user's search term, seq_grw_rate_code).
• SCS_CODE — A service or contract classification code grouped in the summary.
• PRODUCT_CATEGORY_CODE — The product category dimension for the summarized amounts.
• CURR_BASE_CONTRACT_AMOUNT / PREV_BASE_CONTRACT_AMOUNT — Current and prior period base contract amounts in base currency.
• CURR_SOB_CONTRACT_AMOUNT / PREV_SOB_CONTRACT_AMOUNT — Current and prior period contract amounts expressed in the set-of-books currency.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program audit columns identifying the process that built the row.

The surrogate primary key is not separately documented as a single column; instead, the business key is captured by the unique index OKI_SEQ_GROWTH_RATE_U1 spanning PERIOD_NAME, PERIOD_SET_NAME, PERIOD_TYPE, SUMMARY_BUILD_DATE, AUTHORING_ORG_ID, SEQ_GRW_RATE_CODE, SCS_CODE, CUSTOMER_PARTY_ID, PRODUCT_CATEGORY_CODE. This composite uniquely identifies each summarized row.

Common Use Cases and Queries

Typical reporting scenarios include period-over-period contract growth analysis, customer-level growth trending, and product category performance review. To retrieve growth rate rows for a given period and classification code:

• Filter by PERIOD_NAME and SEQ_GRW_RATE_CODE to isolate a specific growth classification.
• Join or aggregate on CUSTOMER_PARTY_ID, AUTHORING_ORG_ID, and PRODUCT_CATEGORY_CODE for dimension-level rollups.
• Compare CURR_BASE_CONTRACT_AMOUNT to PREV_BASE_CONTRACT_AMOUNT to compute implied growth, and reconcile base-currency measures against the SOB-currency columns.
• Restrict to the latest SUMMARY_BUILD_DATE where multiple summary runs exist for a period.

A representative pattern selects the current build for a period, filters on the growth rate code, and orders by contract value to rank customers. Access is restricted to standard Oracle Applications programs, so direct SQL should be limited to read-only reporting.

Related Objects

The documented relationship data identifies one modeled foreign key dependency:

• FND_SECURITY_GROUPS — joined via OKI_SEQ_GROWTH_RATE.SECURITY_GROUP_ID → FND_SECURITY_GROUPS.SECURITY_GROUP_ID. This column is used for application hosting and multi-tenant security separation.

Additional objects relevant to interpreting the table include the Oracle Contracts summary and reporting views that consume the same period, customer, and product category dimensions, and the concurrent program definitions identified by REQUEST_ID, PROGRAM_APPLICATION_ID, and PROGRAM_ID. Because the table is classified as standalone, it is not directly referenced by foreign keys from other tables, and it is populated by Oracle Contracts summary build processes rather than by direct user maintenance.