Results for “threshold_grp_id”
50+ 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:
- INVOICE_ID — references AP_INVOICES_ALL and identifies the cancelled invoice whose TDS is being reversed.
- TAX_ID — references JAI_CMN_TAXES_ALL and identifies the specific TDS tax from which the deduction was taken.
- THRESHOLD_GRP_ID — references JAI_AP_TDS_THHOLD_GRPS and links the cancel event to the threshold group governing cumulative TDS accumulation.
- PARENT_THRESHOLD_TRX_ID — references JAI_AP_TDS_THHOLD_TRXS, tying the cancellation back to the original threshold transaction that recorded the deduction.
- CANCEL_AMOUNT — the monetary value of TDS being reversed.
- THRESHOLD_TRX_ID_CANCEL — the threshold transaction identifier generated specifically for the cancel processing.
- TDS_INVOICE_FLAG and TDS_INVOICE_MESSAGE — indicate whether the invoice itself was flagged during cancel and carry the engine's diagnostic message.
- TDS_CREDIT_MEMO_FLAG and TDS_CREDIT_MEMO_MESSAGE — equivalent indicators for credit memo handling during the cancellation.
- TDS_SECTION_CODE and TAX_CATEGORY_ID — the statutory section under which TDS was deducted and the tax category classification.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — standard WHO audit columns and optimistic locking support.
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.
-
Stores details of TDS Cancel processing when an invoice having TDS is cancelled.
-
Stores details of all the TDS taxes that are applicable on an invoice.
-
Stores details of TDS Cancel processing when an invoice having TDS is cancelled.
-
This table stores TDS repository information
-
Storesdetails of all transactions where TDS invoices have been generated.
-
Stores the details current threshold position for a threshold group.
-
This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
-
Stores details of all the TDS taxes that are applicable on an invoice.
-
Stores the details current threshold position for a threshold group.
-
This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
-
Storesdetails of all transactions where TDS invoices have been generated.