Results for “pa_transaction_sources”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_TRANSACTION_SOURCES is an Oracle Projects (PA) implementation table that defines the recognizable sources of imported expenditure transactions originating in external systems. Each row establishes a valid transaction source that controls how Oracle Projects processes, validates, accounts for, and posts imported transactions. It is owned by the PA schema and, in the documented 12.2.2 physical schema, contains 48 columns protected by the primary key constraint PA_TRANSACTION_SOURCES_PK on the TRANSACTION_SOURCE column.

Because it holds a stable, non-transactional set of descriptive attributes that downstream transactional tables reference by key, the heuristic Data Vault classification for this object is hub-leaning. In practice it functions as a reference and control table: it is the parent of several high-volume transaction and interface tables, and it participates in a foreign key relationship to PA_SYSTEM_LINKAGES through the SYSTEM_LINKAGE_FUNCTION column.

Key Information Stored

The unique business-key candidate documented in the metadata is PA_TRANSACTION_SOURCES_U1, defined on (TRANSACTION_SOURCE, ZD_EDITION_NAME). The primary identifier is TRANSACTION_SOURCE, which carries the implementation-defined source name. The most significant columns include:

• TRANSACTION_SOURCE — primary key; the implementation-defined name of the imported transaction source.
• SYSTEM_LINKAGE_FUNCTION — foreign key to PA_SYSTEM_LINKAGES, identifying the system linkage used when importing and processing this source.
• PREDEFINED_FLAG — indicates whether the source was seeded by Oracle rather than defined by the implementation.
• COSTED_FLAG — controls whether transactions from this source are costed.
• COST_BURDENED_FLAG and ALLOW_BURDEN_FLAG — govern burdening behavior for imported transactions.
• PURGEABLE_FLAG — determines whether interface rows for this source can be purged.
• START_DATE_ACTIVE and END_DATE_ACTIVE — bound the active date range of the source definition.
• GL_ACCOUNTED_FLAG — controls whether transactions are accounted to General Ledger.
• ALLOW_ADJUSTMENTS_FLAG, ALLOW_REVERSAL_FLAG, and ALLOW_EMP_ORG_OVERRIDE_FLAG — determine permissible adjustments, reversals, and employee-organization overrides.
• ALLOW_DUPLICATE_REFERENCE_FLAG and SKIP_TC_VALIDATION_FLAG — control duplicate-reference handling and validation bypass.
• MODIFY_INTERFACE_FLAG and MC_AMOUNTS_POPULATED — dictate interface modification and multi-currency amount population behavior.
• PRE_PROCESSING_EXTENSION and POST_PROCESSING_EXTENSION — hook names for custom client extensions around import processing.
• BATCH_SIZE, PROCESS_FUNDS_CHECK, CC_PROCESS_FLAG, and ACCT_SOURCE_CODE — control processing volume, funds checking, cost collection, and accounting source behavior.
• ZD_EDITION_NAME and the ATTRIBUTE1 through ATTRIBUTE15 columns — support editioning and implementation-defined descriptive attributes.

Common Use Cases and Queries

Implementers and administrators query this table to enumerate available transaction sources when configuring expenditure imports, and to verify flags before diagnosing why an import failed or was rejected. Reporting queries frequently join it to the interface table to summarize inbound volume by source.

• List active, non-predefined sources: select the source, linkage function, and active dates filtered by START_DATE_ACTIVE and END_DATE_ACTIVE.
• Audit configuration: retrieve COSTED_FLAG, GL_ACCOUNTED_FLAG, and PURGEABLE_FLAG for a specific TRANSACTION_SOURCE to confirm cost and accounting behavior.
• Reconciliation and volume reporting: aggregate PA_TRANSACTION_INTERFACE_ALL rows grouped by TRANSACTION_SOURCE with a join on the shared TRANSACTION_SOURCE column.
• Extension tracing: locate sources whose PRE_PROCESSING_EXTENSION or POST_PROCESSING_EXTENSION values are populated to identify custom processing logic.

Related Objects

PA_TRANSACTION_SOURCES serves as a parent reference for multiple Oracle Projects transaction objects. The documented foreign key relationships are:

• PA_SYSTEM_LINKAGES — referenced by PA_TRANSACTION_SOURCES.SYSTEM_LINKAGE_FUNCTION.
• PA_EXPENDITURE_GROUPS_ALL — references PA_TRANSACTION_SOURCES via TRANSACTION_SOURCE.
• PA_EXPENDITURE_ITEMS_ALL — references PA_TRANSACTION_SOURCES via TRANSACTION_SOURCE.
• PA_TRANSACTION_INTERFACE_ALL — references PA_TRANSACTION_SOURCES via TRANSACTION_SOURCE; this is the principal interface table for inbound imported transactions.