Oracle Communities

Oracle Analytics and AI

Child Item

Asset Assignment - Employee Name and Number Missing from Subject Areas

Is there a subject area that contains the Employee Name and Employee Number fields in FAW? In Fusion Apps, the fields are located on the asset, under Assignments tab. These fields are needed for some reports.

Find more posts tagged with

Oracle Fusion Analytics

ERP Analytics Content

Fusion ERP Analytics

Accepted answers

Ashish-Oracle

@Molly I would suggest you go ahead and log an Idea Labs request with the below description:-

Implemented ERP offering in FDI and is looking for a subject area that contains the Employee Name and Employee Number fields in FDI. Upon checking found these columns as part of ERP->Data Lineage Documentations as part of "Financials - Assets Transactions” and "Financials - Assets Analysis” subject area.

ie. SELECT
"Financials - Assets Analysis"."Assignment Details"."Employee Name" s_1,
"Financials - Assets Analysis"."Assignment Details"."Employee Number" s_2
FROM "Financials - Assets Analysis"

And

SELECT
"Financials - Assets Transactions"."Assignment Details"."Employee Name" s_1,
"Financials - Assets Transactions"."Assignment Details"."Employee Number" s_2
FROM "Financials - Assets Transactions"

As per the current design, these two HCM attributes (Employee Name and Number) will appear and be available only if the HCM module (i.e. Workforce Management / FA_WRKFRC_MGMT) is enabled.

"Looking for a way to get these columns while using ERP offering area and not activating HCM Workforce Management module."

Thanks and Regards

Ashish

All comments

Mallikarjuna Kuppauru-Oracle

Hi @Molly P

Below is the reason why these two columns are not visible from UI -

These two HCM attributes (Employee Name and Number) will appear and be available only if the HCM module (i.e. Workforce Management / FA_WRKFRC_MGMT) is enabled.

I worked with your previously, i hope you are using only ERP application.

I hope We have answered your question?

Regards,

Arjun

Molly P

Hi @Mallikarjuna Kuppauru-Oracle, correct we are only using ERP. Why is this only available with HCM if they are fields related to Fixed Assets? Do they have plans to add these columns for ERP-only users?

Thanks,
Molly

Ashish-Oracle

@Molly I would suggest you go ahead and log an Idea Labs request with the below description:-

ie. SELECT
"Financials - Assets Analysis"."Assignment Details"."Employee Name" s_1,
"Financials - Assets Analysis"."Assignment Details"."Employee Number" s_2
FROM "Financials - Assets Analysis"

And

As per the current design, these two HCM attributes (Employee Name and Number) will appear and be available only if the HCM module (i.e. Workforce Management / FA_WRKFRC_MGMT) is enabled.

"Looking for a way to get these columns while using ERP offering area and not activating HCM Workforce Management module."

Thanks and Regards

Ashish

Molly P

Thanks, I created the idea.

Are you aware of any customization we can do to bring these fields in without enabling HCM?

Molly

Mallikarjuna Kuppauru-Oracle

Hi @Molly P

Above HCM columns are coming from below 2 tables.

DW_PERSON_NAME_CURRENT_D
DW_PERSON_D

I hope these 2 will be available in Your DB so you can use the Extended Dim using SME functionality.

Regards,

Arjun