Asset Assignment - Employee Name and Number Missing from Subject Areas

Molly P

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.

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

Ashish-Oracle

@Molly P 1. Please check  Subject Area "Financials - Assets Analysis"."Assignment Details"

Sharing logical query for reference

SELECT
   0 s_0,
   "Financials - Assets Analysis"."Assignment Details"."Employee Name" s_1,
   "Financials - Assets Analysis"."Assignment Details"."Employee Number" s_2
FROM "Financials - Assets Analysis"
ORDER BY 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 500001 ROWS ONLY

2. Also check Subject Area "Financials - Assets Transactions"."Assignment Details".

Sharing logical query for reference,

SELECT
   0 s_0,
   "Financials - Assets Transactions"."Assignment Details"."Employee Name" s_1,
   "Financials - Assets Transactions"."Assignment Details"."Employee Number" s_2
FROM "Financials - Assets Transactions"
ORDER BY 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 500001 ROWS ONLY

Molly P

Hi @ashish.f.singh-Oracle, this is where I looked but I only see these two fields in either asset subject area:

Are you saying we are missing these fields and they should definitely there out of the box?

Ashish-Oracle

The Data Lineage for Semantic Model for Release 24R2 lists these as OOTB columns.

Are you on a prior release or the same release of 24 R2 @Molly P? You might need to update to 24 R2 in order to leverage these columns.

https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/data-lineage.html#GUID-0AF78720-4C42-4346-8B1E-CA27079C09BD

Sumanth V -Oracle

@Molly P - As mentioned by @ashish.f.singh-Oracle in the 24R2 release the employee details are included. Please find the screenshot showing the same as below:

Thanks.

Ashish-Oracle

@Molly P Can you please mark the post as answered if we have managed to answer your concern.

This helps other members in the community who are looking for answers to similar questions.

Thanks and Regards

Ashish

Molly P

Hi @ashish.f.singh-Oracle

I confirmed we were on version 24R2.P1 and got an optional update to P2 yesterday. I checked this morning and the fields are still not available. Is there an additional step I should try?

Thanks, Molly

Ashish-Oracle

@Molly P I checked two of my instances having 24 2 version and both have these columns OOTB. So, it looks something specific to your instance. If it is a non-prod instance, can you try to delete the "Financial Analytics" offering "Assets" functional area from Data pipeline and try to activate it again? I feel this way these columns should get added to the Subject Area definition.

Thanks and Regards

Ashish

Ashish-Oracle

@Molly P Did you try the suggestion?

In case the issue is resolved, could you please mark the appropriate answer as "accepted" in this thread?

This will allow other forum users to benefit from this thread as it will showcase and highlight the pertinent and valid answers, thereby allowing for a faster problem solution for other users experiencing the same
issues as yourself.

Thanks and Regards

Ashish

Molly P

Hi @ashish.f.singh-Oracle, our consultants did your suggestion, but the columns are still not present. We opened an SR. I will report back here if they have a blanket solution and it's not just our instance causing the issue.

Thanks, Molly

Ashish-Oracle

@Molly P Sure. Please do let us know the answer once you have a confirmation.