Search Results create_reverse_trx

Overview

APPS.FUN_TRX_PVT_W is a PL/SQL package in Oracle E-Business Oracle Financials that supports transaction processing logic within the Receivables and intercompany processing framework. The package resides in the APPS schema and is classified as OTHER in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. Its primary role is to provide a wrapper interface between declarative PL/SQL record types and the collection types exposed through the JTF (Java Transaction Framework / Technology Foundation) layered API stack. By mapping JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300, JTF_VARCHAR2_TABLE_1, and JTF_DATE_TABLE collections to strongly typed PL/SQL tables such as FUN_TRX_PVT.BATCH_TBL_TYPE and FUN_TRX_PVT.TRX_TBL_TYPE, the package enables forms, concurrent programs, and other callers to exchange transaction data without managing index-by-table conversions directly.

Key Procedures and Functions

The documented interface exposes 23 procedures. The largest group consists of the ROSETTA_TABLE_COPY_IN and ROSETTA_TABLE_COPY_OUT families, numbered P5 through P10. These paired routines perform bidirectional marshalling between JTF collection types and PL/SQL table types. The COPY_IN routines accept JTF collections and produce a populated PL/SQL table, while the COPY_OUT routines do the inverse, expanding a PL/SQL structure into the individual JTF collections consumed by callers. P5 targets FUN_TRX_PVT.BATCH_TBL_TYPE, converting columns such as batch identifiers, numeric attributes, descriptive VARCHAR2 fields, and date values. P6 targets FUN_TRX_PVT.TRX_TBL_TYPE, carrying transaction-level identifiers and related numeric and character fields.

The remaining procedures address transaction lifecycle processing. INIT_BATCH_VALIDATE, INIT_TRX_VALIDATE, INIT_DIST_VALIDATE, and INIT_IC_DIST_VALIDATE initialize validation context for batches, transactions, distributions, and intercompany distributions respectively. INIT_GENERATE_DISTRIBUTIONS prepares and drives the generation of distribution lines. CREATE_REVERSE_TRX is the routine relevant to the user's search term: it creates a reversing transaction, applying the logic required to offset an existing transaction while maintaining the associated accounting and distribution impact. RECIPIENT_VALIDATE performs validation against recipient data. MODIFIED is a change-tracking marker used to indicate that a record has been altered in the current processing session.

Tables Accessed

The package references three objects through APPS synonyms. FUN_DIST_LINES is the distribution line table, which stores the accounting distributions generated for each transaction and is the principal target for distribution creation and reversal activity. WF_ITEM_ACTIVITY_STATUSES is a Workflow engine table used to record and query the activity status of workflow items associated with transaction processing. PLITBLM is the standard Oracle Forms PL/SQL table-to-database interface used for array-based DML operations. These references confirm that the package both drives distribution persistence and participates in workflow-driven transaction state changes.

Usage Notes

FUN_TRX_PVT_W is typically invoked indirectly rather than called directly by end users. Oracle Forms-based transaction entry and the intercompany and Receivables transaction APIs rely on the Rosetta copy routines to pass data across the JTF boundary. Concurrent programs that validate, generate distributions, or reverse transactions may invoke INIT_GENERATE_DISTRIBUTIONS and CREATE_REVERSE_TRX internally. Because the package is not referenced by any other documented package, custom code should treat it as a lower-level internal wrapper and prefer calling the public FUN_TRX_PVT entry points, using these procedures only when explicit JTF collection conversion or reverse-transaction creation is required.