PSB Validation Results

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Public Sector Budgeting (Obsolete)
Source
Validation Results Report (XML)
Short Name
PSBRPERR_XML
DB package
PSB_PSBRPERR_XMLP_PKG

SQL 9 lines

SELECT          concurrent_request_id, description, process_id, source_process
FROM             psb_error_messages
WHERE          (( process_id = NVL(:P_PROCESS_ID,'000')  
AND source_process = NVL(:P_SOURCE_PROCESS,'000') )
                        OR  (concurrent_request_id = NVL(:P_CONC_ID,'000'))
                    )
AND              concurrent_request_id = to_number(:cp_max_conc_id)
ORDER BY    sequence_number

Parameters 3

ParameterTypeList of values SQL
Source ProcessLOV Oracle
Process NameLOV Oracle
Concurrent Request IdLOV Oracle