Search Results alc_code

Overview

FV_SYSTEM_PARAMETERS_V is a Federal Financials (FV) view owned by the APPS schema. It consolidates the system-level parameters that Oracle EBS federal deployments require for statutory reporting and treasury-related processing. According to the ETRM documentation, the view "stores system information used by processes such as Prompt Payment and FMS Form 224 Statement of Transactions and by disbursements in transit accounting," and returns "one row for each Set of Books defined in the system."

Because the view is keyed on SET_OF_BOOKS_ID, it functions as a reporting and integration surface for ledger-specific agency attributes — the legal entity name, address, telephone numbers, Agency Location Code (ALC), and the disbursements-in-transit confirmation account. Downstream processes and custom reports join to this view rather than querying the Federal Financials operating-unit tables directly, which keeps Federal Financials configuration details abstracted behind a supported APPS object.

Underlying Base Objects

The view is defined over three main sources in the documented ETRM 12.2.2 metadata:

• FV_OPERATING_UNITS (referenced through an APPS synonym) — supplies the Set of Books identifier, operating unit org_id, legal entity identifier, ALC code, receivables transaction identifier, payables paygroup, Federal Employer Identification Number, and the disbursements-in-transit confirm cash account.
• XLE_FIRSTPARTY_INFORMATION_V — supplies the legal entity name (LEP.NAME) used in address blocks and statutory output.
• HR_LOCATIONS — supplies the address lines, town or city, regions, postal code, and the three telephone number fields.

The join conditions link the operating unit to the legal entity and the legal entity to its location, so address and telephone data are resolved from the first-party (legal entity) record. HR_GENERAL (package) is also referenced, consistent with the location/address derivation used by the view.

Key Columns

• SET_OF_BOOKS_ID — the primary key of the view; one row per ledger.
• NAME — legal entity name from XLE_FIRSTPARTY_INFORMATION_V.
• ADDRESS_LINE_1 / 2 / 3, TOWN_OR_CITY, REGION_1 / 2 / 3, POSTAL_CODE — the legal entity mailing address, typically printed on FMS Form 224 output and prompt-payment correspondence.
• TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2, TELEPHONE_NUMBER_3 — the three telephone fields sourced from HR_LOCATIONS. Users searching for "telephone_number_2" find it here; it corresponds to the second contact number defined on the location attached to the legal entity.
• OU_ORG_ID, LEGAL_ENTITY_ID — operating unit and legal entity identifiers.
• ALC_CODE — the Agency Location Code used in federal treasury reporting.
• RECEIVABLES_TRX_ID, PAYABLES_IA_PAYGROUP — default transaction and interagency paygroup settings.
• FED_EMPLOYER_ID_NUMBER — the agency's Federal EIN.
• DIT_CONFIRM_CASH_ACCOUNT — the cash account used for disbursements-in-transit confirmation.

Common Use Cases and Queries

Typical uses include retrieving the agency address block and telephone numbers for FMS Form 224, resolving ALC and DIT cash account configuration per ledger, and driving Prompt Payment interest calculations. A common query pattern retrieves the parameters for a specific ledger:

• SELECT set_of_books_id, name, alc_code, telephone_number_2, fed_employer_id_number FROM fv_system_parameters_v WHERE set_of_books_id = :p_sob_id;

Alternatively, a report can select all ledgers to build an address/contact listing:

• SELECT set_of_books_id, name, town_or_city, postal_code, telephone_number_1, telephone_number_2 FROM fv_system_parameters_v ORDER BY name;

Because the view joins FV_OPERATING_UNITS, XLE_FIRSTPARTY_INFORMATION_V, and HR_LOCATIONS, ensure that the legal entity and location are properly configured in each ledger before relying on the returned address and telephone values.