Loading Additional Source Tables in the OBIApps Warehouse from Taleo Cloud Source

2913977

Hello,

Has anyone tried pulling in Taleo Cloud Source Tables which are not part of the OOTB Load in OBI Apps 11.1.1.10.1?

To explain in detail -

1. The OBI Apps ETL pulls in the data from Taleo Cloud using Cloud Connector Web Services. The Source Table names are passed as parameters to Web Service which replicates the tables in the SDS Schema,

2. The OOTB Load Plans only pull in those Source Tables which populate the OBI Apps Recruitment fact Group. Other Key tables, such as the one holding the User Defined Fields, are left out.

3. There is no documentation on which all variables need to be initialized while running the Web Service Procedure. The standalone run (outside the Generated Load Plan) of the Web Service Procedure fails as it is not able to identify the Web Service Function Calls.

4. The only way I could get it work is by editing the SDS Dev Component of the Load Plan. But there is no documentation available from Oracle which suggests that these direct edits to the Dev Component Load Plans will not get wiped off in case of Future patching exercises.

I am looking for previous experiences or guidelines to load these missing tables.

Thank You

Gaurav