Results for “ra_cust_trx_gl_dist_all”

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

Overview

JAI_OPEN_API_PKG is a PL/SQL package that forms part of the Oracle E-Business Suite Financials for India (JAI) localization layer. Its principal business function is to provide programmatic functions that populate taxes from legacy systems into the Oracle Financials interface (OFI). The package header history indicates that it was created in March 2011 and subsequently enhanced through a series of bug fixes, including support for tax category preview in the Interface Tax Lines user interface and for Point of Taxation (POT) processing.

In the context of tax determination for external and service taxes, the package applies a POT rule: where the GL Date is earlier than the POT Date, accounting is derived from the Regime; otherwise, accounting is derived from the JAI Open API. This conditional accounting logic is central to how the package bridges legacy tax data with the Indian tax regime configuration in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes three procedures and functions:

• POPULATE_JAI_INTERFACE_LINES — Populates tax interface lines used to stage legacy tax information for import into Oracle Financials. It is the primary data-loading entry point of the package.
• PURGE_JAI_INTERFACE_LINES — Removes previously staged interface lines, supporting housekeeping and reprocessing of tax interface data.
• GET_EXTERNAL_DIST_ACCOUNT_CCID — Returns the distribution account CCID applicable to external transactions, used to derive the correct accounting distribution code combination during tax line population.

The package body also contains an internal procedure, mark_request_id, which stamps the concurrent request ID onto free interface lines in JAI_INTERFACE_LINES_ALL. Its logic updates rows where the request_id is null, scoping them by transaction type, organization, location, party, and transaction number range. This internal routine is not part of the documented public API surface.

Tables Accessed

The package reads and writes a broad set of EBS tables through APPS synonyms:

• JAI_CMN_TAXES_ALL, JAI_CMN_TAX_CTGS_ALL, JAI_CMN_TAX_CTG_LINES — Indian tax configuration, tax categories, and category lines used to resolve tax and accounting rules.
• JAI_INTERFACE_LINES_ALL — The staging table where legacy tax data is populated and purged.
• AP_CHECKS_ALL, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES, AP_INVOICE_LINES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_SCHEDULES_ALL — Payables documents and distributions from which source tax details and accounting distributions are derived.
• AR_PAYMENT_SCHEDULES_ALL — Receivables payment schedules referenced for customer transaction tax accounting.
• FND_CURRENCIES, GL_PERIOD_STATUSES — Currency and accounting period validation context.
• HZ_CUST_SITE_USES_ALL — Customer site usage information used to classify transactions.

Relating to the search term ra_cust_trx_gl_dist_all, the package does not directly reference the Receivables distributions table in the documented metadata; AR accounting context enters via AR_PAYMENT_SCHEDULES_ALL and the external distribution account resolution performed by GET_EXTERNAL_DIST_ACCOUNT_CCID.

Usage Notes

JAI_OPEN_API_PKG is referenced by five other packages, indicating it is invoked programmatically rather than directly by end users. It is typically called from concurrent programs and from the Interface Tax Lines user interface (notably for the tax category preview feature added under bug#11903425) and from custom integration code that migrates legacy Indian tax data into OFI. Because it is an API classified as OTHER, callers should invoke the documented procedures rather than rely on the internal mark_request_id routine. The request ID stamping behavior means the package is designed to run within a concurrent request context.