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.
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
