Results for “set_rec”

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

Overview

JAI_RGM_GST_ACCOUNTING_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Goods and Services Tax (GST) accounting for the India localization (JAI — Java-based India Applications) within the Oracle Financials and Order Management flows. Its name indicates it belongs to the RGM (Registrations and GST Management) module, handling the accounting and repository processing of GST transaction records. In Oracle EBS 12.1.1 and 12.2.2, India GST localization relies on a set of JAI packages that capture tax registration details, transaction records, and then translate those into accounting entries for the General Ledger.

This package is classified with API classification OTHER. It is not a general-purpose public API in the traditional sense, but rather an internal processing package invoked by sibling JAI packages. The ETRM metadata records only two documented procedures, CREATE_REPOSITORY_ENTRY and CREATE_GL_ENTRY, which together reflect the two-stage design: first populating a repository of GST transaction data, then generating the corresponding General Ledger interface entries.

Key Procedures and Functions

The documented metadata lists two procedures for JAI_RGM_GST_ACCOUNTING_PKG:

• CREATE_REPOSITORY_ENTRY — Responsible for creating the repository entry that captures GST-related transaction data into the RGM repository tables. It is the first stage in the accounting pipeline, ensuring the GST-relevant details are staged before GL accounting is derived.
• CREATE_GL_ENTRY — Responsible for creating the General Ledger entry, translating the staged GST repository records into rows suitable for the GL interface, enabling subsequent posting to the General Ledger.

No parameter lists are documented in the ETRM metadata for either procedure, and no parameters are inferred here. Both are treated as internal building blocks invoked in sequence by higher-level JAI processing packages.

Tables Accessed

The documented tables referenced via APPS synonyms are:

• JAI_RGM_DEFINITIONS — Stores GST definition/configuration data that drives how registrations and transactions are treated for accounting.
• JAI_RGM_REGISTRATIONS — Holds GST registration information for the organization or legal entity, used to determine the applicable tax registration context.
• JAI_RGM_TRX_RECORDS and JAI_RGM_TRX_RECORDS_S — The GST transaction records and their sequence/supporting table, which form the repository populated by CREATE_REPOSITORY_ENTRY.
• GL_INTERFACE — The Oracle GL open interface table, populated by CREATE_GL_ENTRY so that GST accounting lines can be imported and posted into the General Ledger.
• FND_CURRENCIES — Provides currency definitions used to resolve currency codes and precision during accounting entry construction.
• HR_ORGANIZATION_INFORMATION — Supplies organization/legal entity attributes (such as registration- or tax-relevant organization details) needed to derive the correct accounting context.

The dependency metadata also shows a reference to the package JAI_CONSTANTS, indicating use of shared JAI constants, and a standard dependency on SYS.STANDARD (the default PL/SQL package).

Usage Notes

JAI_RGM_GST_ACCOUNTING_PKG is referenced by the package JAI_CMN_OM_AR_PROCESSING_PKG, which is the common Order Management and Accounts Receivable processing package for the India localization. This confirms that the typical invocation path is indirect: business events in Order Management and Receivables trigger JAI_CMN_OM_AR_PROCESSING_PKG, which in turn calls this package to create the GST repository records and then the GL interface entries. The package also self-references, indicating internal recursive or sequential calls between its own routines.

Because the API classification is OTHER and no public API ceremony is documented, direct calls from custom code are not recommended. The standard usage pattern is through the seeded JAI concurrent programs and the India GST localization processing flows that handle the movement of GST data from subledger transactions to the GL interface. In both EBS 12.1.1 and 12.2.2, the package is expected to remain valid (status VALID) and to be patched as part of the JAI GST product family.