Search Results okl_trx_csh_batch_b




Overview
Explore in AI Chat

Overview

The OKL_TRX_CSH_BATCH_B table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Leasing and Finance Management (OKL) product. It serves as the master table for storing header-level information for batches of manual cash receipts entered through the OKL module. A batch acts as a logical container, grouping individual cash receipt transactions for processing, control, and reporting purposes. Its primary role is to maintain the integrity and audit trail of cash application processes within the leasing and finance operations, ensuring that related receipts can be managed and reviewed as a single unit.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the structure and naming conventions of the table and its relationships indicate it holds critical batch header attributes. The primary key column is ID, which uniquely identifies each cash receipt batch. Based on its function and related objects, the table likely stores control information such as batch creation date, batch status (e.g., 'Open', 'Posted', 'Cancelled'), batch total amount, the user who created the batch, and a batch name or number for identification. This data is essential for tracking the lifecycle of a group of cash receipts from entry through to final posting.

Common Use Cases and Queries

The primary use case is the management and inquiry of manual cash receipt batches. Users typically interact with this data via the OKL application interface to create, review, or post batches. Common reporting needs include listing all open batches for a given period or user, reconciling batch totals against the sum of its constituent receipts, and auditing batch processing history. A fundamental query pattern involves joining the batch header to its detailed receipt lines to analyze batch composition.

SELECT btc.id BATCH_ID,
       btc.batch_name,
       btc.batch_date,
       btc.status_code,
       SUM(rcv.amount) total_receipt_amount
FROM okl_trx_csh_batch_b btc,
     okl_trx_csh_receipt_b rcv
WHERE btc.id = rcv.btc_id
AND btc.creation_date > SYSDATE - 30
GROUP BY btc.id, btc.batch_name, btc.batch_date, btc.status_code;

Related Objects

The OKL_TRX_CSH_BATCH_B table has defined foreign key relationships with other critical OKL transaction tables, as documented in the ETRM.

  • OKL_TRX_CSH_RECEIPT_B: This is the primary child table, storing the individual cash receipt lines. The relationship is established via the foreign key column OKL_TRX_CSH_RECEIPT_B.BTC_ID referencing the batch ID. This links a batch header to all its detailed receipt transactions.
  • OKL_TXL_CNTRCT_LNS: This table, which handles contract line transactions, also references the batch via the foreign key column OKL_TXL_CNTRCT_LNS.BTC_ID. This relationship likely ties the cash receipt batch to specific contract line-level accounting or adjustment entries generated during the cash application process.