Results for “get_uom_name”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JMF_GTA_ARTRX_PROC is a PL/SQL package in the APPS schema that supports the Global Tax Agreement (GTA) invoicing flow within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal responsibility is to retrieve transaction data from Oracle Receivables based on conditions defined in the GTA Setup form and to transfer qualifying receivables transactions into the GTA invoicing process. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the package owner, which is appropriate for a concurrent-program-invoked utility that must respect the session's security context, including organization-level access.
The source header indicates the package has been maintained since 2005, with published fixes through January 2009 (File version 120.6.12010000.3). It is part of the process manufacturing / GTA module family (JMF prefix) and is delivered alongside related objects such as JMF_GTA_TRX_UTIL.
Key Procedures and Functions
The package exposes a primary concurrent-program entry point, transfer_AR_to_GTA. This procedure implements the invoices transfer concurrent program that moves transaction data from Receivable into GTA. Documented parameters include OUT NOCOPY errbuf and retcode (the standard concurrent program completion pair), IN P_ORG_ID (operating unit), IN P_TRANSFER_id, and, per the specification comments, a transfer rule identifier and a p_conc_parameters record of type JMF_GTA_TRX_UTIL.transferParas_rec_type, together with a debug flag. A further documented routine, get_gta_number, was added to resolve bug 5144561, and the related retrieve_valid_AR_TRXs logic selects receivables transactions that meet the setup-form conditions. Design documentation is referenced as GTA-TRANSFER-PROGRAM-TD.doc; the procedure bodies are not otherwise enumerated in the available metadata.
Tables Accessed
The provided ETRM extract does not enumerate base tables accessed through APPS synonyms. Functionally, the package reads Oracle Receivables transaction tables (principally RA_CUSTOMER_TRX_ALL and its line and distribution children) to identify invoices eligible for transfer under the configured transfer rules, and it writes or updates the GTA staging and invoice structures that hold the transferred tax-agreement invoice data. Because the extract lists zero documented table references and zero dependent packages, DBAs should confirm actual dependencies from the deployed source (USER_DEPENDENCIES, ALL_DEPENDENCIES) rather than relying solely on the metadata record.
Usage Notes
JMF_GTA_ARTRX_PROC is normally invoked indirectly: the GTA Transfer concurrent program calls transfer_AR_to_GTA, passing the organization, transfer identifier and parameter record, and interpreting the OUT errbuf and retcode to report success or failure. It may also be called from the GTA Setup form or from custom code that requires the same extraction semantics, provided the caller supplies a valid transfer parameter record and the required organization context. Note that the search term "gta 6 especificaciones" relates to an unrelated consumer product and has no bearing on this Oracle EBS object. When troubleshooting in 12.1.1 or 12.2.2, review FND_CONCURRENT_REQUESTS log and output files for the GTA Transfer program, verify the GTA Setup conditions, and ensure the operating unit passed to P_ORG_ID matches the transactions to be transferred.