Search Results a000_load_table

Overview

FV_SF1080_TRANSACTION is an Oracle EBS receivables reporting package owned by the APPS schema that supports the SF1080 (Statement of Account / transaction listing) reporting family. In Oracle Receivables, the SF1080 series produces customer-facing statements and invoice-related extracts, and this package encapsulates the data extraction logic that feeds those reports. The package is classified as OTHER within the ETRM repository, distinguishing it from public APIs: it is an internal utility intended to support concurrent report programs rather than to be called directly by external integrations.

The package exists to load a temporary reporting structure with transaction and customer data filtered by a wide range of runtime selection criteria, then hand that data to a report template for final formatting and output. The naming convention and temporary table references (FV_SF1080_HEADER_TEMP and FV_SF1080_DETAIL_TEMP) mirror the standard Oracle Reports "load table, then print" pattern used throughout Oracle Financials release 12.1.1 and 12.2.2.

Key Procedures and Functions

• A000_LOAD_TABLE — The single documented procedure in the package. It serves as the data extraction entry point: it accepts the user's selection criteria (including order-by logic, batch, transaction class and type, transaction number and print date ranges, customer profile class, customer class and customer, and an open-invoices-only flag) and writes the matching header and line records into the package's temporary tables. It also returns standard error_code and error_message out parameters so the calling concurrent program can signal failure to the concurrent manager.

The "a000_" prefix follows Oracle's internal report data-source naming convention and indicates the procedure is invoked first in the report execution sequence.

Tables Accessed

• FV_SF1080_HEADER_TEMP, FV_SF1080_DETAIL_TEMP — Temporary staging tables populated by A000_LOAD_TABLE and consumed by the report; they hold the filtered transaction and customer rows for the current run.
• RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_GL_DIST — Core receivables transaction, line, and accounting distribution data that form the substance of the statement.
• RA_BATCHES, RA_CUST_TRX_TYPES — Batch and transaction type reference data used to validate and filter the selection.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_CUSTOMER_PROFILES, HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS — Trading community model tables supplying customer name, account, site, address, and profile classification data.
• GL_CODE_COMBINATIONS — Accounting flexfield combinations used to describe the distributions on the statement.

Usage Notes

The package is invoked by the SF1080 concurrent program in Oracle Receivables. The concurrent manager calls A000_LOAD_TABLE with the parameters entered on the report submission form, then launches the associated Oracle Reports definition against the populated temporary tables. It is not referenced by any other documented package in the ETRM repository, confirming that it sits at the top of its own call chain rather than participating in shared business logic.

Because the procedure writes to global temporary tables, no direct SQL access from custom code is supported. Customers requiring transaction statement extracts should use the underlying receivables tables or the SF1080 concurrent program itself. The header comment indicates the source file FVX1080S.pls at version 120.4, dated 2006, reflecting code that has remained stable across the 12.1.1 and 12.2.2 releases.