Results for “party_object_id2”

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:

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.