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
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
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
Thanks, I created the idea.
Are you aware of any customization we can do to bring these fields in without enabling HCM?
Molly
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.
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…
