FND SOA Runtime Error

Description

Categories
Enginatics, R12 only
Repository
GitHub

SQL 12 lines

select
fsre.message_id,
fsre.error_date,
fsre.error_code,
fsre.error_detail
from
fnd_soa_runtime_error fsre
where
1=1
order by
fsre.error_date desc,
fsre.message_id desc

Parameters 3

ParameterTypeList of values SQL
Logged within x DaysNumber
fsre.error_date>=sysdate-:days
Date FromDate
fsre.error_date>=:date_from
Date ToDate
fsre.error_date<:date_to+1