Search Results p_agreement

Overview

FV_GEN_ARTRX_REIMB_PROC is an Oracle E-Business Suite package body owned by APPS that supports the Federal Financials reimbursement invoicing process. It generates Oracle Receivables transactions associated with reimbursable agreements, converting expenditure, revenue, and advance balances recorded against an agreement into properly balanced AR invoices. The package builds invoice headers, lines, and accounting distributions, then posts them through the public AR Invoice API so that standard Receivables validation, tax, and accounting logic is applied.

The body is registered under API classification OTHER, indicating it is intended as an internal generator rather than a general-purpose public interface. It is typically executed in the context of a reimbursement agreement identified by an agreement number and an operating unit. Because the user query referenced "p_agreement," the package is most relevant when tracing how an agreement number drives the selection of reimbursable balances, customer data, and accounting segments during invoice creation.

Key Procedures and Functions

The documented interface exposes a single procedure, MAIN.

• MAIN — Serves as the entry point and orchestration routine for the reimbursement invoice generation process. It initializes the package globals, resolves the agreement and ledger context, and drives the creation of collection and receivable AR transactions through the AR Invoice API.

Although only MAIN is documented as an external procedure, the package body defines multiple global variables that indicate the internal flow. Agreement-related globals include g_agreement_num, g_agreement, and g_reimb_agreement_segment, confirming that the reimbursement agreement number is a central input. Ledger and period context is held in g_ledger_id, g_ledger_name, g_period_name, g_period_num, and g_period_year. Transaction identifiers such as g_trx_coll_hdr_id and g_trx_rec_hdr_id track collection and receivable headers.

The body also declares structured error handling through exceptions including GET_SEGMENTS_EXCEP, GET_QUALIFIER_SEGNUM_EXCEP, and GET_COMBINATION_ID_EXCEP, which correspond to failures in resolving accounting flexfield segments and code combinations for an agreement. These exceptions indicate that the package resolves both the natural account and balancing segments, along with a dedicated reimbursable agreement segment (g_reimb_agreement_segment), before constructing distributions.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_S, RA_CUST_TRX_LINE_GL_DIST_ALL — the AR invoice header, line, and distribution tables populated via the AR Invoice API.
• FV_GEN_AR_TRX_S, FV_GEN_COLL_AR_TRX_S, FV_GEN_REC_AR_TRX_S — Federal Financials staging and generation tables for reimbursement transactions.
• FV_REIMB_SEGMENT, FV_OPERATING_UNITS_ALL, FV_PYA_FISCALYEAR_SEGMENT — used to derive operating unit, fiscal year, and reimbursable segment values for the agreement.
• HZ_CUST_ACCOUNTS, HZ_PARTIES — resolve the bill-to customer associated with the agreement.
• GL_LEDGERS, GL_PERIOD_STATUSES — determine ledger and open accounting period information.
• FND_ID_FLEX_SEGMENTS — supports key flexfield segment qualifier lookups.
• AR_TRX_ERRORS_GT — stores errors encountered during transaction generation.

Usage Notes

FV_GEN_ARTRX_REIMB_PROC is not referenced by other documented packages, so it is normally invoked directly by a concurrent program, a Federal Financials reimbursement process, or custom code rather than through package-to-package calls. It is executed with parameters identifying the agreement and processing context, and it must be run within an initialized application environment so that organization and ledger globals resolve correctly.

Because invoice creation is delegated to the AR Invoice API using the g_*_tbl structures, records are validated and accounted through standard Receivables logic. Any failures are surfaced through the declared exceptions and AR_TRX_ERRORS_GT. In EBS 12.1.1 and 12.2.2 the package should be treated as internal; direct modification is not supported, and customizations should instead wrap or call it.