Hi Suman,
We are on 14.2
I have tried trace as well but it didn't help me much.
This is the only query which I see breaking due to where condition with action_code=12
select action.id, action.action_code, action.alias_code,
action.component_code, action.binding_location,
action.is_ssl_enabled, action.is_active, action.is_system,
action.page_id, page.page_code,
page.is_active as is_page_active, page.is_system as is_system_page, page.is_personalizable,
NVL(action.policy_id,-1) as policy_id, NVL(action.acl_id,-1) as acl_id, policy_code
from cmn_actions action left outer join cmn_sec_policies pol on action.policy_id = pol.id
left outer join cmn_pages page on action.page_id = page.id
where action.action_code = '12'