SIL_DomainGeneral_CM_Source Fails To Insert Incremental Data When A New Datasource Source Is Added

(Doc ID 2278173.1)

Last updated on NOVEMBER 15, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


New data source added is EBS 12.2 and existing sources were EBS 11.5.10 and EBS 12.1.3.

Issue: SIL_DomainGeneral_CM_Source fails to insert incremental data when a new datasource source is added.

SIL_DomainGeneral_CM_Source uses C_DOMAIN_MEMBER_SRC_INT_VL.LAST_UPDATE_DATE when doing incremental load based on below mentioned where clause. But this date doesn't get updated when we add a new data source in BIACM.
This causes incremental load to miss out on Domains values for newly added datasource.



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms