Search Results fun_trx_pub




Overview
Explore in AI Chat

Overview

APPS.FUN_TRX_PUB is the public PL/SQL application programming interface responsible for validating intercompany transactions and persisting validated batches into the Oracle E-Business Suite Financials (FUN) transaction tables. Registered in the ETRM repository under product FUN with an active lifecycle and public scope, the package is classified as a business entity API for the FUN_INTERCOMPANY_BATCH entity and carries the display name "Intercompany Batch Creation API." The header comment distributed with the source (funtrxvalinss.pls 120.10, dated 2006/10/05) confirms this design intent: the API validates intercompany transactions and inserts the validated batch into the FUN transaction tables.

The package declares two record types that define its public data contract: Full_Batch_Rec_Type, which models an intercompany batch header (batch identifier and number, initiator, from legal entity and ledger, control and running totals, currency, exchange rate type, status, transaction type, accounting and batch dates, rejection and reversal flags, recurring batch reference, and the standard 15 attribute columns plus attribute category), and Full_Trx_Rec_Type, which models an intercompany transaction line (transaction identifier and number, initiator, recipient, to legal entity and ledger, parent batch, status, and initial debit and credit amounts). A business event, oracle.apps.fun.manualtrx.batch.send, is associated with the package, enabling workflow and subscriber integration at the point a manual transaction batch is sent.

Key Procedures and Functions

ETRM documents one public program unit for this package:

  • CREATE_BATCH — The single documented entry point of the Intercompany Batch Creation API. It accepts batch data conforming to the package's record structures, performs validation of the intercompany transaction content, and inserts the validated batch into the FUN transaction tables. As an API-classified public routine, it is intended for external invocation by Oracle EBS products and by customer extensions rather than internal-only use.

No additional procedures or functions are documented in the ETRM metadata. Parameter lists are not published in the available excerpt and should be obtained from the package specification (for example, by describing APPS.FUN_TRX_PUB in the database) before writing dependent code.

Tables Accessed

The package operates across the FUN interface, staging, and transaction schema, together with one reference table:

These tables are referenced through APPS synonyms, consistent with the standard EBS synonym convention.

Usage Notes

FUN_TRX_PUB is a public (PUB) API and is invoked by other Oracle EBS application code, by concurrent programs and forms that create intercompany batches, and by customer-written extensions. ETRM records that the package is referenced by two other packages, confirming inter-package dependency within the FUN module and indicating that changes to its signature or behavior carry downstream impact. Because the API validates and then inserts, callers should supply well-formed batch and transaction records and be prepared to handle the rejection data written to FUN_INTERFACE_REJECTIONS. The CREATE_BATCH routine performs database work and follows the usual PL/SQL transaction semantics; callers are responsible for commit or rollback. The package specification should be reviewed for exact parameter definitions prior to integration, as the ETRM excerpt does not enumerate them.