Search Results iby_trxn_core




Overview
Explore in AI Chat

Overview

IBY_TRXN_CORE is a core payment-instrument transaction table owned by the IBY (Payments) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the low-level transaction detail captured during payment processing — authorization results, terminal and trace identifiers, point-of-sale data, cardholder or instrument-owner attributes, and security-segment references. The table carries 50 documented columns and is validated in the ETRM 12.2.2 release.

From a Data Vault modeling perspective, the mined FK structure classifies IBY_TRXN_CORE as satellite-leaning. This is a heuristic suggestion rather than a database constraint: the object holds descriptive, transaction-scoped attributes that cluster around a primary transactional hub (IBY_TRXN_SUMMARIES_ALL), making it a natural candidate for a satellite table in a Data Vault design rather than a standalone hub or link.

Key Information Stored

The surrogate primary key is TRXNMID, enforced by the constraint IBY_TRXN_CORE_PK and backed by the unique index IBY_TRXN_CORE_TRXNMID_U1. TRXNMID is also the sole business-key candidate identified in the documentation, and it doubles as the foreign key joining this table to IBY_TRXN_SUMMARIES_ALL. The most significant descriptive columns include:

Common Use Cases and Queries

The table is most often queried for payment authorization reporting, fraud/AVS review, and POS reconciliation. A typical join pattern resolves transaction-level detail to its summary record:

  • Reconcile authorizations by trace number: SELECT s.TRXNMID, s.TOTAL, c.AUTHCODE, c.TRACENUMBER FROM IBY_TRXN_SUMMARIES_ALL s, IBY_TRXN_CORE c WHERE s.TRXNMID = c.TRXNMID.
  • AVS/CVV review reporting: SELECT TRXNMID, AVSCODE, CVV2RESULT FROM IBY_TRXN_CORE WHERE AVSCODE NOT IN ('Y','M').
  • POS analytics grouping by POS_ENTRY_METHOD_CODE or POS_READER_CAPABILITY_CODE to assess capture channels.
  • Security-scoped extraction using SECURITY_GROUP_ID to honor multi-org data access rules.

Because the table carries owner PII and card data, queries should observe IBY payment-security policies and any data-masking views layered over it.

Related Objects

The following objects are most directly related, based on documented FK/PK relationships:

  • IBY_TRXN_SUMMARIES_ALL — Parent summary table joined via IBY_TRXN_CORE.TRXNMID.
  • IBY_SECURITY_SEGMENTS — Referenced twice, via CHNAME_SEC_SEGMENT_ID and EXPIRY_SEC_SEGMENT_ID, for encrypted cardholder-name and expiry tokenization.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for multi-org security enforcement.
  • IBY_TRXN_CORE_PK / IBY_TRXN_CORE_TRXNMID_U1 — Primary-key constraint and unique index on TRXNMID.

Together these objects form the transactional spine through which IBY payment instrument data is stored, secured, and reported in EBS 12.1.1 and 12.2.2.