Search Results pon_emd_fin_parameters_all

Overview

PON_EMD_FIN_PARAMETERS_ALL is a transactional configuration table in the Oracle E-Business Suite Sourcing (PON) module. It stores the financial integration parameters that govern how Earnest Money Deposit (EMD) transactions are processed through Oracle Receivables and related financial subsystems during sourcing negotiations. The table is owned by the PON schema and is classified as VALID in Oracle EBS releases 12.1.1 and 12.2.2.

The table is multi-organization enabled, as evidenced by the presence of the ORG_ID column, meaning records are partitioned by operating unit context. From a heuristic Data Vault modeling perspective, this object is best characterized as a standalone structure — it neither functions as a pure hub (no independent business key generating entities) nor as a strict satellite, but rather holds configuration attributes that map an organization's EMD process to specific Receivables transaction types, batch sources, memo lines, and bank accounts. Its single documented outbound foreign key to AR_MEMO_LINES_ALL_B confirms the linkage into the Receivables memo-line infrastructure.

Key Information Stored

The table contains 21 documented columns. The most operationally significant include:

• EMD_FIN_PARAMETERS_KEY / EMD_FIN_PARAMETERS_ID — the surrogate primary key pair uniquely identifying each parameter record.
• ORG_ID — the operating unit that owns the parameter setup.
• RA_TRX_TYPE_ID — the Receivables transaction type used when generating EMD-related invoices or credit memos.
• RA_BATCH_SOURCE_ID and RA_IMPORT_BATCH_SOURCE_ID — batch sources controlling how EMD transactions are imported into Receivables.
• MEMO_LINE_ID and MEMO_LINE_INVOICE_ID — references to memo lines applied to EMD invoices; MEMO_LINE_ID is the documented foreign key to AR_MEMO_LINES_ALL_B.
• PAYMENT_TERMS_ID — payment terms governing EMD settlement.
• CORPORATE_EMD_BANK_ACCOUNT — the internal bank account designated for corporate EMD collections.
• DEFAULT_EMD_AMOUNT — the default monetary value applied when an EMD is required.
• EXCHANGE_RATE_TYPE — the rate type used for currency conversion of EMD amounts.
• EMD_FINANCE_INTEGRATION — the flag or mode indicating whether financial integration is active for the org.
• Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID, PROGRAM_UPDATE_DATE) provide WHO-columns and concurrent-program traceability.

Common Use Cases and Queries

The table is typically queried when diagnosing EMD financial postings or validating organization-level sourcing configuration. A common pattern retrieves active parameters for a specific operating unit:

SELECT emd.emd_fin_parameters_id,
       emd.org_id,
       emd.ra_trx_type_id,
       emd.default_emd_amount,
       emd.corporate_emd_bank_account
FROM   pon.pon_emd_fin_parameters_all emd
WHERE  emd.org_id = :p_org_id;

Reporting use cases include auditing EMD defaults across operating units, verifying that the correct Receivables transaction type is configured before opening a negotiation, and reconciling memo lines applied to EMD invoices. Analysts frequently join to AR_MEMO_LINES_ALL_B on MEMO_LINE_ID to resolve memо line descriptions, and to RA_CUST_TRX_TYPES_ALL via RA_TRX_TYPE_ID for transaction type naming.

Related Objects

• AR_MEMO_LINES_ALL_B — joined on MEMO_LINE_ID; the sole documented foreign key target.
• RA_CUST_TRX_TYPES_ALL — joined on RA_TRX_TYPE_ID for transaction type detail.
• RA_BATCH_SOURCES_ALL — joined on RA_BATCH_SOURCE_ID and RA_IMPORT_BATCH_SOURCE_ID.
• RA_TERMS — joined on PAYMENT_TERMS_ID for payment term definitions.
• PON_EMD_ITEMS_ALL — sibling EMD configuration table for item-level EMD rules.
• PON_NEGOTIATIONS_ALL — negotiation records that consume these EMD parameters.
• AR_BANK_ACCOUNTS_ALL — resolves CORPORATE_EMD_BANK_ACCOUNT.
• HR_OPERATING_UNITS — joined on ORG_ID for organizational context.