Search Results trx_hdr_table




Overview
Explore in AI Chat

Overview

JAI_OM_SHIP_AEL_V is an APPS-owned database view within the JA — Asia/Pacific Localizations product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented as the "Base view of OFI ship confirm UI," meaning it supplies the underlying row source for the Oracle Financials Intelligence (OFI) ship confirm accounting interface. Its central purpose is to present subledger accounting (SLA) and General Ledger journal information tied to outbound shipping transactions so that the ship confirm process can generate, review, and transfer accounting entries without querying the transactional tables directly.

The view consolidates data from Oracle Shipping (WSH), Order Management (OE), Receivables-related party tables (HZ), and the GL journal substrate. In operation it acts as a bridge between the operational ship confirm transaction and the accounting events that follow, exposing a uniform column contract — APPLICATION_ID, EVENT_TYPE, TRX_CLASS, TRX_HDR_ID, JE_HEADER_ID, and the debit/credit amounts — that downstream OFI reporting and the ship confirm UI consume.

Underlying Base Objects

The view is defined over a join of the following documented base objects:

The joins link party to customer account, customer account to the JAI delivery view's CUSTOMER_ID, order type to the transaction type translation, and delivery to its location and GL journal references.

Key Columns

Common Use Cases and Queries

Typical use is to resolve accounting entries for a shipment by delivery. The following returns journal lines for a given TRX_HDR_ID (delivery):

  • SELECT trx_hdr_id, je_header_id, je_line_num, je_source, entered_dr, entered_cr, accounted_dr, accounted_cr FROM jai_om_ship_ael_v WHERE trx_hdr_id = :p_delivery_id;
  • SELECT delivery_name, order_number, customer_name, gl_transfer_status FROM jai_om_ship_ael_v WHERE order_number = :p_order;
  • SELECT je_source, SUM(accounted_dr), SUM(accounted_cr) FROM jai_om_ship_ael_v GROUP BY je_source;

These support reconciliation of ship confirm accounting, verification of GL transfer status, and audit of India localization excise and receivables flows.