Search Results pon_emd_transactions

Overview

PON_EMD_TRANSACTIONS is a Sourcing (PON) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores Earnest Money Deposit (EMD) transaction records associated with sourcing auctions and negotiations. In Oracle Sourcing, buyers frequently require suppliers to submit an EMD — a monetary instrument such as a bank guarantee, demand draft, cheque, credit card authorization, or cash deposit — to confirm serious bidding intent. This table captures each such instrument as a discrete transaction row, tracking its amount, currency, type, submission status, and downstream posting to Oracle Receivables or Finance.

The table is owned by the PON schema and, in the documented 12.2.2 physical schema, contains 73 columns. Its primary key is EMD_TRANSACTION_ID, enforced through EMD_TRANSACTION_ID_PK1. A foreign key on AUCTION_HEADER_ID references PON_AUCTION_HEADERS_ALL, anchoring every EMD transaction to a specific auction or negotiation header. Based on the foreign-key structure and the presence of multi-version or workflow attributes, a heuristic Data Vault classification suggests a satellite-leaning profile, meaning the table is best modeled as descriptive, attribute-rich context attached to a parent auction hub, rather than as a central hub or an associative link.

Key Information Stored

The most significant columns fall into identifying, financial, instrument, and status categories:

EMD_TRANSACTION_ID — the surrogate primary key (EMD_TRANSACTION_ID_PK1) uniquely identifying each EMD transaction row.
EMD_TRANSACTION_GROUP_ID and PARENT_EMD_TRANSACTION_ID — grouping and hierarchical linkage, supporting multi-instrument or superseded transaction scenarios.
AUCTION_HEADER_ID — the foreign key to PON_AUCTION_HEADERS_ALL; the business association tying the deposit to its auction.
DOCUMENT_NUMBER and SUPPLIER_SEQUENCE — the business-facing identifier and bidder sequencing, common business-key candidates alongside AUCTION_HEADER_ID.
TRANSACTION_TYPE_CODE, PAYMENT_TYPE_CODE, and STATUS_LOOKUP_CODE — classify the transaction nature, payment instrument, and workflow status.
TRANSACTION_DATE, TRANSACTION_CURRENCY_CODE, AMOUNT, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, and EXCHANGE_DATE — capture the monetary value, currency, and currency conversion context.
ORG_ID — the operating unit, enabling multi-org security and reporting.
POSTED_TO_FINANCE and CUST_TRX_ID/CUST_TRX_NUMBER — indicate whether the deposit was posted and link to the resulting Receivables transaction.
DOCUMENT_SUBMITTED, DELETE_FLAG, CURRENT_ROW_FLAG, and ERROR_MESSAGE — lifecycle and error-handling controls.
Instrument-specific columns such as BANK_NAME, BANK_GURANTEE_NUMBER, CREDIT_CARD_NUM, CHEQUE_NUMBER, and DEMAND_DRAFT_NUM capture the physical payment details.
Who-columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE) and the ATTRIBUTE1–15 flexible fields support auditing and extensibility.

Common Use Cases and Queries

Typical use cases include auditing supplier EMD compliance per auction, reconciling deposits posted to Receivables, and reporting outstanding or forfeited deposits.

List all EMD transactions for an auction: SELECT emd_transaction_id, document_number, amount, status_lookup_code FROM pon_emd_transactions WHERE auction_header_id = :auction_id AND delete_flag = 'N';
Identify deposits not yet posted to Finance: SELECT emd_transaction_id, auction_header_id, amount FROM pon_emd_transactions WHERE posted_to_finance = 'N' AND org_id = :org_id;
Reconcile to Receivables by joining on CUST_TRX_ID.
Analyze EMD amounts by currency and payment type using TRANSACTION_CURRENCY_CODE and PAYMENT_TYPE_CODE.

Related Objects

PON_AUCTION_HEADERS_ALL — parent auction header; joined via AUCTION_HEADER_ID.
PON_AUCTION_BIDDERS_ALL, PON_AUCTION_SUPPLIERS_ALL — supplier participation context.
RA_CUSTOMER_TRX_ALL / RA_CUSTOMER_TRX_LINES_ALL — join via CUST_TRX_ID and CUST_TRX_LINE_ID for finance posting reconciliation.
FND_LOOKUPS — resolves STATUS_LOOKUP_CODE and TRANSACTION_TYPE_CODE.
HR_ALL_ORGANIZATION_UNITS — resolves ORG_ID for multi-org reporting.
Sourcing auction public APIs and concurrent programs that create and update EMD transaction records.

