Don't split it into two parts. If you have 11k values that you are pushing into an in-list then there is something not quire right... I presume you're doing this as a data filter? There are alternative ways of doing that whereby you use a join instead, but still use the data filter functionality to control whether that…

What exactly do you mean? There are subject areas on absence, workforce, learning etc... Self service HR is just the mechanism via which information is retrieved/updated by the user or their supervisors. So yes, there is information in OBIA that is also available in self service. It you have a specific question then we…

It doesn't matter in the SDE phase - because that's just loading the staging tables. In the SIL phase, dimensions must be loaded before facts as the lookups are done in the fact load to get the WID's.

The OP won't be able to access your SR. Also, I think Oracle don't allow you to post SR numbers on here for some reason.

In ODI you should be able to see exactly which step of the mapping failed - given the error, I'd say it is either in the index creation stage (for some reason the index wasn't dropped) or one of the temp tables used in data loading already exists. Either way, drilling into the load plan execution will give you a better…

I doubt BI Applications supports using multiple schemas? I can see it causing all kinds of issues, particularly with ODI. Plus - good luck trying to get an SR raised against anything model related. If your concern is that developers will be able to view data they shouldn't be able to on the database, then as Christian Berg…

Your question would probably be better posed in the forum. There are options out there for archiving old data in an EBS environment (you can find some with a simple search on MOS) however none are foolproof and complete. Are you EU based? If so then it would be worth investigating your obligations of GDPR before…

Well, it's Oracle, so you can safely assume it's Cloud and not on-premise. Other than that, if they are one of your customers and you don't know, then I'd be using your internal contacts to get that.

I'd assumed the OP was already using BI Apps given that they have posted in the BI Apps forum. Why wouldn't you have caching on? So long as you manage it correctly between ETL's. If you have a query run 100 times in a day, why go to the database 100 times, when you can go once?

BI Apps is no good for real time reporting (in the absence of GoldenGate - $$$$$). In terms of direct reporting, yes OBIEE is aimed at Star Schema design, however you can report directly off EBS by creating a connection pool to point at that instance and creating your model using direct tables. A better way would probably…

As this is customer facing, have you thought about putting this in a small app on the ODI server? I started something a while back but never got around to finishing it - http://wegobeyond.co.uk/blog/entry/monitoring-oracle-data-integrator-odi-load-plan-executions-with-bi-apps.html. You can make it quite powerful though -…

This is what I referred to above. An excellent document. Oracle Business Intelligence Applications Implementing Human Resources Analytics with Oracle E-Business Suites Adaptors (Doc ID 1326766.1)

Depends on your version of BIApps and your source system. The w_wrkfc_env_month_f is a very complicated table and populated by from numerous different sources. There is an excellent whitepaper available that details all the different steps, but I can't seem to find it on MOS at the moment. I'll get the doc number when I'm…

As Thomas Dodds points out - your catalog folder should point to the presentation services folder and RPD to the server folder. If you have a setup of anything different than that then it is wrong.

First... why are you implementing a version of BI Apps that will be pretty much obsolete in the near future? Surely for a new implementation you'd want to be on the 11.1.1.x product line?

So when you go into the catalog in OBIEE, do you see the folder "Procurement" with a "Purchasing" sub-folder? Have you tried up upgrade the catalog from the Administration page? Have you refreshed the GUIDs?

Have you set up security profiles in EBS to secure the user to just the employees they are allowed to see?

I suspect your implementation partner has not fully configured BI Applications, and to avoid making that blindingly obvious due to none of the seeded analytics working, have simply removed them (one way or another). The bottom line is that the catalog does come as part of OBIA - if I were you I would be demanding that they…

HR to Staff Ratio - Probably Workforce Deployment. Human Capital Cost - Depends on what your definition of this is. Total Earnings - If you're using Payroll and an 11.1.1.x version of BI Apps then you'd just configure a payroll balance in EBS for this. Total Earnings - As above. Average Earnings - Average over what? Again,…

You also have to ensure that you create foreign keys (not defined at the database level though - only in the logical model) between your dimensions and facts.