Search Results ar_receivables_trx




Overview
Explore in AI Chat

Overview

APPS.CE_RECEIVABLE_ACTIVITIES_V is a read-only database view in the Oracle E-Business Suite Cash Management (CE) module. It exposes a filtered subset of the Oracle Receivables lookup table AR_RECEIVABLES_TRX, presenting only those receivable activity definitions that are eligible for use as cash-management activities — specifically the types MISCCASH (miscellaneous cash) and BANK_ERROR. The view is registered in the E-Business Suite Technical Reference Manual (ETRM) for release 12.2.2, and the same definition is valid in 12.1.1, where it is used to drive Cash Management reconciliation, bank statement line processing, and miscellaneous receipt workflows.

The user query term ar_receivables_trx reflects a common search pattern: analysts looking for the Receivables Activity table often arrive at this view because it is the Cash Management–facing projection of that table. Rather than querying AR_RECEIVABLES_TRX directly, the view applies business rules for activity type, status, effective dating, and multi-org security, making it the preferred access point for CE-related reporting and integrations.

Underlying Base Objects

The view is defined over the following documented objects:

  • AR_RECEIVABLES_TRX (SYNONYM) — the Receivables Activities table. It holds the master definition of each activity, including name, description, type, tax code, accounting set of books, organization, and date/status attributes.
  • MO_GLOBAL (PACKAGE) — provides the multi-org access control function MO_GLOBAL.CHECK_ACCESS(ORG_ID), which restricts returned rows to the operating units accessible in the current session.

The WHERE clause performs four filters: TYPE IN ('MISCCASH','BANK_ERROR') limits the activity types; NVL(STATUS,'A') = 'A' enforces active status; the START_DATE_ACTIVE / END_DATE_ACTIVE comparisons enforce effective dating against SYSDATE; and MO_GLOBAL.CHECK_ACCESS(ORG_ID) = 'Y' enforces operating-unit security.

Key Columns

  • RECEIVABLES_TRX_ID — the unique identifier of the receivable activity, sourced from ART.RECEIVABLES_TRX_ID.
  • NAME — the activity name presented to users in Cash Management and Receivables forms and reports.
  • DESCRIPTION — the descriptive text associated with the activity.
  • SET_OF_BOOKS_ID — identifies the accounting set of books (ledger) to which the activity belongs.
  • ASSET_TAX_CODE — the tax code applicability flag used when the activity is applied to asset transactions.
  • ORG_ID — the operating unit owning the activity; drives the multi-org security filter.

Common Use Cases and Queries

This view is typically used to build selection lists for miscellaneous cash and bank error activities during bank statement reconciliation, to validate activity IDs in interface imports, and to report on active cash-related activities by operating unit.

A representative query lists all accessible miscellaneous cash and bank error activities for the current session:

  • SELECT receivables_trx_id, name, description, set_of_books_id, asset_tax_code, org_id FROM apps.ce_receivable_activities_v ORDER BY name;
  • To locate a specific activity, filter on name or receivables_trx_id.
  • To validate an interface payload, join the view to a staging table on receivables_trx_id.

Because the view enforces effective dating and status internally, no additional date or status predicates are required. Underlying rows must be maintained in AR_RECEIVABLES_TRX; the view itself is not updateable.