Search Results pmt_instr_id

Overview

APPS.IBY_EXT_FD_PRBA_1_0_V is an Oracle Payments (IBY) extraction view used by the Funds Disbursement (FD) extract framework. The name follows the IBY extraction naming convention: IBY_EXT_FD denotes a Funds Disbursement external extract, PRBA denotes Payee/Party/Bank Account bank-master data, and 1_0 is the interface version. The view flattens bank, branch, account, and payee-related attributes into a single row per bank account so that the extract generator can produce formatted payment instructions for a payment process request.

Its defining characteristic is that it resolves a single driving parameter at runtime: PMT_INSTR_ID. This value is not a column on the view; it is supplied through the IBY view-parameter mechanism and read back inside the view text via iby_utility_pvt.get_view_param('PMT_INSTR_ID'). Several columns depend on that value, including the abbreviated agency code and the FEIN, both returned by IBY_FD_EXTRACT_GEN_PVT. This confirms the view is designed to be queried for one payment instruction at a time inside an extract run, rather than as a general-purpose reporting view.

Underlying Base Objects

The view is defined over the following documented objects:

• CE_BANK_ACCOUNTS (synonym over the bank account table) — primary source of account number, suffix, IBAN, check digits, account type, currency, and EFT user information.
• CE_BANK_BRANCHES_V — supplies bank name, bank number, branch name, branch number, branch type, and SWIFT/EFT code; joined on bank party ID and branch party ID.
• HZ_PARTY_SITES — outer-joined ((+)) to obtain the location ID where identifying_address_flag = 'Y'.
• HZ_CODE_ASSIGNMENTS — outer-joined for the RFC identifier class code (CLASS_CATEGORY = 'RFC_IDENTIFIER', OWNER_TABLE_NAME = 'HZ_PARTIES').
• AR_LOOKUPS and CE_LOOKUPS — decoded meanings for bank branch type and bank account type respectively.
• HZ_ORGANIZATION_PROFILES — provides the home country for the bank branch.
• IBY_FD_EXTRACT_GEN_PVT and IBY_UTILITY_PVT — PL/SQL packages supplying the extract parameter lookup and derived values (abbreviated agency code, FEIN).

Key Columns

• BANK_ACCOUNT_ID — primary identifier of the payee bank account.
• BANK_NAME, BANK_NUMBER, BANK_BRANCH_NAME, BRANCH_NUMBER, EFT_SWIFT_CODE, BRANCH_PARTY_ID — bank and branch identification, including alternate-language variants.
• BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, ACCOUNT_SUFFIX, IBAN_NUMBER, CHECK_DIGITS, BANK_ACCOUNT_NUM_ELECTRONIC — account-level payment details.
• BANK_ACCOUNT_TYPE / decoded meaning, BANK_BRANCH_TYPE / decoded meaning, CURRENCY_CODE — classification and currency.
• LOCATION_ID, CLASS_CODE, HOME_COUNTRY, EFT_USER_NUM, AGENCY_LOCATION_CODE — payee/party and regulatory attributes.

Common Use Cases and Queries

Because the view reads PMT_INSTR_ID from the IBY parameter store, it is normally invoked only from within an extract program for the payment instruction currently being processed. A representative query mirrors the extract pattern:

• Diagnostic extraction of one instruction: SELECT bank_account_id, bank_name, bank_account_num, currency_code, iban_number FROM apps.iby_ext_fd_prba_1_0_v WHERE bank_account_id = :bank_account_id;
• Verifying lookups: query decoded bank_branch_type_meaning and bank_account_type_meaning to confirm that AR_LOOKUPS/CE_LOOKUPS rows exist for the codes on the account.
• Checking optional data: inspect class_code, agency_location_code, and home_country for nulls, which typically indicate missing HZ_CODE_ASSIGNMENTS or HZ_ORGANIZATION_PROFILES setup.

Searching for pmt_instr_id against this object returns only the internal parameter reference, since the column itself is not projected. To relate the view to a specific payment, filter through the bank account identifier carried on the payment instruction.