Search Results pa_expend_typ_sys_links_pk

Overview

PA_EXPEND_TYP_SYS_LINKS is an intersection table in the Oracle Projects (PA) schema that associates expenditure types with system linkage functions. It sits beneath both PA_EXPENDITURE_TYPES and PA_SYSTEM_LINKAGES, resolving the many-to-many relationship between the two by holding one row for each valid combination. Oracle EBS uses this association to determine which system-defined linkage functions (such as cost accrual, burdening, or interface processing behaviors) are permitted or configured for a given expenditure type.

The table is defined with a composite primary key, PA_EXPEND_TYP_SYS_LINKS_PK, spanning EXPENDITURE_TYPE and SYSTEM_LINKAGE_FUNCTION. A redundant unique index, PA_EXPEND_TYP_SYS_LINKS_U1, covers the same two columns, providing an additional business-key constraint. Because the primary key combines two foreign keys, the heuristic Data Vault classification is link. Under that modeling convention, this table functions as a relationship (link) entity joining the expenditure type and system linkage hubs rather than storing descriptive history for either.

Key Information Stored

The table stores 25 documented columns. The most significant are the two key columns and the standard Oracle date and audit attributes.

• EXPENDITURE_TYPE — Foreign key to PA_EXPENDITURE_TYPES; identifies the expenditure type participating in the linkage.
• SYSTEM_LINKAGE_FUNCTION — Foreign key to PA_SYSTEM_LINKAGES; identifies the system linkage function assigned to that expenditure type.
• START_DATE_ACTIVE — First date on which the expenditure type/system-linkage association is effective.
• END_DATE_ACTIVE — Last date on which the association is effective; null indicates an open-ended association.
• LAST_UPDATE_DATE and LAST_UPDATED_BY — Standard audit fields capturing the most recent modification timestamp and user.
• CREATION_DATE and CREATED_BY — Standard audit fields recording initial row creation.
• LAST_UPDATE_LOGIN — The login session associated with the last update.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) columns allowing site-specific context and attribute data to be captured against each association.

The composite primary key (EXPENDITURE_TYPE, SYSTEM_LINKAGE_FUNCTION) is the surrogate identifier; the identical PA_EXPEND_TYP_SYS_LINKS_U1 unique index serves as the documented business-key candidate on the same pair of columns.

Common Use Cases and Queries

Typical use cases center on validating and reporting the permitted expenditure type/linkage combinations. A reporting query joining the base tables might read:

• Listing all linkage functions active for a given expenditure type: SELECT system_linkage_function FROM pa.pa_expend_typ_sys_links WHERE expenditure_type = :p_expend_type AND (end_date_active IS NULL OR end_date_active > SYSDATE);
• Producing an inventory of expenditure type/linkage pairings joined to descriptive names: SELECT l.expenditure_type, l.system_linkage_function FROM pa.pa_expend_typ_sys_links l, pa.pa_expenditure_types e WHERE l.expenditure_type = e.expenditure_type;
• Reviewing audit activity: filtering rows by LAST_UPDATE_DATE to identify recent configuration changes.
• Extracting DFF context values via ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for downstream reporting.

Because the table is tightly coupled to expenditure type and system linkage configuration, most operational consumption occurs indirectly through Oracle Projects setup and processing rather than through direct ad hoc access.

Related Objects

• PA_EXPENDITURE_TYPES — Parent table referenced by EXPENDITURE_TYPE; the master list of expenditure types.
• PA_SYSTEM_LINKAGES — Parent table referenced by SYSTEM_LINKAGE_FUNCTION; defines the available system linkage functions.
• PA_EXPEND_TYP_SYS_LINKS_PK — Primary key constraint on (EXPENDITURE_TYPE, SYSTEM_LINKAGE_FUNCTION).
• PA_EXPEND_TYP_SYS_LINKS_U1 — Unique index on the same two columns, enforcing the business-key candidate.
• Downstream Oracle Projects expenditure and interface processes that resolve expenditure type behavior by consulting the system linkage function associated here.