My Oracle Support Banner

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.

Symptoms

On : 12.2.7 version

ACTUAL BEHAVIOR
---------------
Approver Group:IA_APPROVAL_HRCH_REL includes a call against ia_ame_lov_temp, but no such table exists in the application.

EXPECTED BEHAVIOR
-----------------------
Approver Group:IA_APPROVAL_HRCH_REL to utilize valid existing tables to return data.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Check Approver Group:IA_APPROVAL_HRCH_REL which shows this select:

select 'person_id:'||af.supervisor_id
from per_all_assignments_f af
where af.person_id =
(select requester_id
 from ia_ame_lov_temp
 where ame_lov_id=:transactionId)
and af.primary_flag = 'Y'
and af.assignment_type = 'E'
and af.assignment_status_type_id
  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.

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.