Source of W_GL_BALANCE_F table in OBIEE DW from PeopleSoft
773966May 19 2010 — edited May 20 2010We are currently implementing OBIEE Financial Analytics as part of a larger PeopleSoft ERP implementation. We tried doing data loads from PeopleSoft to the OBIEE SW out-of-the-box. Subject areas for AR and AP have some data, but others including GL Balances and Profitibility are empty. It appears that the source for much of the OOTB dashboards in these areas is W_GL_BALANCE_F. This table is empty in our warehouse, and I am trying to figure out why. In tracing through some of the Informatica mappings, I cannot determine a source from PeopleSoft that loads this table. Can anyone tell me what PeopleSoft tables are used to populate this part of Financial Analytics?