Search Results yearly_returns

Overview

APPS.JAI_ETCS_PKG is an Oracle E-Business Suite PL/SQL package that implements Tax Collection at Source (TCS) processing within the Receivables module for Indian localizations. The package was originally created by CSahoo on 01-FEB-2007 under enhancement bug 5631784, and represents a forward port of 11i bug fix 4742259 titled "Tax Collection at Source in Receivables." Its principal business responsibility is the generation of statutory TCS return files in the fixed-width electronic formats mandated by the Indian Income Tax Department, together with the supporting file-handling operations required to write those returns to disk.

In Oracle EBS Release 12.1.1, the 11i code base was forward ported with the legal entity identifier retained in the package logic. Change history entry 120.2, contributed by sacsethi on 26.06.2007 under bug 6153881, records a correction for the R12RUP03-ST1 issue in which TCS return reports failed to run. The documented solution removed the legal_entity_id reference from the code, in accordance with R12 standards prohibiting the direct use of legal entity identifiers in outbound file generation logic. The package is classified as OTHER in the ETRM repository, indicating it is not an AD_DICTIONARY-visible public API but an internal localization utility.

Key Procedures and Functions

The package exposes seven documented procedures and functions. Because it is an internal utility rather than a published API, parameter lists are not part of the documented interface.

• OPENFILE — Establishes the output file handle used for subsequently writing a return extract to the file system.
• CLOSEFILE — Closes the active file handle and completes the physical write of the generated return.
• CREATE_FH — Creates the file header record for an ETCS return. The package source declares positional width constants for the header layout, including line number (9), record type (2), file type (3), upload type (1), file sequence number (9), deductor TAN (10), and number of batches (9).
• CREATE_QUARTERLY_FH — Builds the quarterly file header variant, applying the same header structure to quarterly filing frequencies.
• GENERATE_ETCS_RETURNS — The principal driver procedure, orchestrating retrieval of TCS transaction data and production of the return file content, including challan detail and deductee detail segments.
• YEARLY_RETURNS — Produces the annual TCS return, aggregating collection data for the full financial year.
• QUARTERLY_RETURNS — Produces the quarterly TCS return, aggregating collection data for the applicable quarter.

The source additionally declares formatting variables such as v_pad_date, v_pad_char, v_pad_number, and v_underline_char, and fixed column widths for challan detail (batch number, challan serial number, section, amounts deducted, surcharge, cess, TCS, cheque/DD number, challan number, bank branch code, TDS deposit book entry) and deductee detail (serial number, section, deductee code, PAN, and name).

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• JAI_AR_ETCS_T — The primary Indian localization TCS transaction table, holding the receivables-side tax collection at source records extracted into returns.
• AR_CASH_RECEIPTS — Source of receipt-level data used to identify TCS-relevant collections and challan information.
• HZ_CUST_ACCOUNTS and HZ_PARTIES — Provide deductee identity, including PAN-related and name information for the deductee detail records.
• HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, HR_ORGANIZATION_INFORMATION — Supply deductor organization and location attributes embedded in return headers.
• GL_PERIODS and GL_PERIOD_SETS — Used to resolve accounting period ranges for quarterly and yearly return selection.
• FND_FLEX_VALUE_SETS — Supports value set lookups for TCS sections and related classifications.
• JAI_AP_ETDS_T and JAI_AP_ETDS_T_S — Shared localization TDS/TCS detail tables available to the return generation logic.
• JAI_AP_ETDS_REQUESTS and JAI_AP_ETDS_ERRORS_T — Request tracking and error logging for the return generation process.
• JAI_AP_RGM_PAYMENTS — Payment detail used in reconciling deducted amounts reported in the return.

Usage Notes

JAI_ETCS_PKG is invoked through Indian localization concurrent programs rather than through an open API. The ETRM metadata records zero referencing packages, confirming that it is a top-level driver rather than a shared library. The YEARLY_RETURNS and QUARTERLY_RETURNS procedures are typically called from concurrent program definitions that produce the annual and quarterly TCS statement files, with the CREATE_FH or CREATE_QUARTERLY_FH routine invoked first to emit the file header, GENERATE_ETCS_RETURNS performing the extract, and OPENFILE/CLOSEFILE bracketing the physical write.

The fixed-width constants defined in the specification indicate the output conforms to the Income Tax Department's prescribed e-filing layout and should not be altered without corresponding changes to the receiving utility. The removal of legal_entity_id in file version 120.2 means that any custom code that previously passed or relied on that identifier must be adjusted for R12. Because the package is not registered as a public API, direct custom calls should be avoided in favour of the delivered concurrent programs.