Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integrate EBS with Endeca Information Discovery

rrMar 19 2014 — edited Mar 25 2014

Hi all,

I integrated EBS with Oracle Endeca information discovery with the help of the following document Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID 1562372.1).

I need to know how the data is loaded from EBS to Endeca server. In the integration process we are creating data source ebsdb.

In clover page i'm getting the OracleEBScfg.bak file as

user=apps jdbcSpecific=ORACLE password=apps name=aeut2134 database=ORACLE threadSafeConnection=false dbURL=jdbc\:oracle\:thin\:@slc01kxj.us.oracle.com\:1571\:aeut2134 jndiName=

While running ar Sandbox in clover graph getting success. The following documents telling that two views are used by the ETL layer in Endeca to load Receivables data to the Endeca data store

ARI_EID_TRX_V and ARI_EID_CMREQ_V.
Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide

For ARI_EID_TRX_V getting the value but ARI_EID_CMREQ_V this view gives the empty result.

The query behind this view is ARI_EID_CMREQ_V select * from ARI_EID_CMREQ_V.

Please guide me where to check this sql query.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2014

Added on Mar 19 2014

#business-intelligence-applications, #endeca, #endeca-information-discovery, #information-discovery, #server

1 comment

291 views