IA_APPROVAL_HRCH_REL Approval Group Incorrect Because Of Missing Table
(Doc ID 2605298.1)
Last updated on NOVEMBER 01, 2019
Applies to:Oracle iAssets - Version 12.2.7 and later
Information in this document applies to any platform.
On : 12.2.7 version
Approver Group:IA_APPROVAL_HRCH_REL includes a call against ia_ame_lov_temp, but no such table exists in the application.
Approver Group:IA_APPROVAL_HRCH_REL to utilize valid existing tables to return data.
The issue can be reproduced at will with the following steps:
1. Check Approver Group:IA_APPROVAL_HRCH_REL which shows this select:
from per_all_assignments_f af
where af.person_id =
and af.primary_flag = 'Y'
and af.assignment_type = 'E'
not in (select st.assignment_status_type_id
from per_assignment_status_types st
where st.per_system_status = 'TERM_ASSIGN')
and trunc(sysdate) between af.effective_start_date;
Due to this issue, users cannot user this Approver Group to successfully generate approvals.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document