SIL_DomainGeneral_CM_Source Fails To Insert Incremental Data When A New Datasource Source Is Added
Last updated on NOVEMBER 15, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 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.
RUN_FULL_INCREMENTAL('#IS_INCREMENTAL',1=1,C_DOMAIN_MEMBER_SRC_INT_VL.LAST_UPDATE_DATE >= TO_DATE_VAR('#LAST_EXTRACT_DATE'))
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