Results for “funds_check_result_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_BUDGET_ACCT_LINES is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores consolidated accounting information for a budget version. Each row represents a summarized budget or available-funds balance for a specific accounting period, date range, and General Ledger account combination belonging to a given project budget version. It is the accounting-line counterpart to the transaction-level budget entry and serves as the source from which budget-versus-actual reporting, funds checking, and period-by-period budget consumption analytics are derived.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link table. It resolves the many-to-many association between a budget version and GL accounting combinations across time, carrying descriptive and quantitative measures; those measures (budget amount, available amount, accounted amount) would be treated as satellite attributes in a Data Vault design.

Key Information Stored

The table is owned by the PA schema and contains 19 documented columns. The surrogate primary key is BUDGET_ACCT_LINE_ID, enforced by unique index PA_BUDGET_ACCT_LINES_U1. Two additional unique indexes identify business-key candidates: PA_BUDGET_ACCT_LINES_U2 on (BUDGET_VERSION_ID, START_DATE, CODE_COMBINATION_ID) and PA_BUDGET_ACCT_LINES_U3 on (BUDGET_VERSION_ID, GL_PERIOD_NAME, CODE_COMBINATION_ID). The most significant columns include:

• BUDGET_ACCT_LINE_ID — Surrogate primary key for each consolidated accounting line.
• BUDGET_VERSION_ID — Foreign key to PA_BUDGET_VERSIONS, tying the line to a specific project budget version.
• GL_PERIOD_NAME — The GL accounting period to which the consolidated amounts apply.
• START_DATE / END_DATE — Effective date range for the budget line, supporting date-keyed uniqueness.
• CODE_COMBINATION_ID — The GL account combination (chart of accounts string) against which amounts are held.
• PREV_VER_BUDGET_AMOUNT / PREV_VER_AVAILABLE_AMOUNT — Prior version budget and available balances, enabling version-over-version comparison.
• CURR_VER_BUDGET_AMOUNT / CURR_VER_AVAILABLE_AMOUNT — Current version budget and remaining available amounts.
• ACCOUNTED_AMOUNT — Accounted value for the line, used in reconciliation and reporting.
• FUNDS_CHECK_STATUS_CODE / FUNDS_CHECK_RESULT_CODE — Outcome of funds checking against the line.
• REQUEST_ID — Concurrent request that generated or updated the row, supporting audit of batch processing.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include budget-versus-available balance reporting, period-based budget consumption, and funds-check exception analysis. A representative query joins the parent budget version to retrieve consolidated balances for a project's accounts:

• SELECT l.BUDGET_VERSION_ID, l.GL_PERIOD_NAME, l.CODE_COMBINATION_ID, l.CURR_VER_BUDGET_AMOUNT, l.CURR_VER_AVAILABLE_AMOUNT FROM PA_BUDGET_ACCT_LINES l WHERE l.BUDGET_VERSION_ID = :version_id ORDER BY l.GL_PERIOD_NAME;
• Reporting available funds by account combination across a date range using START_DATE and END_DATE filters to isolate the active budget line.
• Comparing prior and current version amounts using PREV_VER_BUDGET_AMOUNT against CURR_VER_BUDGET_AMOUNT to quantify budget revisions.
• Isolating failed funds checks via FUNDS_CHECK_STATUS_CODE and FUNDS_CHECK_RESULT_CODE for exception dashboards.

Related Objects

The dominant relationship is to the parent budget version table, and other objects reference the account combination and period context:

• PA_BUDGET_VERSIONS — Parent table via BUDGET_VERSION_ID (documented FK).
• GL_CODE_COMBINATIONS — Resolves CODE_COMBINATION_ID to the chart of accounts.
• GL_PERIODS — Provides calendar context for GL_PERIOD_NAME.
• PA_BUDGET_LINES / PA_BUDGET_ENTRIES — Transaction-level budget detail that rolls up into these consolidated lines.
• PA_PROJECTS_ALL — Project metadata reached through the budget version.