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.
@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
@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
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?
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
@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.
@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.
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
@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.
@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.
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
@Molly P Sure. Please do let us know the answer once you have a confirmation.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
