Search Results ja_th_ar_tax_invoice




Overview
Explore in AI Chat

Overview

JA_TH_AR_TAX_INVOICE is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and documented in ETRM as valid. It is a Thailand-localization component (the JA_TH prefix denotes the Asia/Thailand regional layer) that supports tax invoice processing within Oracle Receivables. Its role is to validate transaction attributes and maintain the tax invoice numbering sequence required by Thai revenue regulations, ensuring that autoinvoice and related transaction flows apply valid dates and tax codes before a tax invoice is issued.

The package is classified as OTHER (that is, not a published public API). ETRM records three documented procedures and two referenced tables. It depends upon APPS.ARP_STANDARD, FND_DATE, FND_MESSAGE, JG_ZZ_AUTO_INVOICE, and itself, and it is referenced by one other database object, confirming it is invoked indirectly rather than called by external integrations.

Key Procedures and Functions

  • VALIDATE_TRX_DATE — Validates the transaction date associated with the Thai tax invoice. It ensures the date falls within the permitted reporting or fiscal period, so that an invoice cannot be issued with a date that violates Thai tax document sequencing rules. Date handling is supported by the FND_DATE dependency.
  • VALIDATE_TAX_CODE — Validates the tax code applied to the transaction line, confirming it is an appropriate Thai tax code for the tax invoice being generated. Errors are surfaced through FND_MESSAGE, allowing the calling process to raise a meaningful, translatable message.
  • UPDATE_LAST_ISSUED_DATE — Maintains the last issued date for the tax invoice series. This supports controlled, gap-free or sequentially auditable numbering required for Thai tax documents, updating the stored reference date that governs the next issuance.

Tables Accessed

  • RA_CUST_TRX_TYPES — Read to resolve the Receivables transaction type and class associated with the transaction being validated, since tax invoice behavior varies by transaction type.
  • RA_INTERFACE_LINES_GT — The AutoInvoice interface global temporary table, used to read the transaction lines being processed so that date and tax code validation applies to the correct inbound data set.

The package additionally relies on ARP_STANDARD for standard Receivables error and status handling, and on JG_ZZ_AUTO_INVOICE, the Thai/regional autoinvoice helper, indicating it is embedded in the regional AutoInvoice execution path rather than standalone.

Usage Notes

JA_TH_AR_TAX_INVOICE is not intended for direct invocation by custom code. It is called from within the Thailand-localized Receivables transaction and AutoInvoice flows, typically during import of transactions through RA_INTERFACE_LINES_GT and at the point of tax invoice generation from an Oracle Forms transaction window. Because ETRM lists it as OTHER and shows no external referencing objects beyond one dependent package, implementers should treat it as an internal localization routine: do not call its procedures directly, and instead exercise the standard Receivables and Thai localization functionality that triggers it. Any customization should be limited to configuration and extension points rather than modification of this package body.