Search Results psp_create_stat_batch_in_gms
Overview
PSP_SUM_ADJ is an Oracle EBS Grants (PSP) package body in the APPS schema that performs summarization, adjustment, and GL tie-back processing for encumbrance and grant-related transaction data. Its primary business function is to aggregate detail transactions into summary lines and transfer the resulting summarized balances to the General Ledger interface and, where applicable, the Grants Management (GMS) transaction interface. A key responsibility embedded in the package—and the source of the gl_tie_back search term—is reconciling summary amounts against GL balances so that what is interfaced to GL agrees with its source.
The package also participates in Project Accounting interface transfers, writing summarized expenditure data into PA interface tables. A configuration profile, PSP_ENABLE_ENC_SUMM_GL, and the configuration category PSP_CREATE_STAT_BATCH_IN_GMS govern whether STAT batches are created on the GMS side or whether the tie-back is performed only against Oracle Learning/Deployment side tables.
Key Procedures and Functions
- SUM_TRANSFER_ADJ — the main driver, performing summarization and transfer of adjustments. It accepts a batch name, business group, and set of books to control which data is processed.
- MARK_BATCH_BEGIN / MARK_BATCH_END — bracket a processing run, marking the batch status at the start and completion to support restartability and status tracking.
- CREATE_GL_SUM_LINES — builds summarized GL lines from the source transaction detail.
- INSERT_INTO_SUMMARY_LINES — writes the summarized rows into the summary staging structures.
- TRANSFER_TO_GL_INTERFACE — moves summarized data into the GL_INTERFACE tables for journal import.
- GET_GL_JE_SOURCES — resolves the appropriate GL journal source values.
- GET_GL_JE_CATEGORIES — resolves the appropriate GL journal category values.
- GL_TIE_BACK — reconciles summarized amounts back to GL balances, confirming the interface is complete and consistent.
- GL_BALANCE_TRANSACTION — obtains or computes balancing amounts for the summarized transactions.
- INSERT_INTO_GL_INTERFACE — the low-level row insertion into GL interface tables.
- CREATE_GMS_SUM_LINES — creates summarized lines destined for the GMS transaction interface.
- TRANSFER_TO_GMS_INTERFACE — transfers those lines to GMS.
- GMS_TIE_BACK — the GMS counterpart to GL_TIE_BACK, reconciling summarized amounts against GMS award distributions.
- INSERT_INTO_PA_INTERFACE — writes summarized expenditure data into the Project Accounting interface.
- CHECK_INTERFACE_STATUS — verifies interface processing status.
- CLEANUP_BATCH_DETAILS — removes or resets batch detail records after successful processing.
- GET_THE_BATCH_DETAILS — retrieves the batch detail rows required for summarization.
Tables Accessed
The package reads and writes GL_INTERFACE and its control tables (GL_INTERFACE_CONTROL, GL_INTERFACE_CONTROL_S), and references GL_JE_SOURCES, GL_JE_CATEGORIES, and GL_JOURNAL_IMPORT_S to populate and validate GL interface values. GMS_AWARD_DISTRIBUTIONS and GMS_TRANSACTION_INTERFACE_ALL support the GMS summarization and tie-back path. HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL resolve organizational context; PAY_ELEMENT_TYPES_F supports element classification. PA_EXPENDITURES_ALL, PA_EXPENDITURE_GROUPS_ALL, PA_EXPENDITURE_ITEMS_ALL, and PA_PROJECTS_ALL provide the Project Accounting source and interface data underlying the summarized transactions.
Usage Notes
PSP_SUM_ADJ is typically invoked from Grants concurrent programs and related Grants setup flows, where it summarizes encumbrance and adjustment transactions for a given batch, set of books, and business group. It is referenced by one other package, indicating it is called as a utility layer rather than the top-level entry point. The g_run_type global distinguishes normal from restart runs, supporting recovery after failure. Because GL transfer must be reconciled, GL_TIE_BACK is the essential completion step validating that summary amounts match GL balances. Custom code should not invoke this package directly; use the standard Grants concurrent programs to preserve restartability, batch marking, and tie-back consistency.