Information on Oracle Embedded Data Warehouse

"I am trying to find information about Oracle EDW, which is supposed to be a datawarehouse out of the box for Oracle applications. Only thing that pops up at Oracle is the warehouse builder FAQ and that is no help. Please send me link to any documentation."

If you've got access to Metalink, there's a section on EDW in the Top Tech Docs area http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=149404.1&blackframe=0

Basically EDW (Embedded Data Warehouse) is a series of patches applied to Apps 11i, that provides as you say an 'out of the box' data warehouse that is maintained and populated by a customised version of OWB. As of EDW 4.1, the version of OWB that's used is 9.0.3, and it comes with prebuilt collectors or mappings to get data out of Apps and in to the EDW warehouse.

The nice thing about the version of OWB that is provided with EDW is that it's got an 'apps integrator', making it easier to get data out of apps (a bit like the SAP integrator, so I hear) that allows you to reference data by it's business definition, rather than the underlying apps table. Apart from licensing EDW, AFAIK there's no other way to get this integrator.