Results for “iby_transactioneft_pkg”

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

Overview

IBY_TRANSACTIONEFT_PKG is an APPS-owned PL/SQL package within the Oracle Payments (IBY) module of Oracle E-Business Suite, delivered in both 12.1.1 and 12.2.2. Its role is to manage the creation, validation, and closure of Electronic Funds Transfer (EFT) transactions and batches processed through the Oracle Payments funds capture infrastructure. The package serves as a back-end processing unit that assembles EFT batch transaction records, verifies transactional integrity, updates processing results, and closes batches once all payment instructions have been resolved. It operates against the core payments data model rather than exposing a public API, and the ETRM classifies it as an "OTHER" API type. It is not intended for direct invocation by external applications, but rather supports the internal instrumentation of EFT payment processing.

Key Procedures and Functions

The package exposes nine documented procedures and functions. Their purposes are as follows:

• CREATEBATCHCLOSETRXNS — Generates the transaction records required to close an EFT batch after funds capture has been completed.
• CREATEBATCHCLOSETRXNSNEW — A newer variant of batch-close transaction creation, retained for processing paths introduced in later EFT logic.
• UPDATEBATCHCLOSETRXNS — Updates existing batch-close transaction records with final closure information.
• UPDATETRXNRESULTSTATUS — Applies result statuses to transactions following processing, validation, or communication with the payment system.
• INSERTEFTBATCHTRXNS — Inserts EFT batch transaction rows into the transaction summary structures.
• CREATEEFTVERIFYTRXN — Creates verification transactions used to confirm EFT payment instruction validity before final settlement.
• VALIDATE_OPEN_BATCH — Validates whether an open batch is eligible for closure, checking for pending or incomplete transactions.
• PRINT_DEBUGINFO — Emits diagnostic output, typically for debug logging during EFT processing.

Tables Accessed

The package interacts with the central funds capture tables via APPS synonyms. It reads and writes IBY_BATCHES_ALL and its sequence-backed sibling IBY_BATCHES_S for batch header and identity data. Transaction summary records are managed through IBY_TRXN_SUMMARIES_ALL and IBY_TRXNSUMM_MID_S. Payment instrument and payee details are drawn from IBY_PMT_INSTR_USES_ALL and IBY_PAYEE. EFT system profile configuration is read from IBY_FNDCPT_SYS_EFT_PF_B and IBY_FNDCPT_USER_EFT_PF_B, while validation rules are obtained from IBY_VALIDATION_SETS_B and IBY_VAL_ASSIGNMENTS. Tangible and BEP-related data come from IBY_TANGIBLE, IBY_TANGIBLE_S, and IBY_BEPINFO. The package also uses collection types JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300, JTF_NUMBER_TABLE, and JTF_DATE_TABLE for bulk processing, plus DUAL and PLITBLM internally.

Usage Notes

This package is invoked internally by Oracle Payments during EFT batch lifecycle events—specifically, when batches are assembled, verified, and closed following funds capture. It is referenced by no other package according to the ETRM dependency listing, indicating it is a terminal processing unit rather than a shared utility. It is generally not called directly from Oracle Forms or standard concurrent programs; instead, it is executed as part of the EFT processing flow that runs behind the Payments batch and settlement processes. Customizations that bypass the standard EFT workflow and call this package directly risk inconsistent batch states because final status updates and validation depend on the package executing within its normal procedural sequence.