Results for “contract_party_name”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_TERMNT_INTF_PTY is a termination interface detail table within the OKL (Leasing and Finance Management) module of Oracle E-Business Suite, holding schema ownership under OKL in both 12.1.1 and 12.2.2. The table exists to support the import of termination quote party information associated with contract or asset termination requests. When termination data is loaded from external sources or staged for processing, party-level details such as roles, allocation percentages, contact information, and delay handling are captured here before the termination process consumes them.
In terms of Data Vault modeling, the heuristic classification derived from the foreign key structure positions this table as satellite-leaning. This suggests it functions primarily as a descriptive detail store attached to a parent transactional entity rather than as an independent hub or a pure link table. The presence of a foreign key to OKL_TERMNT_INTERFACE_ALL via TRANSACTION_NUMBER reinforces that the table's rows derive their identity and meaning from the parent termination interface record.
Key Information Stored
The table contains 39 documented columns. The most business-significant among them include:
- TRANSACTION_NUMBER — The foreign key linking each row to the parent record in OKL_TERMNT_INTERFACE_ALL; this is the primary business join column.
- CONTRACT_PARTY_ID — Reference to the contract party, joined to OKC_REP_CONTRACT_PARTIES, identifying the specific party involved in the termination quote.
- QUOTE_ROLE_CODE and CONTRACT_PARTY_ROLE — Define the role the party plays within the termination quote context.
- CONTRACT_PARTY_NAME and CONTRACT_PARTY_NUMBER — Descriptive identifiers for the party.
- PARTY_OBJECT_CODE, PARTY_OBJECT_ID1, and PARTY_OBJECT_ID2 — Flexible references that tie the party to a specific object (such as an asset or contract element).
- EMAIL_ADDRESS — Contact information for notification or correspondence during termination.
- ALLOCATION_PERCENTAGE — The portion of the termination quote attributed to the party.
- DELAY_DAYS — A scheduling attribute indicating any delay applied to the party's termination processing.
- QPY_ID — A quote party identifier likely serving as a surrogate or unique reference within the quote context.
- STATUS — Tracks the processing state of the interface row.
- REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — Standard concurrent program audit columns identifying the import job that created or updated the row.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE — Standard WHO audit columns.
The table also includes fifteen descriptive flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15) for extensibility. Where a surrogate primary key exists it is not explicitly documented in the provided metadata; the strongest business-key candidate is the combination of TRANSACTION_NUMBER with party identification columns such as CONTRACT_PARTY_ID or QPY_ID.
Common Use Cases and Queries
Typical scenarios involve validating and reconciling imported party rows before termination processing, confirming allocation percentages across parties, and reporting on parties associated with pending terminations.
- Listing all parties for a given termination transaction:
SELECT * FROM OKL.OKL_TERMNT_INTF_PTY WHERE TRANSACTION_NUMBER = :txn;
- Identifying rows that failed or are pending processing:
SELECT TRANSACTION_NUMBER, CONTRACT_PARTY_NAME, STATUS FROM OKL.OKL_TERMNT_INTF_PTY WHERE STATUS = 'ERROR';
- Checking allocation totals per transaction to ensure they reconcile:
SELECT TRANSACTION_NUMBER, SUM(ALLOCATION_PERCENTAGE) FROM OKL.OKL_TERMNT_INTF_PTY GROUP BY TRANSACTION_NUMBER;
- Retrieving interface import job context via REQUEST_ID and PROGRAM_ID for audit and troubleshooting.
Related Objects
The most significant related objects are those tied through documented foreign keys:
- OKL_TERMNT_INTERFACE_ALL — Parent termination interface table; joined via OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = OKL_TERMNT_INTERFACE_ALL.TRANSACTION_NUMBER.
- OKC_REP_CONTRACT_PARTIES — Contract party repository; joined via OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = OKC_REP_CONTRACT_PARTIES.CONTRACT_PARTY_ID.
- OKL_TERMNT_INTF_* sibling interface tables — Share the TRANSACTION_NUMBER key for termination quote import.
- OKL termination processing programs and concurrent requests that consume rows via REQUEST_ID and PROGRAM_ID.
- Party and role reference tables underlying QUOTE_ROLE_CODE and CONTRACT_PARTY_ROLE lookups.
-
Termination interface detail table that allows import of termination quote party information pertaining to contract or asset termination requests
-
Termination interface detail table that allows import of termination quote party information pertaining to contract or asset termination requests
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards