Results for “run_result_status”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAYBV_RUN_RESULT is a read-only Oracle EBS view that presents payroll run results in a business-user-friendly format. It is defined over the PAY_RUN_RESULTS synonym and exposes decoded (meaningful) values for several coded columns by invoking the HR_BIS.BIS_DECODE_LOOKUP function. Rather than returning raw lookup codes, the view translates them into their display meanings, making it suitable for reporting, BI Publisher data sources, OBIEE/OTBI extracts, and integration scenarios where consumers require human-readable payroll data rather than internal codes.
The view is defined WITH READ ONLY, guaranteeing it cannot be used for DML. Its primary relevance to the search term run_result_source_type is the SOURCE_TYPE column, which is decoded from the underlying PAY_RUN_RESULTS.SOURCE_TYPE using the RUN_RESULT_SOURCE_TYPE lookup type. This is the same lookup referenced when investigating how a payroll run result was generated.
Underlying Base Objects
The view is documented with two referenced base objects: the HR_BIS package and the PAY_RUN_RESULTS synonym. The FROM clause selects exclusively from PAY_RUN_RESULTS (aliased PRR), which resolves to the PAY_RUN_RESULTS base table under APPS. HR_BIS is not a data source; it is a PL/SQL package supplying the BIS_DECODE_LOOKUP function used three times in the SELECT list. Each call passes a lookup type name and the corresponding code column, returning the lookup meaning. The view therefore adds a decoding layer on top of the run results table without joining to additional transactional entities such as assignments or elements; those are represented only by their ID columns.
Key Columns
- ENTRY_TYPE — Decoded from ENTRY_TYPE via the ENTRY_TYPE lookup type; describes the nature of the run result entry.
- SOURCE_TYPE — Decoded from SOURCE_TYPE via the RUN_RESULT_SOURCE_TYPE lookup type. This is the column addressed by the "run_result_source_type" search and indicates how the result was sourced (for example, from an element entry, an assignment action, or a balance adjustment).
- STATUS — Decoded from the STATUS code via the RUN_RESULT_STATUS lookup type, indicating processing state.
- ENTRY_TYPE_CODE, SOURCE_TYPE_CODE, STATUS_CODE — The raw, undecoded values retained alongside their decoded counterparts for filtering and joins.
- JURISDICTION_CODE — The jurisdiction associated with the result, relevant for legislative or tax processing.
- START_DATE, END_DATE — The effective period of the run result.
- RUN_RESULT_ID — Primary identifier for the underlying PAY_RUN_RESULTS row.
- ELEMENT_TYPE_ID — Foreign key to the payroll element type that produced the result.
- ASSIGNMENT_ACTION_ID — Links the result to the assignment action that originated it.
- SOURCE_ID — Identifier of the specific source record within the given SOURCE_TYPE.
Common Use Cases and Queries
Typical uses include payroll audit reporting, reconciliation of run results by source, and feeds to downstream systems. Because decoded values are provided, the view is convenient for direct end-user reporting without requiring a lookup join. A representative query filtering on source type is:
SELECT run_result_id, source_type, entry_type, status, start_date, end_date FROM apps.paybv_run_result WHERE source_type_code = 'E';
To enumerate run results grouped by decoded source, use:
SELECT source_type, status, COUNT(*) FROM apps.paybv_run_result GROUP BY source_type, status ORDER BY source_type;
For a specific assignment action, join on ASSIGNMENT_ACTION_ID:
SELECT entry_type, source_type, status FROM apps.paybv_run_result WHERE assignment_action_id = :p_action_id;
Note that filtering is generally more efficient against the *_CODE columns because those are the indexed raw values, whereas the decoded columns are computed at query time via BIS_DECODE_LOOKUP.
-
Possible statuses of run items
-
Possible statuses of run items
-
VIEW: APPS.PAYBV_RUN_RESULT 12.1.1
-
VIEW: APPS.PAYBV_RUN_RESULT 12.2.2
-
View: PAY_RUN_RESULTS_V 12.1.1
Used to support user interface
APPS.PAY_RUN_RESULTS_V·↳ FND_DATE·↳ FND_GLOBAL·↳ FND_NUMBER·Explore PAY module →
-
VIEW: APPS.PAY_RUN_RESULTS_V 12.1.1
-
VIEW: APPS.PAY_RUN_RESULTS_V 12.2.2
-
View: PAYBV_RUN_RESULT 12.2.2
APPS.PAYBV_RUN_RESULT·↳ HR_BIS·↳ PAY_RUN_RESULTS·Explore PAY module →
-
View: PAYBV_RUN_RESULT 12.1.1
APPS.PAYBV_RUN_RESULT·↳ HR_BIS·↳ PAY_RUN_RESULTS·Explore PAY module →
-
View: PAY_RUN_RESULTS_V 12.2.2
Used to support user interface
APPS.PAY_RUN_RESULTS_V·↳ FND_DATE·↳ FND_NUMBER·↳ HR_API·Explore PAY module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2