Results for “pa_capital_exceptions”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_CAPITAL_EXCEPTIONS is a reporting view owned by the APPS schema in Oracle E-Business Suite, registered under the Projects (PA) product family. Its documented description is "Capital Reporting Exceptions View." The view surfaces exception records generated during capital project processing, specifically rows written by the capital reporting and capital asset generation programs. In EBS 12.1.1 and 12.2.2, capital projects pass through a series of concurrent programs (for example, PRC: Generate Asset Lines and related capital reporting processes) that identify conditions preventing a project cost or asset line from being processed cleanly. PA_CAPITAL_EXCEPTIONS exposes those error rows so that implementers, project accountants, and support personnel can query, diagnose, and report on them without accessing the full exception table directly.
Because the view is filtered by module and record type, it presents a deliberately narrow slice of the exception data: only capital-related errors. This makes it suitable for functional troubleshooting, reconciliation reports, and integration checks where a downstream system needs to know which capital events failed.
Underlying Base Objects
The view is defined over a single base object, documented in the ETRM as PA_REPORTING_EXCEPTIONS (referenced through a synonym). The view text is:
SELECT REQUEST_ID, MODULE, CONTEXT, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, RECORD_TYPE, ATTRIBUTE4, ORG_ID FROM PA_REPORTING_EXCEPTIONS WHERE MODULE = 'CAPITAL' AND RECORD_TYPE = 'E'
Two filters define its scope. The MODULE = 'CAPITAL' predicate restricts rows to the capital reporting process, and RECORD_TYPE = 'E' restricts rows to exception or error records. The base table PA_REPORTING_EXCEPTIONS is a generic exception repository used across multiple Projects reporting streams; the view therefore acts as a capital-specific projection that also limits, or maps, the set of columns exposed relative to the base table. Note that the documented column list in the metadata is broader than the view's SELECT list, and includes columns such as PROJECT_ID, PROJECT_ASSET_ID, CREATED_BY, CREATION_DATE, and ERROR_CODE that are described as part of the view's column inventory.
Key Columns
REQUEST_ID— The concurrent request identifier of the reporting program run that produced the exception. Useful for grouping all exceptions from a single execution.MODULE— The reporting module. Always 'CAPITAL' in this view by definition of the WHERE clause.CONTEXT— A context key used by the reporting framework to categorize the exception.RECORD_TYPE— The record classification. Filtered to 'E' (exception/error) in this view; this is the column most often referenced when users search for "record_type."ATTRIBUTE1throughATTRIBUTE4— Descriptive or flexible attribute columns carrying context-specific detail about the exception.ORG_ID— The operating unit identifier, enabling multi-org aware queries.PROJECT_ID,PROJECT_ASSET_ID,ERROR_CODE,CREATED_BY,CREATION_DATE— Documented columns supporting identification of the affected project or asset and the nature and authorship of the error.
Common Use Cases and Queries
Typical scenarios include verifying that capital asset generation completed without errors, isolating exceptions for a specific operating unit, and tracing failures back to a concurrent request.
- List all capital exceptions for a request:
SELECT request_id, project_id, error_code FROM pa_capital_exceptions WHERE request_id = :req_id; - Exceptions for an operating unit:
SELECT * FROM pa_capital_exceptions WHERE org_id = :org_id; - Joining to project information:
SELECT e.project_id, p.name, e.error_code FROM pa_capital_exceptions e, pa_projects_all p WHERE e.project_id = p.project_id;
Because the view always returns RECORD_TYPE = 'E', queries do not need to filter on that column, though it may be selected for clarity in reports.
-
View: PA_CAPITAL_EXCEPTIONS 12.1.1
Capital Reporting Exceptions View
APPS.PA_CAPITAL_EXCEPTIONS·↳ PA_REPORTING_EXCEPTIONS·Explore PA module →
-
View: PA_CAPITAL_EXCEPTIONS 12.2.2
Capital Reporting Exceptions View
APPS.PA_CAPITAL_EXCEPTIONS·↳ PA_REPORTING_EXCEPTIONS·Explore PA module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
PACKAGE: APPS.PA_FAXFACE 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
PACKAGE: APPS.PA_FAXFACE 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2