Results for “psa_mf_misc_dist_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PSA_MF_MISC_DIST_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the PSA (Public Sector Financials) product family and is documented with a status of VALID across both 12.1.1 and 12.2.2. Its stated purpose is to present the Multi-Fund Miscellaneous Distributions associated with the PSA multi-fund accounting model, in which a single cash receipt or miscellaneous transaction is apportioned across multiple funds rather than being charged to one accounting combination.
Functionally, the view projects the multi-fund detail rows so that each miscellaneous distribution can be reported, extracted, or reconciled at the individual fund level. Because it is a view rather than a table, it carries no independent storage and inherits its data entirely from the underlying base object. Columns such as MISC_CASH_DISTRIBUTION_ID supply the link back to the parent miscellaneous cash distribution, while MISC_MF_CASH_DIST_ID identifies the multi-fund child row itself. This makes the view a natural reporting surface for subledger accounting, fund-balance validation, and downstream integration extracts that must preserve fund-level granularity.
Underlying Base Objects
The view is defined over PSA_MF_MISC_DIST_ALL, which is exposed in the APPS schema as a synonym. The definition is a straightforward projection: it selects the ROWID pseudocolumn plus the full column list from the base object with no filtering predicate, join, or aggregation. Consequently, the row count of the view equals the row count of the base table at any point in time, and no rows are excluded from the reporting surface.
Because the source object follows the _ALL naming convention, it is the single, non-partitioned store for the organization-agnostic data; there is no corresponding _ORG or operating-unit-restricted variant referenced in the view text. Access to the view is controlled through grants on the APPS synonym rather than through row-level security in the view itself, so any fund-level or organization-level restriction must be applied by the consuming report or by the responsibility's data access setup.
Key Columns
- MISC_MF_CASH_DIST_ID — Primary identifier of the multi-fund miscellaneous distribution row, the finest level of detail exposed by the view.
- MISC_CASH_DISTRIBUTION_ID — Foreign key to the parent miscellaneous cash distribution. This is the column most commonly searched and is the join key back to the source transaction.
- DISTRIBUTION_CCID — Code combination identifier of the target accounting distribution line, resolved against GL_CODE_COMBINATIONS.
- CASH_CCID — Code combination identifier for the cash side of the entry.
- REVERSAL_CCID — Accounting combination used when the distribution is reversed.
- POSTING_CONTROL_ID — Identifier associating the row with its posting control record for subledger accounting.
- GL_DATE — Accounting date applied to the distribution when it posts to the general ledger.
- COMMENTS — Free-form description of the distribution line.
- REFERENCE1 through REFERENCE5 and ATTRIBUTE_CATEGORY plus ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield and reference storage, available for client-specific reporting.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard who-column tracking.
Common Use Cases and Queries
The view supports audit and reconciliation of miscellaneous cash receipts that have been split across funds, verification that distribution and cash combinations are consistently populated, and extraction of functional or reporting attributes for downstream systems. A typical lookup by the objective identifier is shown below.
- Retrieve all multi-fund distributions for a miscellaneous cash distribution identifier:
SELECT misc_mf_cash_dist_id, MISC_CASH_DISTRIBUTION_ID, distribution_ccid, cash_ccid, gl_date, posting_control_id FROM psa_mf_misc_dist_v WHERE MISC_CASH_DISTRIBUTION_ID = :misc_cash_distribution_id; - Resolve distribution account codes for reporting:
SELECT d.misc_mf_cash_dist_id, g.concatenated_segments FROM psa_mf_misc_dist_v d, gl_code_combinations_kfv g WHERE d.distribution_ccid = g.code_combination_id; - Validate that GL dates fall within an accounting period before posting, or to reconcile multi-fund totals against the parent distribution amount.
- Extract descriptive flexfield context and attributes for interface files sent to external budgeting or fund-tracking applications.
All queries execute against the underlying _ALL object, so they should be written with the same fund and organization filters expected of PSA reporting.
-
View: PSA_MF_MISC_DIST_V 12.2.2
View of the Multi-Fund Miscellaneous Distributions
APPS.PSA_MF_MISC_DIST_V·↳ PSA_MF_MISC_DIST_ALL·Explore PSA module →
-
View: PSA_MF_MISC_DIST_V 12.1.1
View of the Multi-Fund Miscellaneous Distributions
APPS.PSA_MF_MISC_DIST_V·↳ PSA_MF_MISC_DIST_ALL·Explore PSA module →
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
eTRM - PSA Tables and Views 12.2.2
Stores Public Sector Transaction Types Information
-
eTRM - PSA Tables and Views 12.1.1
Stores Public Sector Transaction Types Information
-
eTRM - PSA Tables and Views 12.2.2
Stores Public Sector Transaction Types Information
-
eTRM - PSA Tables and Views 12.1.1
Stores Public Sector Transaction Types Information
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1