Search Results jai_ap_etds_requests




Overview
Explore in AI Chat

Overview

The JAI_AP_ETDS_REQUESTS table is a core data repository within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a control and audit table for the Electronic Tax Deduction at Source (eTDS) reporting process, a critical statutory requirement in jurisdictions like India. The table's primary role is to persistently store the execution context and parameters for each instance of an eTDS report generation request. This ensures traceability, supports reprocessing, and provides a historical audit trail for compliance purposes, linking specific report batches to the organizational and system context in which they were created.

Key Information Stored

The table's structure is designed to capture the complete environment of an eTDS run. Its primary key, BATCH_ID, uniquely identifies each request batch. The table stores key parameters used to generate the report, including identifiers for the Legal Entity, Operating Unit, and Organization, which define the reporting entity's structure. It links to the Tax Authority and its Site via TAX_AUTHORITY_ID and TAX_AUTHORITY_SITE_ID, specifying the government body for the filing. Crucially, it integrates with the EBS concurrent processing framework by storing the REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID, connecting the batch to a specific execution of a concurrent program. Additional audit columns typically include creation dates and user identifiers, providing a full lifecycle record for each eTDS request.

Common Use Cases and Queries

This table is central to auditing, troubleshooting, and managing eTDS compliance reports. Common operational scenarios include tracking the status and history of eTDS filings, identifying batches processed for a specific legal entity or tax period, and investigating errors by joining to concurrent request details. A typical diagnostic query would join with FND_CONCURRENT_REQUESTS to assess run status and output files.

  • Sample Query: Find recent eTDS batches for a legal entity:
    SELECT req.batch_id, req.request_id, cr.request_date, cr.phase, cr.status
    FROM jai_ap_etds_requests req,
    fnd_concurrent_requests cr
    WHERE req.request_id = cr.request_id
    AND req.legal_entity_id = :p_legal_entity_id
    ORDER BY cr.request_date DESC;
  • Reporting Use Case: Generating a master list of all eTDS submissions for a fiscal year, including the associated operating unit and concurrent request details, for internal audit purposes.

Related Objects

The JAI_AP_ETDS_REQUESTS table maintains defined foreign key relationships with several fundamental EBS tables, establishing its role in the application's data model. These relationships are documented as follows: