User and Role Access Audit Report Error: No Hierarchy exists for the given input . Please check the input you have entered . If the input is valid, please run the Import User and Role details ASE etl job before running this report for the required results (Doc ID 2155039.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Applications Common Components - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

Run User and Role Access Audit Report for All Roles parameter errors.

 

ERROR

Diagnostics log for the request shows:

**** Sample Job Running, Request ID: 220425
**** Patch Version 3.0 - Built on Dec 3,2012 ****
**** Job Execution timestamp -->Tue Jun 28 06:38:55 UTC 2016/n**** User Entitlements Report Job Running, Request ID: 220425
**** The Entered Population Type LOV Value is :ALL_ROLES
**** The Entered User Name is :null
**** The Entered Role Name is :null
**** The Entered User Name Starts With is :null
**** The Entered User Name Ends With is :null
**** The Entered Job Role Contains is :null
**** The Output directory is :/u01/APPLTOP/instance/ess/rfd/220425/out**** The Entered Type LOV is ALL_ROLES
**** The Entered User Name / Role Name is null

Query used is : SELECT ARV.CODE CODE,ARV.ROLE_ID ID, ARV.ROLE_NAME, ARV.ROLE_TYPE_CODE ROLE_TYPE_CODE,ARV.APP_ID,ARV.DESCRIPTION DESCRIPTION FROM FUSION.ASE_ROLE_VL ARV WHERE (ARV.ROLE_TYPE_CODE like '%_ABSTRACT' or ARV.ROLE_TYPE_CODE LIKE '%_JOB' OR ARV.ROLE_TYPE_CODE ='CRM_ENTERPRISE_DUTY' ) AND ARV.EFFECTIVE_END_DATE IS NULL AND ARV.APP_ID IS NULL
No Hierarchy exists for the given input . Please check the input you have entered . If the input is valid, please run the Import User and Role details ASE etl job before running this report for the required results.

 

STEPS

Navigator> Scheduled Processes > Schedule New Process > Job = User and Role Access Audit Report (parameter : All Roles)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms