Results for “cancel_amount”

16 results




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

Overview

JAI_AP_TDS_INV_CANCELS is a transactional table owned by the JA schema and delivered as part of the Asia/Pacific Localizations product in Oracle E-Business Suite 12.1.1 and 12.2.2. The table records the details of Tax Deducted at Source (TDS) cancel processing that occurs when an Accounts Payable invoice carrying TDS is cancelled. In the Indian localizations and other APAC compliance flows, TDS withholding must be reversed in a controlled and auditable manner when an invoice is voided or cancelled; this table captures the resulting cancel event, the amount involved, and the messages or flags returned by the TDS engine during the reversal.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is best modeled as a link table. It does not represent a standalone business concept; rather, it associates an AP invoice, a TDS tax, a threshold group, and a parent threshold transaction into a single cancellation event. A Data Vault implementation would place JAI_AP_TDS_INV_CANCELS at the intersection of those references, with the cancellation identifier acting as the link key.

Key Information Stored

The primary key of the table is JAI_AP_TDS_INV_CANCELS_PK, defined on the surrogate column TDS_INV_CANCEL_ID. This column is the value most commonly searched by developers and support analysts, and it uniquely identifies each TDS cancel record. It is a surrogate key rather than a business key; no alternate unique index on business columns is documented in the ETRM metadata.

The business context is supplied through the foreign key columns:

Common Use Cases and Queries

The most frequent access pattern is retrieval of cancel records for a specific invoice or tax, typically during reconciliation of AP subledger entries against TDS withholding reports. A typical query joins the table back to AP_INVOICES_ALL:

  • SELECT c.tds_inv_cancel_id, c.invoice_id, i.invoice_num, c.cancel_amount FROM ja.jai_ap_tds_inv_cancels c, ap.ap_invoices_all i WHERE c.invoice_id = i.invoice_id AND i.invoice_num = :invoice_num;
  • Reporting of TDS reversed by tax and section for a given period, aggregating CANCEL_AMOUNT grouped by TAX_ID and TDS_SECTION_CODE.
  • Diagnostic investigation when cancellation fails or produces unexpected results, reading TDS_INVOICE_MESSAGE and TDS_CREDIT_MEMO_MESSAGE.
  • Reconciling threshold transaction balances by tracing PARENT_THRESHOLD_TRX_ID to JAI_AP_TDS_THHOLD_TRXS.

Related Objects

The following objects participate in documented relationships with JAI_AP_TDS_INV_CANCELS:

  • AP_INVOICES_ALL — joined on INVOICE_ID; the source invoice being cancelled.
  • JAI_CMN_TAXES_ALL — joined on TAX_ID; the TDS tax definition.
  • JAI_AP_TDS_THHOLD_GRPS — joined on THRESHOLD_GRP_ID; the threshold group master.
  • JAI_AP_TDS_THHOLD_TRXS — joined on PARENT_THRESHOLD_TRX_ID; the originating threshold transaction.
  • JAI_AP_TDS_INV_CANCELS_PK — the primary key index supporting lookups by TDS_INV_CANCEL_ID.

These relationships make the table a pivotal link between payables invoice data and the APAC TDS withholding infrastructure, and any purge or archival routine must account for its dependencies before deleting cancel history records.