Search Results check_misc_txns

Overview

PA_XLA_SWEEP_TXN_PKG is a PL/SQL package in the APPS schema that supports the integration between Oracle Projects (PA) and Subledger Accounting (XLA) in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal business function is to sweep or migrate accounting events and associated cost distribution data for project transactions into the Subledger Accounting model, performing the period and GL date determination required for accounting event processing. Because Oracle Projects was migrated into the XLA architecture during the R12 release, packages such as this one exist to re-create or re-align accounting events when transactions are processed in bulk, when periods are re-opened, or when existing transfer processes need to be re-driven.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which is consistent with other Applications product packages that rely on APPS synonyms and user-level grants to access the underlying PA and XLA tables.

Key Procedures and Functions

Three documented procedures constitute the public interface of this package:

• SWEEP_TXNS — The main driver procedure. It accepts an organization identifier, a GL period name, and a transaction type, then processes project transactions of that type for the specified organization and period, sweeping them toward the Subledger Accounting events staging structures. It drives the bulk processing of transactions in the scope defined by the caller.
• POPULATE_GL_DATE — Determines and assigns the GL date and GL period values for the transactions being swept. Its existence reflects the need to translate project accounting dates into valid GL period and date combinations during the sweep.
• CHECK_MISC_TXNS — Performs a validation check for miscellaneous transactions, ensuring that transactions of non-standard types are handled or flagged appropriately before or during the sweep.

The package declares numerous package-global variables covering bulk sizes (g_bulk_Size and g_cdl_bulk_size, both defaulted to 500), organization, set of books, period name and date, request id, user id, and application id (g_app_id, defaulted to 101 — the Oracle Projects application id). Collection globals of type PA_PLSQL_DATATYPES (Num15TabTyp, Char30TabTyp, Char1TabTyp, DateTabTyp) hold expenditure item identifiers, line numbers, adjusted expenditure item identifiers, system linkage functions, accrual flags, CDL rowids, GL dates and periods, receiver GL dates and periods, receiver set of books and organization identifiers, and the R12 Funds Management attributes: CDL line type, liquidate encumbrance flag, burden sum destination run id, document header id, document distribution id, expenditure type, and CDL accounting event id.

Tables Accessed

The package references the following tables through APPS synonyms:

• PA_COST_DISTRIBUTION_LINES, PA_COST_DISTRIBUTION_LINES_ALL, PA_CC_DIST_LINES — Source cost distribution lines being swept into accounting events.
• PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_GROUPS_ALL, PA_DRAFT_REVENUES_ALL — Project expenditure and revenue transaction detail and grouping.
• PA_BC_COMMITMENTS — Commitment data associated with burdens, relevant to the Funds Management logic.
• PA_IMPLEMENTATIONS_ALL — Supplies the set of books and organization context (g_sob_id, g_org_id).
• PA_TRANSACTION_SOURCES — Validates transaction source definitions.
• XLA_EVENTS — The Subledger Accounting events to which swept transactions are associated or updated.
• GL_PERIOD_STATUSES — Used to validate period names and their open status.
• FND_CONCURRENT_REQUESTS — Captures the concurrent request id for logging and traceability.
• FND_NEW_MESSAGES — Used to surface informational or warning messages to the user.

Usage Notes

PA_XLA_SWEEP_TXN_PKG is typically invoked from Oracle Projects accounting processes rather than directly by end users. It is referenced by one other package in the documented metadata, indicating it is called programmatically by a higher-level Projects accounting or SLA integration routine. In practice, concurrent programs such as those that transfer project costs and revenue to Subledger Accounting, or programs that re-create accounting events after period re-opening, will call SWEEP_TXNS internally. Custom extensions should call the procedures with the correct organization, GL period, and transaction type, and should observe the package-global bulk sizes of 500 when batching to avoid excessive memory or rollback segment usage. The g_app_id default of 101 identifies Oracle Projects as the owning application for XLA event creation, which is important when troubleshooting events appearing against unexpected application identifiers.