Oracle has pre-built the ETL, DW, RPD and dashboards/reports for sourcing from EBS and using OBIEE ... even if you don't use the visualizations, you'd be hard pressed to develop the HR fact stars as well as you could buy (+ customize) them.
In addition (and of greater value) the Financial/GL fact stars are conformed with the HR fact stars; this is where you will have a lot of work to do in integrating in the DW -- that's been done in the pre-built solution.
For Hyperion FDMEE we are asking HRMS tables?
This is the Oracle BI community ... for what I know the HR side of FDMEE is sourced from PeopleSoft HCM (and that pretty much exhausts what I know). I would suggest hitting up some implementation partners in the space to see who has done a sourcing from EBS HRMS into FDMEE.
In any case this community isn't the one to ask or get specifics ...
Try in this community: Financial Data Management
This process I am aware of it ( FDMEE is sourced from PeopleSoft HCM ), my doubt is there any special tables to pull the data from EBS_HRMS to FDMEE staging?
I configured with EBS_SERVER_DATA using apps schema & which is working fine,
You should have posted your question to Oracle Hyperion FDM forum and may have gotten a more timely response.
Other members of the board have already provided you the information as per the FDMEE admin documents which states the specific supported ERP systems.
Any system not specifically listed in the documentation would have to been sourced using the Open interface or Universal Data adapter feature of FDMEE.
You can certainly go ahead and log an Oracle SR with the EBS team to get the name of source tables you wish to pull.
You can also log an Oracle SR for a documentation bug if you believe the information should be in a documentation which it does not currently exist in.
Once you got the clarity you needed remember to mark the thread as answered so members can focus on unanswered questions.
Did Your Question Get Answered in My Oracle Support Community (Doc ID 1180503.1)
Any root cause of issue ..pls
I created one model in ODI and the same view data I can see in my ODI using the same logical schema what i used for UDA.
But in FDMEE i am getting same error while saving.
pls help me.
Other than any way to load the EBS -VIEW to FMDEE..kindly suggest me.
I have one doubt regarding UDA setup in odi, Configure JDBC driver and URL based on your technology and DB version....> what system JDBC details should i provide.
Is It EBS or Hyperion DB details...pls reply.
Refer to prior post which specially addresses the initial question of your post.
Once you got clarity you needed from members of the board you should close the thread.
If you have a new issue you should open a new question in the proper forum.
Oracle support team suggested below changes, but after changing the changes also getting same error.
A) Update the Min and Max JVM heap Sizes to Match each other (xms 5120 from xms 128 as an example to increase to 5 GB)
Start > Run > RegEdit
HKEY_LOCAL_MACHINE > Software > Hyperion Solutions > ERPintegrator0 > HyS9AIFWeb_epmsystem1
Locate the JVMOption value for -Xmsxxxm
Locate the JVMOption value for -Xmx5120m
Make sure the two match
B) Verify that the AIF_DataSource JDBC Connection Pool Max is set to a large enough value (depends on number of users)
C Verify that the ODIMASTER JDBC Connection Pool Max is set to the same value as the AIF_Datasource JDC Connection Pool
D) Recycle the FDMEE Web Application
Any other action kindly suggest me.
Any idea root cause of the issue.
"You should have posted your question to Oracle Hyperion FDM forum ..."