Table: PON_EMD_TRANSACTIONS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_EMD_TRANSACTIONS, object_name:PON_EMD_TRANSACTIONS, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_EMD_TRANSACTIONS ,
SYNONYM: APPS.PON_EMD_TRANSACTIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_EMD_TRANSACTIONS, status:VALID,
VIEW: PON.PON_EMD_TRANSACTIONS# 12.2.2
owner:PON, object_type:VIEW, object_name:PON_EMD_TRANSACTIONS#, status:VALID,
APPS.PON_EMD_AR_INTEGRATION_GRP SQL Statements 12.2.2
VIEW: PON.PON_EMD_TRANSACTIONS# 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.PON_EMD_AR_INTEGRATION_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_EMD_AR_INTEGRATION_GRP, status:VALID,
PACKAGE BODY: APPS.PON_BID_VALIDATIONS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_BID_VALIDATIONS_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
Table: PON_AUCTION_HEADERS_ALL 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_HEADERS_ALL, object_name:PON_AUCTION_HEADERS_ALL, status:VALID, product: PON - Sourcing , description: Stores the negotiations header level details. , implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL ,
PACKAGE BODY: APPS.PON_PRINTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_PRINTING_PKG, status:VALID,
PACKAGE BODY: APPS.PON_EMD_AR_INTEGRATION_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_EMD_AR_INTEGRATION_GRP, status:VALID,
PACKAGE BODY: APPS.PON_AUCTION_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AUCTION_PKG, status:VALID,
TABLE: PON.PON_EMD_TRANSACTIONS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_EMD_TRANSACTIONS, object_name:PON_EMD_TRANSACTIONS, status:VALID,
APPS.PON_PRINTING_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.PON_PRINTING_PKG 12.2.2
APPS.PON_AUCTION_PKG dependencies on PON_EMD_TRANSACTIONS 12.2.2
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_EMD_TRANSACTIONS 12.2.2
APPS.PON_PRINTING_PKG dependencies on PON_EMD_TRANSACTIONS 12.2.2
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_EMD_TRANSACTIONS 12.2.2
APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_EMD_TRANSACTIONS 12.2.2
PACKAGE BODY: APPS.PON_EMD_AR_INTEGRATION_GRP 12.2.2
PACKAGE: APPS.PON_EMD_AR_INTEGRATION_GRP 12.2.2
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on FND_GLOBAL 12.2.2
APPS.PON_PRINTING_PKG dependencies on FND_LOOKUP_VALUES 12.2.2
APPS.PON_PRINTING_PKG dependencies on IBY_CREDITCARD 12.2.2
APPS.PON_AUCTION_PKG SQL Statements 12.2.2
APPS.PON_PRINTING_PKG dependencies on PON_BIDDING_PARTIES 12.2.2
APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BIDDING_PARTIES 12.2.2
APPS.PON_PRINTING_PKG dependencies on PON_AUC_DOCTYPES 12.2.2
APPS.PON_PRINTING_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL 12.2.2
eTRM - PON Tables and Views 12.2.2
description: Holds the debug statements for workflow processes ,
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on AP_SUPPLIERS 12.2.2
APPS.PON_PRINTING_PKG dependencies on HR_ALL_ORGANIZATION_UNITS 12.2.2
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_BIDDING_PARTIES 12.2.2
APPS.PON_PRINTING_PKG dependencies on FND_LOOKUPS 12.2.2
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_AUCTION_HEADERS_ALL 12.2.2
APPS.PON_PRINTING_PKG dependencies on PON_AUCTION_HEADERS_ALL 12.2.2
APPS.PON_BID_VALIDATIONS_PKG SQL Statements 12.2.2
APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BID_HEADERS 12.2.2
PACKAGE BODY: APPS.PON_BID_VALIDATIONS_PKG 12.2.2
APPS.PON_BID_VALIDATIONS_PKG dependencies on FND_MESSAGE 12.2.2
APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on FND_API 12.2.2
eTRM - PON Tables and Views 12.2.2
description: Holds the debug statements for workflow processes ,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PON_AUCTION_PKG 12.2.2