Cannot Extract Dept Manager Number Using PER_EXT_SEC_ORGANIZATION_UE - HCM EXTRACT (Doc ID 1676377.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Global Human Resources - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.7.0.0 version, Set Up Workforce Deployment, users encounter the following issues

1. Not able to Extract Department Manager Number using PER_EXT_SEC_ORGANIZATION_UE - HCM EXTRACT

There is s a requirement of an Interface to extract all department related information.
For this there is a need to fetch Department Manager Number; however users are not able to find any DBI using which we can fetch this information.
Also it is not possible to link any other User Entity with Department User Entity to fetch this information.

Base UE name - PER_ORG_ORG_INFO_USING_PER_ORG_MANAGER_INFO_UE
Username = PER_ORG_ORGMGR_MANAGER

Attempted using the above UE,  But are not able to link  PER_ORG_ORG_INFO_USING_PER_ORG_MANAGER_INFO_UE  with  PER_EXT_SEC_ORGANIZATION_UE.
There is no linkage available.


 
2. Cannot Extract Dept Manager Number using PER_EXT_SEC_ORGANIZATION_UE - HCM EXTRACT

Users encountering the below error:

Name PAY_PAYPROC_UNKNOWN_ERR Token1 null Token2 null Token3 null PAY_PAYPROC_UNKNOWN_ERR Name HR_6881_HRPROC_ORA_ERR Token1 ReportUtil.CallFormula Token2 ORA-20001: × ×•×¡×—×” DEPT_MGR_NUM, שורה 4, חסר ערך × ×ª×•× ×™ מערך. ORA-06512: "FUSION.FF_EXEC", בשורה 3711 ORA-06512: "FUSION.FF_EXEC", בשורה 3721 ORA-06512: "FUSION.PAY_REPORT_PROCESS", בשורה 1523 ORA-06512: בשורה 1

Token3 20 HR_6881_HRPROC_ORA_ERR Name null Token1 null Token2 null Token3 null ORA-20001: × ×•×¡×—×” DEPT_MGR_NUM, שורה 4, חסר ערך × ×ª×•× ×™ מערך. ORA-06512: "FUSION.FF_EXEC", בשורה 3711 ORA-06512: "FUSION.FF_EXEC", בשורה 3721 ORA-06512: "FUSION.PAY_REPORT_PROCESS", בשורה 1523 ORA-06512: בשורה 1


3. Still encountering the same error:

Formula:

 

Solution

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