Results for “ce_misc_transactions_v”

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

Overview

CE_MISC_TRANSACTIONS_V is an APPS-owned database view within the Cash Management (CE) product of Oracle E-Business Suite, documented as VALID and marked "Retrofitted" in the ETRM repository for releases 12.1.1 and 12.2.2. The view consolidates miscellaneous cash receipt transactions — receipts not tied to a standard receivables activity — together with their bank account, receipt method, currency, exchange rate, tax, and posting context. It provides a denormalized read model over the Receivables cash receipt tables and the Cash Management bank account configuration tables, allowing Cash Management reconciliation, bank statement matching, and miscellaneous receipt inquiry forms and reports to retrieve a miscellaneous transaction through a single object rather than joining the underlying AR and CE tables directly. Because the view is retrofitted, it exists in both the 12.1.1 and 12.2.2 code lines with equivalent semantics, and it is referenced programmatically by Cash Management application logic. The column MISC_PAYMENT_SOURCE, surfaced directly from AR_CASH_RECEIPTS_ALL, is one of the distinguishing attributes of these transactions and is frequently the target of user searches such as "misc_payment_source."

Underlying Base Objects

The view is defined over the following documented base objects: AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_LOOKUPS, AR_RECEIPT_METHODS, AR_RECEIVABLES_TRX_ALL, CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_OU_V, CE_SYSTEM_PARAMETERS, GL_DAILY_CONVERSION_TYPES, GL_SETS_OF_BOOKS, and ZX_SCO_RATES, with the CE_AUTO_BANK_MATCH package invoked in the SELECT list. AR_CASH_RECEIPTS_ALL supplies the core receipt row (receipt number, type, receivables transaction, receipt method, VAT tax, document sequence, reference type, miscellaneous payment source, comments, and audit columns). AR_CASH_RECEIPT_HISTORY_ALL supplies the transaction date, GL date, currency, exchange rate type and rate, amount, accounted amount, and GL posting status. CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_OU_V provide the bank account, branch, account number, and currency, while CE_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS link the operating unit to its set of books and legal entity. AR_RECEIVABLES_TRX_ALL, AR_RECEIPT_METHODS, and AR_LOOKUPS supply descriptive names and lookup meanings, and GL_DAILY_CONVERSION_TYPES and ZX_SCO_RATES supply conversion type and tax rate information. The joins are largely outer joins, which preserves miscellaneous receipts that lack a matching lookup, conversion type, or tax rate.

Key Columns

• CASH_RECEIPT_ID — primary identifier of the miscellaneous receipt.
• MISC_PAYMENT_SOURCE — the source of the miscellaneous payment, exposed directly from AR_CASH_RECEIPTS_ALL.
• TYPE — receipt type classification for the transaction.
• RECEIPT_NUMBER, RECEIPT_DATE, TRX_DATE, GL_DATE — identifying and accounting dates.
• CURRENCY_CODE and the DECODE expression — classifies the receipt currency as FUNCTIONAL, BANK, or FOREIGN relative to the set of books and bank account.
• EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_DATE, USER_CONVERSION_TYPE — currency conversion context, with the rate inverted when CE_AUTO_BANK_MATCH.GET_INVERSE_RATE returns 'Y'.
• AMOUNT and the DECODE expression — the entered amount and the derived accounted amount in functional currency.
• BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, BANK_BRANCH_ID, CURRENCY_CODE (bank) — bank account identification.
• RECEIPT_METHOD_ID, RECEIVABLES_TRX_ID, VAT_TAX_ID, TAX_RATE_CODE, DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE — receipt method, receivables transaction, tax, and document sequence attributes.
• GL_POSTED_DATE and the posting flag — indicates whether the receipt has been posted to the General Ledger.
• ORG_ID — operating unit, the primary multi-org security column.

Common Use Cases and Queries

Typical uses include miscellaneous receipt inquiry by payment source, bank reconciliation of unapplied or miscellaneous receipts, and extraction of miscellaneous transactions for reporting or integration. Queries should always be constrained by ORG_ID to respect operating unit security.

• List miscellaneous receipts for a specific payment source and operating unit:
  SELECT cash_receipt_id, receipt_number, misc_payment_source, amount, currency_code, trx_date, gl_date, gl_posted_date FROM ce_misc_transactions_v WHERE org_id = :p_org_id AND misc_payment_source = :p_source;
• Identify unposted miscellaneous receipts: filter on the posting flag derived from GL_POSTED_DATE being NULL, for example WHERE gl_posted_date IS NULL.
• Reconcile receipts against a bank account: join BANK_ACCOUNT_ID to CE_BANK_ACCOUNTS or bank statement tables, selecting BANK_ACCOUNT_NUM, currency, and accounted amount.
• Report foreign-currency miscellaneous receipts by selecting the currency classification expression and the exchange rate columns.