Results for “service_period”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_AK_SRV_PERIOD_V is a lightweight Oracle E-Business Suite database view owned by the APPS schema in the Order Management (ONT) product family. It is documented in the E-Business Suite Technical Reference Manual (ETRM) as an object used for defaulting the Service Period attribute, a common requirement in service-oriented order capture and order fulfillment flows. In EBS release 12.1.1 and 12.2.2, this view serves as a value-lookup source within the Oracle Application Framework (OAF) / AK (Application Kit) regions and descriptive flexfield defaulting mechanisms rather than as a transactional data store.
The view does not persist any data of its own. Its sole purpose is to expose the set of valid Service Period values, which are drawn from the Time unit-of-measure class. This makes it a reference list that populates list-of-values (LOV) elements and defaulting rules in the order entry forms.
Because it is read-only and definition-only, OE_AK_SRV_PERIOD_V is stable across the two 12.x releases cited; no schema or column changes are documented between 12.1.1 and 12.2.2.
Underlying Base Objects
The view is defined over a single documented base object: MTL_ALL_PRIMARY_UOMS_VV (a VIEW in the APPS schema). The ETRM lists this as the only referenced base object, meaning OE_AK_SRV_PERIOD_V is a thin projection of a pre-existing unit-of-measure view rather than a join across multiple tables.
MTL_ALL_PRIMARY_UOMS_VV itself resolves unit-of-measure definitions from the underlying MTL_UOM_CLASSES and MTL_UNITS_OF_MEASURE tables. The predicate the Service Period view applies is:
- UOM_CLASS = 'TIME' — restricts rows to the TIME unit-of-measure class.
- INVENTORY_ITEM_ID = 0 — selects the class-level (non-item) primary UOM definitions.
In effect, the view filters MTL_ALL_PRIMARY_UOMS_VV down to time-based units, which are the natural candidates for expressing a service period (e.g., months, days, years).
Key Columns
The view exposes two columns returned by the SELECT list and referenced by consuming forms:
- SERVICE_PERIOD_CODE — the code value used as the stored identifier for the selected service period. Although the ETRM excerpt's SELECT list shows UOM_CODE, the documented view column is SERVICE_PERIOD_CODE; these map to the unit-of-measure code (for example, 'MONTH', 'DAY') used as the code key.
- SERVICE_PERIOD — the user-facing display value shown in the LOV, corresponding to the unit-of-measure name/description for the time unit.
Together these two columns form a code/description pair, which is the standard pattern for an AK-backed defaulting lookup. The code is persisted on the order line or attribute; the description is presented to the user during order entry.
Common Use Cases and Queries
The primary use case is Service Period defaulting in Order Management order-entry and service order flows. The view is queried by the defaulting framework to populate the Service Period LOV and to supply a default value when the attribute is left unspecified.
A typical retrieval is straightforward, since no joins are required:
SELECT SERVICE_PERIOD_CODE, SERVICE_PERIOD FROM APPS.OE_AK_SRV_PERIOD_V ORDER BY SERVICE_PERIOD;
To verify the underlying filter and unit-of-measure mapping during troubleshooting:
SELECT UOM_CODE, UNIT_OF_MEASURE FROM APPS.MTL_ALL_PRIMARY_UOMS_VV WHERE UOM_CLASS = 'TIME' AND INVENTORY_ITEM_ID = 0;
Because the view returns only time-class units, administrators diagnosing a missing Service Period value should confirm that the required time UOM is defined, enabled, and associated with the correct UOM class. Any change to the referenced base view or to the time UOM definitions propagates directly to OE_AK_SRV_PERIOD_V, so no direct maintenance of this object is performed or required.
-
View: OE_AK_SRV_PERIOD_V 12.1.1
Used for defaulting Service Period
APPS.OE_AK_SRV_PERIOD_V·↳ MTL_ALL_PRIMARY_UOMS_VV·Explore ONT module →
-
View: ASO_QUOTE_LINES_V 12.2.2
quote lines
APPS.ASO_QUOTE_LINES_V·↳ ASO_I_ITEMS_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_LOOKUPS·Explore ASO module →
-
View: OE_AK_SRV_PERIOD_V 12.2.2
Used for defaulting Service Period
APPS.OE_AK_SRV_PERIOD_V·↳ MTL_ALL_PRIMARY_UOMS_VV·Explore ONT module →
-
PACKAGE: APPS.OE_VALIDATE 12.1.1
-
APPS.ASO_PVT_RELATED_ITEMS_BALI_V·↳ MFG_LOOKUPS·↳ MTL_RELATED_ITEMS_VIEW·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
View: QP_PRICING_ATTR_GET_V 12.2.2
View of Benefit or Get Products for a Modifier. Used by Modifiers Form.
APPS.QP_PRICING_ATTR_GET_V·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
view based on quote line details
APPS.ASO_QUOTE_LINE_DETAILS_V·↳ ASO_QUOTE_LINE_DETAILS·Explore ASO module →
-
PACKAGE: APPS.OE_ID_TO_VALUE 12.1.1
-
APPS.ASO_PVT_QUOTE_LINES_BALI_V·↳ ASO_LINE_NUM_INT·↳ ASO_PVT_QUOTE_LINES_NUM_V·↳ FND_PROFILE·Explore ASO module →
-
PACKAGE: APPS.OE_VALIDATE 12.2.2
-
View: ASO_PVT_QUOTE_LINES_V 12.2.2
APPS.ASO_PVT_QUOTE_LINES_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_LOOKUPS·↳ ASO_QUOTE_LINES·Explore ASO module →
-
View: QP_PREQ_LDETS_TMP 12.2.2
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LDETS_TMP·↳ QP_PREQ_LDETS_TMP_T·Explore QP module →
-
This view returns Result of Separation Pay Tax based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_TAX_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_KR_REPORT_PKG·Explore PAY module →
-
APPS.ASO_PVT_QUOTE_LINES_BALIVIEW_V·↳ ASO_QUOTE_LINES·↳ ASO_QUOTE_LINE_DETAILS·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
View: OE_LINE_ACKS_V 12.1.1
Information about the acknowledgements for Order Lines
-
View: OE_ORDER_LINES_HIST_V 12.1.1
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OE_LINE_ACKS_V 12.2.2
Information about the acknowledgements for Order Lines
-
View: ASO_I_OE_ORDER_LINES_V 12.1.1
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: QP_PREQ_LINES_TMP 12.2.2
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINES_TMP·↳ QP_PREQ_LINES_TMP_T·Explore QP module →
-
Table: QP_PREQ_LINES_TMP_T1 12.2.2
-
View: ASO_I_OE_ORDER_LINES_V 12.2.2
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OKX_ORDER_LINES_V 12.2.2
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
View: ASO_QUOTE_LINES_V 12.1.1
quote lines
APPS.ASO_QUOTE_LINES_V·↳ ASO_I_ITEMS_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_LOOKUPS·Explore ASO module →
-
ASO_QUOTE_LINE_DETAILS_ALL stores information specific to certain types of quote lines
-
APPS.ASO_PVT_RELATED_ITEMS_BALI_V·↳ MFG_LOOKUPS·↳ MTL_RELATED_ITEMS_VIEW·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
Information specific to certain types of quote lines
APPS.OKX_QUOTE_LINE_DETAIL_V·↳ ASO_QUOTE_LINE_DETAILS·Explore OKX module →
-
Information specific to certain types of quote lines
APPS.OKX_QUOTE_LINE_DETAIL_V·↳ ASO_QUOTE_LINE_DETAILS·Explore OKX module →
-
View: OKX_ORDER_LINES_V 12.1.1
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
Permanent table for holding the details of the derivation of the base and adjusted prices.
-
This is a multi-org table for sales order lines open interface.
-
view based on quote line details
APPS.ASO_QUOTE_LINE_DETAILS_V·↳ ASO_QUOTE_LINE_DETAILS·Explore ASO module →
-
View: OE_PRN_ORDER_LINES_V 12.2.2
The view is for obtaining line details for printing a sales order
APPS.OE_PRN_ORDER_LINES_V·↳ FND_CURRENCY·↳ MTL_CROSS_REFERENCES·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
APPS.ASO_PVT_QUOTE_LINES_BALI_V·↳ ASO_LINE_NUM_INT·↳ ASO_PVT_QUOTE_LINES_NUM_V·↳ FND_PROFILE·Explore ASO module →
-
View: OE_SCH_ORDER_LINES_V 12.2.2
APPS.OE_SCH_ORDER_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →