Results for “get_external_dist_account_ccid”

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

Overview

JAI_OPEN_API_PKG is a public PL/SQL package owned by APPS that provides an open import API for loading legacy tax data into Oracle Financials for India (OFI). The package header (jai_open_api.pls, version 120.4, dated 2011/06/30) declares the unit with AUTHID CURRENT_USER, indicating that all unqualified object references resolve under the privileges of the invoking schema rather than the package owner. As stated in the package comments, its purpose is "to import taxes from legacy system to OFI," making it the integration point between external or historical tax repositories and the JAI tax determination and interface schema.

The package maintains a set of global variables and constants that model the import lifecycle, including the module prefix JAI_OPEN_API_PKG, match-type constants such as MISCELLANEOUS, ITEM, and NOT_MATCHED, and process-state flags covering INITIALIZE, VALIDATION, POPULATION, CALCULATION, and ACCOUNTING phases. It also tracks import results through SUCCESS and FAILURE constants. Package-level variables such as GN_ORG_ID, GN_ORGANIZATIONID, and GN_LOCATION_ID carry organizational context across the import session.

Key Procedures and Functions

• POPULATE_JAI_INTERFACE_LINES — The primary import driver and the procedure most frequently referenced in search. It populates the JAI interface lines with tax data drawn from legacy sources, performing the mapping and validation needed before the standard JAI tax processing can consume the records.
• PURGE_JAI_INTERFACE_LINES — Removes previously staged interface lines, providing a cleanup mechanism for failed, repeated, or test import runs so that stale tax records are not reprocessed.
• GET_EXTERNAL_DIST_ACCOUNT_CCID — Resolves a distribution account code combination identifier (CCID) from external data, allowing legacy distribution accounts to be mapped to valid Oracle General Ledger accounting flexfield combinations during import.

Tables Accessed

The package reads and writes the JAI tax configuration and interface tables, including JAI_CMN_TAXES_ALL, JAI_CMN_TAX_CTGS_ALL, and JAI_CMN_TAX_CTG_LINES for tax and tax category definitions, and JAI_INTERFACE_LINES_ALL as the staging target for imported lines. Payables data is referenced through AP_INVOICES_ALL, AP_INVOICE_LINES, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_CHECKS_ALL, AP_PAYMENT_SCHEDULES_ALL, and AP_INVOICE_PAYMENTS_ALL to link tax lines to invoices, distributions, and payments. AR_PAYMENT_SCHEDULES_ALL supports receivables-side payment reference. FND_CURRENCIES validates currency codes, GL_PERIOD_STATUSES supplies period status (including the GL future status referenced in the package history) for accounting period checks, and HZ_CUST_SITE_USES_ALL provides customer site usage context.

Usage Notes

JAI_OPEN_API_PKG is typically invoked by custom import routines, concurrent programs, or data migration scripts rather than interactively, since it functions as a programmatic open API. The package history records enhancements for tax category preview in the Interface Tax Lines UI (bug#11903425) and the addition of the GL future period status constant (bug#11936390), confirming that it also supports the JAI interface tax lines user interface in Oracle EBS 12.1.1 and 12.2.2. Because it is referenced by five other packages, changes to its interfaces should be coordinated within the wider JAI integration landscape. Calls should establish organization and location context before invoking POPULATE_JAI_INTERFACE_LINES, and callers should invoke PURGE_JAI_INTERFACE_LINES for cleanup between runs.