✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com

Trends

Tuesday, 3 October 2017


SIL_PartyOrganizationDimension failure


By on October 03, 2017

Steps to be done on SIL_PartyOrganizationDimension failure



1. When the task SIL_PartyOrganizationDimension fails due to index creation (Post SQL), check the Informatica session log and confirm the same. Once you are sure from the log that the failure is due to duplicates during index creation, proceed to step 2.

2. Open SQL developer and connect to the Production datawarehouse (SO_BAW_PROD).

3. Once connected paste the contents of the embedded file in the SQL worksheet as shown below.



delete from W_PARTY_ORG_D_TMP t1 where exists (select 'x' from W_PARTY_ORG_D_TMP t2 where t2.DATASOURCE_NUM_ID= t1.DATASOURCE_NUM_ID and t2.INTEGRATION_ID= t1.INTEGRATION_ID and t2.rowid > t1.rowid);

create unique index W_PARTY_ORG_D_TMP_U1

on W_PARTY_ORG_D_TMP (INTEGRATION_ID,DATASOURCE_NUM_ID);



commit;



MERGE

/*+ NO_CPU_COSTING

PARALLEL

APPEND */

INTO W_PARTY_ORG_D T USING

(SELECT ROW_WID ,

GEO_WID ,

ACCNT_GEOSTATE_WID ,

ORG_NAME ,

MAIN_PH_NUM ,

ST_ADDRESS1 ,

ST_ADDRESS2 ,

ST_ADDRESS3 ,

ST_ADDRESS4 ,

POSTAL_CODE ,

CITY_NAME ,

CITY_CODE ,

STATE_NAME ,

STATE_CODE ,

COUNTRY_NAME ,

COUNTRY_CODE ,

REGION_NAME ,

REGION_CODE ,

ACTIVE_FLG ,

PROSPECT_FLG ,

SUPPLIER_FLG ,

COMPETITOR_FLG ,

ACCNT_FLG ,

ACCNT_LOC ,

CUST_STATUS_NAME ,

CUST_STATUS_CODE ,

CUST_TYPE_NAME ,

CUST_TYPE_CODE ,

CUST_CAT_NAME ,

CUST_CAT_CODE ,

ANNUAL_REVN_CAT_NAME ,

ANNUAL_REVN_CAT_CODE ,

BASE_CURCY_CD ,

BU_NAME ,

CHANNEL_FLG ,

CHNL_ANNL_SALES ,

CHNL_SALES_GRWTH_NAME ,

CHNL_SALES_GRWTH_CODE ,

DIVN_FLG ,

DIVN_TYPE_NAME ,

DIVN_TYPE_CODE ,

DOM_ULT_DUNS_NUM ,

DUNS_NUM ,

EMP_COUNT ,

EXPERTISE_NAME ,

EXPERTISE_CODE ,

FORMED_DT ,

FRGHT_TERMS_NAME ,

FRGHT_TERMS_CODE ,

GLBLULT_DUNS_NUM ,

HIST_SLS_VOL ,

LINE_OF_BUSINESS ,

NUM_EMPLOY_CAT_NAME ,

NUM_EMPLOY_CAT_CODE ,

ORG_TERR_NAME ,

ORG_FLG ,

ORG_PRTNR_FLG ,

ORG_PRTNR_TIER_NAME ,

ORG_PRTNR_TIER_CODE ,

ORG_PRTNR_TYPE_NAME ,

ORG_PRTNR_TYPE_CODE ,

PAR_DUNS_NUM ,

PAR_INTEGRATION_ID ,

PAR_ORG_NAME ,

PRI_LST_NAME ,

PRTNRSHP_START_DT ,

PRTNR_FLG ,

PRTNR_NAME ,

PRTNR_SALES_RANK ,

PR_COMPETITOR ,

PR_INDUST_NAME ,

PR_ORG_TRGT_MKT ,

PR_PTSHP_MKTSEG ,

PTNTL_SLS_VOL ,

PTSHP_END_DT ,

PTSHP_FEE_PAID_FLG ,

PTSHP_PRTNR_ACCNT ,

PTSHP_RENEWAL_DT ,

PTSHP_SAT_INDEX ,

PTSHP_STAGE_NAME ,

PTSHP_STAGE_CODE ,

PUBLIC_LISTING_FLG ,

REVN_GROWTH_CAT_NAME ,

REVN_GROWTH_CAT_CODE ,

SALES_EMP_CNT ,

SERVICE_EMP_CNT ,

ACCNT_AHA_NUM ,

ACCNT_HIN_NUM ,

CUST_CLASS_NAME ,

CUST_CLASS_CODE ,

CUST_VALUE_NAME ,

CUST_VALUE_CODE ,

AGENCY_FLG ,

AGNC_CONTRACT_DT ,

ANNUAL_REVENUE ,

BOOK_VALUE ,

BRANCH_FLG ,

CALL_FREQUENCY ,

CLIENT_FLG ,

CREDIT_SCORE ,

CRIME_TYPE_NAME ,

CRIME_TYPE_CODE ,

CURR_ASSET ,

CURR_LIAB ,

CUST_END_DT ,

CUST_SINCE_DT ,

DIVIDEND ,

EXCHANGE_LOC ,

FACILITY_FLG ,

FACILITY_TYPE_NAME ,

FACILITY_TYPE_CODE ,

FIFTYTWO_HIGH ,

FIFTYTWO_LOW ,

FIN_METHOD_NAME ,

FIN_METHOD_CODE ,

GROSS_PROFIT ,

GROWTH_HORIZ_NAME ,

GROWTH_HORIZ_CODE ,

GROWTH_OBJ_NAME ,

GROWTH_OBJ_CODE ,

GROWTH_PERCNTG ,

IDENTIFIED_DT ,

INVESTOR_FLG ,

KEY_COMPETITOR ,

LEGAL_FORM_NAME ,

LEGAL_FORM_CODE ,

LOYAL_SCORE1 ,

LOYAL_SCORE2 ,

LOYAL_SCORE3 ,

LOYAL_SCORE4 ,

LOYAL_SCORE5 ,

LOYAL_SCORE6 ,

LOYAL_SCORE7 ,

MARGIN_VS_INDUST_NAME ,

MARGIN_VS_INDUST_CODE ,

MARKET_CLASS_NAME ,

MARKET_CLASS_CODE ,

MARKET_TYPE_NAME ,

MARKET_TYPE_CODE ,

MED_PROC ,

MEMBER_NUM ,

MKT_POTENTIAL ,

MRKT_CAP_PREF_NAME ,

MRKT_CAP_PREF_CODE ,

NET_INCOME ,

NON_CASH_EXP ,

NUMB_OF_BEDS ,

OBJECTIVE_NAME ,

OBJECTIVE_CODE ,

OPER_INCOME ,

PERSIST_RATIO ,

PRIM_MARKET_NAME ,

PRIM_MARKET_CODE ,

PROJ_EPS ,

PR_SPEC_NAME ,

PR_SYN_ID ,

QUICK_RATIO ,

SHARE_OUTST ,

SRV_PROVDR_FLG ,

STAT_REASON_NAME ,

STAT_REASON_CODE ,

TICKER ,

TOTAL_DEBT ,

TOTAL_NET_WORTH ,

TOT_ASSET ,

TOT_LIABILITY ,

TRAIL_EPS ,

U_EXCH_DT ,

U_LOYAL_SCORE5 ,

VOLUME_TR ,

SIC_CODE ,

SIC_NAME ,

GOVT_ID_TYPE ,

GOVT_ID_VALUE ,

DUNNS_SITE_NAME ,

DUNNS_GLOBAL_NAME ,

DUNNS_LEGAL_NAME ,

CUSTOMER_NUM ,

ALT_CUSTOMER_NUM ,

ALT_PHONE_NUM ,

INTERNET_HOME_PAGE ,

LEGAL_STRUCT_NAME ,

LEGAL_STRUCT_CODE ,

DIRECT_MKTG_FLG ,

SOLICITATION_FLG ,

VIS_PR_BU_ID ,

VIS_PR_POS_ID ,

VIS_PR_POSTN_DH_WID ,

SETID_CUSTOMER ,

SETID_VENDOR ,

SUPPLIER_ID ,

PARENT_SUPPLIER_ID ,

SUPPLIER_NUM ,

SUPPLIER_GROUP_NAME ,

SUPPLIER_GROUP_CODE ,

SUPPLIER_CONTACT_NAME ,

SUPPLIER_TYPE_NAME ,

SUPPLIER_TYPE_CODE ,

MINORITY_GROUP_NAME ,

MINORITY_GROUP_CODE ,

SUPPLIER_SEARCH_STR ,

PREF_ORDER_METHOD ,

SUPPLIER_EXT_NETWORK_ID ,

SUPPLIER_ACTIVE_FLG ,

SUPPLIER_ONE_TIME_FLG ,

OOB_IND ,

MINORITY_OWNED_IND ,

WOMAN_OWNED_IND ,

SMALL_BUS_IND ,

YR_ESTABLISHED ,

DB_RATING ,

INTERNAL_FLG ,

FLEX_ATTRIB_1_CHAR ,

FLEX_ATTRIB_2_CHAR ,

FLEX_ATTRIB_3_CHAR ,

FLEX_ATTRIB_4_CHAR ,

FLEX_ATTRIB_5_CHAR ,

FLEX_ATTRIB_6_CHAR ,

FLEX_ATTRIB_7_CHAR ,

FLEX_ATTRIB_8_CHAR ,

FLEX_ATTRIB_9_CHAR ,

FLEX_ATTRIB_10_CHAR ,

FLEX_ATTRIB_11_CHAR ,

FLEX_ATTRIB_12_CHAR ,

FLEX_ATTRIB_13_CHAR ,

FLEX_ATTRIB_14_CHAR ,

FLEX_ATTRIB_15_CHAR ,

FLEX_ATTRIB_16_CHAR ,

FLEX_ATTRIB_17_CHAR ,

FLEX_ATTRIB_18_CHAR ,

FLEX_ATTRIB_19_CHAR ,

FLEX_ATTRIB_20_CHAR ,

CREATED_BY_WID ,

CHANGED_BY_WID ,

CREATED_ON_DT ,

CHANGED_ON_DT ,

AUX1_CHANGED_ON_DT ,

AUX2_CHANGED_ON_DT ,

AUX3_CHANGED_ON_DT ,

AUX4_CHANGED_ON_DT ,

SRC_EFF_FROM_DT ,

SRC_EFF_TO_DT ,

EFFECTIVE_FROM_DT ,

EFFECTIVE_TO_DT ,

DELETE_FLG ,

CURRENT_FLG ,

W_INSERT_DT ,

W_UPDATE_DT ,

DATASOURCE_NUM_ID ,

ETL_PROC_WID ,

INTEGRATION_ID ,

TENANT_ID ,

X_CUSTOM ,

ACCNT_REGION ,

X_COMPANY_REG_NUM

FROM W_PARTY_ORG_D_TMP

) S ON (T.INTEGRATION_ID = S.INTEGRATION_ID AND T.DATASOURCE_NUM_ID = S.DATASOURCE_NUM_ID)

WHEN MATCHED THEN

UPDATE

SET

T.GEO_WID =S.GEO_WID ,

T.ACCNT_GEOSTATE_WID =S.ACCNT_GEOSTATE_WID ,

T.ORG_NAME =S.ORG_NAME ,

T.MAIN_PH_NUM =S.MAIN_PH_NUM ,

T.ST_ADDRESS1 =S.ST_ADDRESS1 ,

T.ST_ADDRESS2 =S.ST_ADDRESS2 ,

T.ST_ADDRESS3 =S.ST_ADDRESS3 ,

T.ST_ADDRESS4 =S.ST_ADDRESS4 ,

T.POSTAL_CODE =S.POSTAL_CODE ,

T.CITY_NAME =S.CITY_NAME ,

T.CITY_CODE =S.CITY_CODE ,

T.STATE_NAME =S.STATE_NAME ,

T.STATE_CODE =S.STATE_CODE ,

T.COUNTRY_NAME =S.COUNTRY_NAME ,

T.COUNTRY_CODE =S.COUNTRY_CODE ,

T.REGION_NAME =S.REGION_NAME ,

T.REGION_CODE =S.REGION_CODE ,

T.ACTIVE_FLG =S.ACTIVE_FLG ,

T.PROSPECT_FLG =S.PROSPECT_FLG ,

T.SUPPLIER_FLG =S.SUPPLIER_FLG ,

T.COMPETITOR_FLG =S.COMPETITOR_FLG ,

T.ACCNT_FLG =S.ACCNT_FLG ,

T.ACCNT_LOC =S.ACCNT_LOC ,

T.CUST_STATUS_NAME =S.CUST_STATUS_NAME ,

T.CUST_STATUS_CODE =S.CUST_STATUS_CODE ,

T.CUST_TYPE_NAME =S.CUST_TYPE_NAME ,

T.CUST_TYPE_CODE =S.CUST_TYPE_CODE ,

T.CUST_CAT_NAME =S.CUST_CAT_NAME ,

T.CUST_CAT_CODE =S.CUST_CAT_CODE ,

T.ANNUAL_REVN_CAT_NAME =S.ANNUAL_REVN_CAT_NAME ,

T.ANNUAL_REVN_CAT_CODE =S.ANNUAL_REVN_CAT_CODE ,

T.BASE_CURCY_CD =S.BASE_CURCY_CD ,

T.BU_NAME =S.BU_NAME ,

T.CHANNEL_FLG =S.CHANNEL_FLG ,

T.CHNL_ANNL_SALES =S.CHNL_ANNL_SALES ,

T.CHNL_SALES_GRWTH_NAME =S.CHNL_SALES_GRWTH_NAME ,

T.CHNL_SALES_GRWTH_CODE =S.CHNL_SALES_GRWTH_CODE ,

T.DIVN_FLG =S.DIVN_FLG ,

T.DIVN_TYPE_NAME =S.DIVN_TYPE_NAME ,

T.DIVN_TYPE_CODE =S.DIVN_TYPE_CODE ,

T.DOM_ULT_DUNS_NUM =S.DOM_ULT_DUNS_NUM ,

T.DUNS_NUM =S.DUNS_NUM ,

T.EMP_COUNT =S.EMP_COUNT ,

T.EXPERTISE_NAME =S.EXPERTISE_NAME ,

T.EXPERTISE_CODE =S.EXPERTISE_CODE ,

T.FORMED_DT =S.FORMED_DT ,

T.FRGHT_TERMS_NAME =S.FRGHT_TERMS_NAME ,

T.FRGHT_TERMS_CODE =S.FRGHT_TERMS_CODE ,

T.GLBLULT_DUNS_NUM =S.GLBLULT_DUNS_NUM ,

T.HIST_SLS_VOL =S.HIST_SLS_VOL ,

T.LINE_OF_BUSINESS =S.LINE_OF_BUSINESS ,

T.NUM_EMPLOY_CAT_NAME =S.NUM_EMPLOY_CAT_NAME ,

T.NUM_EMPLOY_CAT_CODE =S.NUM_EMPLOY_CAT_CODE ,

T.ORG_TERR_NAME =S.ORG_TERR_NAME ,

T.ORG_FLG =S.ORG_FLG ,

T.ORG_PRTNR_FLG =S.ORG_PRTNR_FLG ,

T.ORG_PRTNR_TIER_NAME =S.ORG_PRTNR_TIER_NAME ,

T.ORG_PRTNR_TIER_CODE =S.ORG_PRTNR_TIER_CODE ,

T.ORG_PRTNR_TYPE_NAME =S.ORG_PRTNR_TYPE_NAME ,

T.ORG_PRTNR_TYPE_CODE =S.ORG_PRTNR_TYPE_CODE ,

T.PAR_DUNS_NUM =S.PAR_DUNS_NUM ,

T.PAR_INTEGRATION_ID =S.PAR_INTEGRATION_ID ,

T.PAR_ORG_NAME =S.PAR_ORG_NAME ,

T.PRI_LST_NAME =S.PRI_LST_NAME ,

T.PRTNRSHP_START_DT =S.PRTNRSHP_START_DT ,

T.PRTNR_FLG =S.PRTNR_FLG ,

T.PRTNR_NAME =S.PRTNR_NAME ,

T.PRTNR_SALES_RANK =S.PRTNR_SALES_RANK ,

T.PR_COMPETITOR =S.PR_COMPETITOR ,

T.PR_INDUST_NAME =S.PR_INDUST_NAME ,

T.PR_ORG_TRGT_MKT =S.PR_ORG_TRGT_MKT ,

T.PR_PTSHP_MKTSEG =S.PR_PTSHP_MKTSEG ,

T.PTNTL_SLS_VOL =S.PTNTL_SLS_VOL ,

T.PTSHP_END_DT =S.PTSHP_END_DT ,

T.PTSHP_FEE_PAID_FLG =S.PTSHP_FEE_PAID_FLG ,

T.PTSHP_PRTNR_ACCNT =S.PTSHP_PRTNR_ACCNT ,

T.PTSHP_RENEWAL_DT =S.PTSHP_RENEWAL_DT ,

T.PTSHP_SAT_INDEX =S.PTSHP_SAT_INDEX ,

T.PTSHP_STAGE_NAME =S.PTSHP_STAGE_NAME ,

T.PTSHP_STAGE_CODE =S.PTSHP_STAGE_CODE ,

T.PUBLIC_LISTING_FLG =S.PUBLIC_LISTING_FLG ,

T.REVN_GROWTH_CAT_NAME =S.REVN_GROWTH_CAT_NAME ,

T.REVN_GROWTH_CAT_CODE =S.REVN_GROWTH_CAT_CODE ,

T.SALES_EMP_CNT =S.SALES_EMP_CNT ,

T.SERVICE_EMP_CNT =S.SERVICE_EMP_CNT ,

T.ACCNT_AHA_NUM =S.ACCNT_AHA_NUM ,

T.ACCNT_HIN_NUM =S.ACCNT_HIN_NUM ,

T.CUST_CLASS_NAME =S.CUST_CLASS_NAME ,

T.CUST_CLASS_CODE =S.CUST_CLASS_CODE ,

T.CUST_VALUE_NAME =S.CUST_VALUE_NAME ,

T.CUST_VALUE_CODE =S.CUST_VALUE_CODE ,

T.AGENCY_FLG =S.AGENCY_FLG ,

T.AGNC_CONTRACT_DT =S.AGNC_CONTRACT_DT ,

T.ANNUAL_REVENUE =S.ANNUAL_REVENUE ,

T.BOOK_VALUE =S.BOOK_VALUE ,

T.BRANCH_FLG =S.BRANCH_FLG ,

T.CALL_FREQUENCY =S.CALL_FREQUENCY ,

T.CLIENT_FLG =S.CLIENT_FLG ,

T.CREDIT_SCORE =S.CREDIT_SCORE ,

T.CRIME_TYPE_NAME =S.CRIME_TYPE_NAME ,

T.CRIME_TYPE_CODE =S.CRIME_TYPE_CODE ,

T.CURR_ASSET =S.CURR_ASSET ,

T.CURR_LIAB =S.CURR_LIAB ,

T.CUST_END_DT =S.CUST_END_DT ,

T.CUST_SINCE_DT =S.CUST_SINCE_DT ,

T.DIVIDEND =S.DIVIDEND ,

T.EXCHANGE_LOC =S.EXCHANGE_LOC ,

T.FACILITY_FLG =S.FACILITY_FLG ,

T.FACILITY_TYPE_NAME =S.FACILITY_TYPE_NAME ,

T.FACILITY_TYPE_CODE =S.FACILITY_TYPE_CODE ,

T.FIFTYTWO_HIGH =S.FIFTYTWO_HIGH ,

T.FIFTYTWO_LOW =S.FIFTYTWO_LOW ,

T.FIN_METHOD_NAME =S.FIN_METHOD_NAME ,

T.FIN_METHOD_CODE =S.FIN_METHOD_CODE ,

T.GROSS_PROFIT =S.GROSS_PROFIT ,

T.GROWTH_HORIZ_NAME =S.GROWTH_HORIZ_NAME ,

T.GROWTH_HORIZ_CODE =S.GROWTH_HORIZ_CODE ,

T.GROWTH_OBJ_NAME =S.GROWTH_OBJ_NAME ,

T.GROWTH_OBJ_CODE =S.GROWTH_OBJ_CODE ,

T.GROWTH_PERCNTG =S.GROWTH_PERCNTG ,

T.IDENTIFIED_DT =S.IDENTIFIED_DT ,

T.INVESTOR_FLG =S.INVESTOR_FLG ,

T.KEY_COMPETITOR =S.KEY_COMPETITOR ,

T.LEGAL_FORM_NAME =S.LEGAL_FORM_NAME ,

T.LEGAL_FORM_CODE =S.LEGAL_FORM_CODE ,

T.LOYAL_SCORE1 =S.LOYAL_SCORE1 ,

T.LOYAL_SCORE2 =S.LOYAL_SCORE2 ,

T.LOYAL_SCORE3 =S.LOYAL_SCORE3 ,

T.LOYAL_SCORE4 =S.LOYAL_SCORE4 ,

T.LOYAL_SCORE5 =S.LOYAL_SCORE5 ,

T.LOYAL_SCORE6 =S.LOYAL_SCORE6 ,

T.LOYAL_SCORE7 =S.LOYAL_SCORE7 ,

T.MARGIN_VS_INDUST_NAME =S.MARGIN_VS_INDUST_NAME ,

T.MARGIN_VS_INDUST_CODE =S.MARGIN_VS_INDUST_CODE ,

T.MARKET_CLASS_NAME =S.MARKET_CLASS_NAME ,

T.MARKET_CLASS_CODE =S.MARKET_CLASS_CODE ,

T.MARKET_TYPE_NAME =S.MARKET_TYPE_NAME ,

T.MARKET_TYPE_CODE =S.MARKET_TYPE_CODE ,

T.MED_PROC =S.MED_PROC ,

T.MEMBER_NUM =S.MEMBER_NUM ,

T.MKT_POTENTIAL =S.MKT_POTENTIAL ,

T.MRKT_CAP_PREF_NAME =S.MRKT_CAP_PREF_NAME ,

T.MRKT_CAP_PREF_CODE =S.MRKT_CAP_PREF_CODE ,

T.NET_INCOME =S.NET_INCOME ,

T.NON_CASH_EXP =S.NON_CASH_EXP ,

T.NUMB_OF_BEDS =S.NUMB_OF_BEDS ,

T.OBJECTIVE_NAME =S.OBJECTIVE_NAME ,

T.OBJECTIVE_CODE =S.OBJECTIVE_CODE ,

T.OPER_INCOME =S.OPER_INCOME ,

T.PERSIST_RATIO =S.PERSIST_RATIO ,

T.PRIM_MARKET_NAME =S.PRIM_MARKET_NAME ,

T.PRIM_MARKET_CODE =S.PRIM_MARKET_CODE ,

T.PROJ_EPS =S.PROJ_EPS ,

T.PR_SPEC_NAME =S.PR_SPEC_NAME ,

T.PR_SYN_ID =S.PR_SYN_ID ,

T.QUICK_RATIO =S.QUICK_RATIO ,

T.SHARE_OUTST =S.SHARE_OUTST ,

T.SRV_PROVDR_FLG =S.SRV_PROVDR_FLG ,

T.STAT_REASON_NAME =S.STAT_REASON_NAME ,

T.STAT_REASON_CODE =S.STAT_REASON_CODE ,

T.TICKER =S.TICKER ,

T.TOTAL_DEBT =S.TOTAL_DEBT ,

T.TOTAL_NET_WORTH =S.TOTAL_NET_WORTH ,

T.TOT_ASSET =S.TOT_ASSET ,

T.TOT_LIABILITY =S.TOT_LIABILITY ,

T.TRAIL_EPS =S.TRAIL_EPS ,

T.U_EXCH_DT =S.U_EXCH_DT ,

T.U_LOYAL_SCORE5 =S.U_LOYAL_SCORE5 ,

T.VOLUME_TR =S.VOLUME_TR ,

T.SIC_CODE =S.SIC_CODE ,

T.SIC_NAME =S.SIC_NAME ,

T.GOVT_ID_TYPE =S.GOVT_ID_TYPE ,

T.GOVT_ID_VALUE =S.GOVT_ID_VALUE ,

T.DUNNS_SITE_NAME =S.DUNNS_SITE_NAME ,

T.DUNNS_GLOBAL_NAME =S.DUNNS_GLOBAL_NAME ,

T.DUNNS_LEGAL_NAME =S.DUNNS_LEGAL_NAME ,

T.CUSTOMER_NUM =S.CUSTOMER_NUM ,

T.ALT_CUSTOMER_NUM =S.ALT_CUSTOMER_NUM ,

T.ALT_PHONE_NUM =S.ALT_PHONE_NUM ,

T.INTERNET_HOME_PAGE =S.INTERNET_HOME_PAGE ,

T.LEGAL_STRUCT_NAME =S.LEGAL_STRUCT_NAME ,

T.LEGAL_STRUCT_CODE =S.LEGAL_STRUCT_CODE ,

T.DIRECT_MKTG_FLG =S.DIRECT_MKTG_FLG ,

T.SOLICITATION_FLG =S.SOLICITATION_FLG ,

T.VIS_PR_BU_ID =S.VIS_PR_BU_ID ,

T.VIS_PR_POS_ID =S.VIS_PR_POS_ID ,

T.VIS_PR_POSTN_DH_WID =S.VIS_PR_POSTN_DH_WID ,

T.SETID_CUSTOMER =S.SETID_CUSTOMER ,

T.SETID_VENDOR =S.SETID_VENDOR ,

T.SUPPLIER_ID =S.SUPPLIER_ID ,

T.PARENT_SUPPLIER_ID =S.PARENT_SUPPLIER_ID ,

T.SUPPLIER_NUM =S.SUPPLIER_NUM ,

T.SUPPLIER_GROUP_NAME =S.SUPPLIER_GROUP_NAME ,

T.SUPPLIER_GROUP_CODE =S.SUPPLIER_GROUP_CODE ,

T.SUPPLIER_CONTACT_NAME =S.SUPPLIER_CONTACT_NAME ,

T.SUPPLIER_TYPE_NAME =S.SUPPLIER_TYPE_NAME ,

T.SUPPLIER_TYPE_CODE =S.SUPPLIER_TYPE_CODE ,

T.MINORITY_GROUP_NAME =S.MINORITY_GROUP_NAME ,

T.MINORITY_GROUP_CODE =S.MINORITY_GROUP_CODE ,

T.SUPPLIER_SEARCH_STR =S.SUPPLIER_SEARCH_STR ,

T.PREF_ORDER_METHOD =S.PREF_ORDER_METHOD ,

T.SUPPLIER_EXT_NETWORK_ID =S.SUPPLIER_EXT_NETWORK_ID ,

T.SUPPLIER_ACTIVE_FLG =S.SUPPLIER_ACTIVE_FLG ,

T.SUPPLIER_ONE_TIME_FLG =S.SUPPLIER_ONE_TIME_FLG ,

T.OOB_IND =S.OOB_IND ,

T.MINORITY_OWNED_IND =S.MINORITY_OWNED_IND ,

T.WOMAN_OWNED_IND =S.WOMAN_OWNED_IND ,

T.SMALL_BUS_IND =S.SMALL_BUS_IND ,

T.YR_ESTABLISHED =S.YR_ESTABLISHED ,

T.DB_RATING =S.DB_RATING ,

T.INTERNAL_FLG =S.INTERNAL_FLG ,

T.FLEX_ATTRIB_1_CHAR =S.FLEX_ATTRIB_1_CHAR ,

T.FLEX_ATTRIB_2_CHAR =S.FLEX_ATTRIB_2_CHAR ,

T.FLEX_ATTRIB_3_CHAR =S.FLEX_ATTRIB_3_CHAR ,

T.FLEX_ATTRIB_4_CHAR =S.FLEX_ATTRIB_4_CHAR ,

T.FLEX_ATTRIB_5_CHAR =S.FLEX_ATTRIB_5_CHAR ,

T.FLEX_ATTRIB_6_CHAR =S.FLEX_ATTRIB_6_CHAR ,

T.FLEX_ATTRIB_7_CHAR =S.FLEX_ATTRIB_7_CHAR ,

T.FLEX_ATTRIB_8_CHAR =S.FLEX_ATTRIB_8_CHAR ,

T.FLEX_ATTRIB_9_CHAR =S.FLEX_ATTRIB_9_CHAR ,

T.FLEX_ATTRIB_10_CHAR =S.FLEX_ATTRIB_10_CHAR ,

T.FLEX_ATTRIB_11_CHAR =S.FLEX_ATTRIB_11_CHAR ,

T.FLEX_ATTRIB_12_CHAR =S.FLEX_ATTRIB_12_CHAR ,

T.FLEX_ATTRIB_13_CHAR =S.FLEX_ATTRIB_13_CHAR ,

T.FLEX_ATTRIB_14_CHAR =S.FLEX_ATTRIB_14_CHAR ,

T.FLEX_ATTRIB_15_CHAR =S.FLEX_ATTRIB_15_CHAR ,

T.FLEX_ATTRIB_16_CHAR =S.FLEX_ATTRIB_16_CHAR ,

T.FLEX_ATTRIB_17_CHAR =S.FLEX_ATTRIB_17_CHAR ,

T.FLEX_ATTRIB_18_CHAR =S.FLEX_ATTRIB_18_CHAR ,

T.FLEX_ATTRIB_19_CHAR =S.FLEX_ATTRIB_19_CHAR ,

T.FLEX_ATTRIB_20_CHAR =S.FLEX_ATTRIB_20_CHAR ,

T.CREATED_BY_WID =S.CREATED_BY_WID ,

T.CHANGED_BY_WID =S.CHANGED_BY_WID ,

T.CREATED_ON_DT =S.CREATED_ON_DT ,

T.CHANGED_ON_DT =S.CHANGED_ON_DT ,

T.AUX1_CHANGED_ON_DT =S.AUX1_CHANGED_ON_DT ,

T.AUX2_CHANGED_ON_DT =S.AUX2_CHANGED_ON_DT ,

T.AUX3_CHANGED_ON_DT =S.AUX3_CHANGED_ON_DT ,

T.AUX4_CHANGED_ON_DT =S.AUX4_CHANGED_ON_DT ,

T.SRC_EFF_FROM_DT =S.SRC_EFF_FROM_DT ,

T.SRC_EFF_TO_DT =S.SRC_EFF_TO_DT ,

T.EFFECTIVE_FROM_DT =S.EFFECTIVE_FROM_DT ,

T.EFFECTIVE_TO_DT =S.EFFECTIVE_TO_DT ,

T.DELETE_FLG =S.DELETE_FLG ,

T.CURRENT_FLG =S.CURRENT_FLG ,

T.W_UPDATE_DT =S.W_UPDATE_DT ,

T.ETL_PROC_WID =S.ETL_PROC_WID ,

T.TENANT_ID =S.TENANT_ID ,

T.X_CUSTOM =S.X_CUSTOM ,

T.ACCNT_REGION =S.ACCNT_REGION ,

T.X_COMPANY_REG_NUM =S.X_COMPANY_REG_NUM WHEN NOT MATCHED THEN

INSERT

(

T.ROW_WID ,

T.GEO_WID ,

T.ACCNT_GEOSTATE_WID ,

T.ORG_NAME ,

T.MAIN_PH_NUM ,

T.ST_ADDRESS1 ,

T.ST_ADDRESS2 ,

T.ST_ADDRESS3 ,

T.ST_ADDRESS4 ,

T.POSTAL_CODE ,

T.CITY_NAME ,

T.CITY_CODE ,

T.STATE_NAME ,

T.STATE_CODE ,

T.COUNTRY_NAME ,

T.COUNTRY_CODE ,

T.REGION_NAME ,

T.REGION_CODE ,

T.ACTIVE_FLG ,

T.PROSPECT_FLG ,

T.SUPPLIER_FLG ,

T.COMPETITOR_FLG ,

T.ACCNT_FLG ,

T.ACCNT_LOC ,

T.CUST_STATUS_NAME ,

T.CUST_STATUS_CODE ,

T.CUST_TYPE_NAME ,

T.CUST_TYPE_CODE ,

T.CUST_CAT_NAME ,

T.CUST_CAT_CODE ,

T.ANNUAL_REVN_CAT_NAME ,

T.ANNUAL_REVN_CAT_CODE ,

T.BASE_CURCY_CD ,

T.BU_NAME ,

T.CHANNEL_FLG ,

T.CHNL_ANNL_SALES ,

T.CHNL_SALES_GRWTH_NAME ,

T.CHNL_SALES_GRWTH_CODE ,

T.DIVN_FLG ,

T.DIVN_TYPE_NAME ,

T.DIVN_TYPE_CODE ,

T.DOM_ULT_DUNS_NUM ,

T.DUNS_NUM ,

T.EMP_COUNT ,

T.EXPERTISE_NAME ,

T.EXPERTISE_CODE ,

T.FORMED_DT ,

T.FRGHT_TERMS_NAME ,

T.FRGHT_TERMS_CODE ,

T.GLBLULT_DUNS_NUM ,

T.HIST_SLS_VOL ,

T.LINE_OF_BUSINESS ,

T.NUM_EMPLOY_CAT_NAME ,

T.NUM_EMPLOY_CAT_CODE ,

T.ORG_TERR_NAME ,

T.ORG_FLG ,

T.ORG_PRTNR_FLG ,

T.ORG_PRTNR_TIER_NAME ,

T.ORG_PRTNR_TIER_CODE ,

T.ORG_PRTNR_TYPE_NAME ,

T.ORG_PRTNR_TYPE_CODE ,

T.PAR_DUNS_NUM ,

T.PAR_INTEGRATION_ID ,

T.PAR_ORG_NAME ,

T.PRI_LST_NAME ,

T.PRTNRSHP_START_DT ,

T.PRTNR_FLG ,

T.PRTNR_NAME ,

T.PRTNR_SALES_RANK ,

T.PR_COMPETITOR ,

T.PR_INDUST_NAME ,

T.PR_ORG_TRGT_MKT ,

T.PR_PTSHP_MKTSEG ,

T.PTNTL_SLS_VOL ,

T.PTSHP_END_DT ,

T.PTSHP_FEE_PAID_FLG ,

T.PTSHP_PRTNR_ACCNT ,

T.PTSHP_RENEWAL_DT ,

T.PTSHP_SAT_INDEX ,

T.PTSHP_STAGE_NAME ,

T.PTSHP_STAGE_CODE ,

T.PUBLIC_LISTING_FLG ,

T.REVN_GROWTH_CAT_NAME ,

T.REVN_GROWTH_CAT_CODE ,

T.SALES_EMP_CNT ,

T.SERVICE_EMP_CNT ,

T.ACCNT_AHA_NUM ,

T.ACCNT_HIN_NUM ,

T.CUST_CLASS_NAME ,

T.CUST_CLASS_CODE ,

T.CUST_VALUE_NAME ,

T.CUST_VALUE_CODE ,

T.AGENCY_FLG ,

T.AGNC_CONTRACT_DT ,

T.ANNUAL_REVENUE ,

T.BOOK_VALUE ,

T.BRANCH_FLG ,

T.CALL_FREQUENCY ,

T.CLIENT_FLG ,

T.CREDIT_SCORE ,

T.CRIME_TYPE_NAME ,

T.CRIME_TYPE_CODE ,

T.CURR_ASSET ,

T.CURR_LIAB ,

T.CUST_END_DT ,

T.CUST_SINCE_DT ,

T.DIVIDEND ,

T.EXCHANGE_LOC ,

T.FACILITY_FLG ,

T.FACILITY_TYPE_NAME ,

T.FACILITY_TYPE_CODE ,

T.FIFTYTWO_HIGH ,

T.FIFTYTWO_LOW ,

T.FIN_METHOD_NAME ,

T.FIN_METHOD_CODE ,

T.GROSS_PROFIT ,

T.GROWTH_HORIZ_NAME ,

T.GROWTH_HORIZ_CODE ,

T.GROWTH_OBJ_NAME ,

T.GROWTH_OBJ_CODE ,

T.GROWTH_PERCNTG ,

T.IDENTIFIED_DT ,

T.INVESTOR_FLG ,

T.KEY_COMPETITOR ,

T.LEGAL_FORM_NAME ,

T.LEGAL_FORM_CODE ,

T.LOYAL_SCORE1 ,

T.LOYAL_SCORE2 ,

T.LOYAL_SCORE3 ,

T.LOYAL_SCORE4 ,

T.LOYAL_SCORE5 ,

T.LOYAL_SCORE6 ,

T.LOYAL_SCORE7 ,

T.MARGIN_VS_INDUST_NAME ,

T.MARGIN_VS_INDUST_CODE ,

T.MARKET_CLASS_NAME ,

T.MARKET_CLASS_CODE ,

T.MARKET_TYPE_NAME ,

T.MARKET_TYPE_CODE ,

T.MED_PROC ,

T.MEMBER_NUM ,

T.MKT_POTENTIAL ,

T.MRKT_CAP_PREF_NAME ,

T.MRKT_CAP_PREF_CODE ,

T.NET_INCOME ,

T.NON_CASH_EXP ,

T.NUMB_OF_BEDS ,

T.OBJECTIVE_NAME ,

T.OBJECTIVE_CODE ,

T.OPER_INCOME ,

T.PERSIST_RATIO ,

T.PRIM_MARKET_NAME ,

T.PRIM_MARKET_CODE ,

T.PROJ_EPS ,

T.PR_SPEC_NAME ,

T.PR_SYN_ID ,

T.QUICK_RATIO ,

T.SHARE_OUTST ,

T.SRV_PROVDR_FLG ,

T.STAT_REASON_NAME ,

T.STAT_REASON_CODE ,

T.TICKER ,

T.TOTAL_DEBT ,

T.TOTAL_NET_WORTH ,

T.TOT_ASSET ,

T.TOT_LIABILITY ,

T.TRAIL_EPS ,

T.U_EXCH_DT ,

T.U_LOYAL_SCORE5 ,

T.VOLUME_TR ,

T.SIC_CODE ,

T.SIC_NAME ,

T.GOVT_ID_TYPE ,

T.GOVT_ID_VALUE ,

T.DUNNS_SITE_NAME ,

T.DUNNS_GLOBAL_NAME ,

T.DUNNS_LEGAL_NAME ,

T.CUSTOMER_NUM ,

T.ALT_CUSTOMER_NUM ,

T.ALT_PHONE_NUM ,

T.INTERNET_HOME_PAGE ,

T.LEGAL_STRUCT_NAME ,

T.LEGAL_STRUCT_CODE ,

T.DIRECT_MKTG_FLG ,

T.SOLICITATION_FLG ,

T.VIS_PR_BU_ID ,

T.VIS_PR_POS_ID ,

T.VIS_PR_POSTN_DH_WID ,

T.SETID_CUSTOMER ,

T.SETID_VENDOR ,

T.SUPPLIER_ID ,

T.PARENT_SUPPLIER_ID ,

T.SUPPLIER_NUM ,

T.SUPPLIER_GROUP_NAME ,

T.SUPPLIER_GROUP_CODE ,

T.SUPPLIER_CONTACT_NAME ,

T.SUPPLIER_TYPE_NAME ,

T.SUPPLIER_TYPE_CODE ,

T.MINORITY_GROUP_NAME ,

T.MINORITY_GROUP_CODE ,

T.SUPPLIER_SEARCH_STR ,

T.PREF_ORDER_METHOD ,

T.SUPPLIER_EXT_NETWORK_ID ,

T.SUPPLIER_ACTIVE_FLG ,

T.SUPPLIER_ONE_TIME_FLG ,

T.OOB_IND ,

T.MINORITY_OWNED_IND ,

T.WOMAN_OWNED_IND ,

T.SMALL_BUS_IND ,

T.YR_ESTABLISHED ,

T.DB_RATING ,

T.INTERNAL_FLG ,

T.FLEX_ATTRIB_1_CHAR ,

T.FLEX_ATTRIB_2_CHAR ,

T.FLEX_ATTRIB_3_CHAR ,

T.FLEX_ATTRIB_4_CHAR ,

T.FLEX_ATTRIB_5_CHAR ,

T.FLEX_ATTRIB_6_CHAR ,

T.FLEX_ATTRIB_7_CHAR ,

T.FLEX_ATTRIB_8_CHAR ,

T.FLEX_ATTRIB_9_CHAR ,

T.FLEX_ATTRIB_10_CHAR ,

T.FLEX_ATTRIB_11_CHAR ,

T.FLEX_ATTRIB_12_CHAR ,

T.FLEX_ATTRIB_13_CHAR ,

T.FLEX_ATTRIB_14_CHAR ,

T.FLEX_ATTRIB_15_CHAR ,

T.FLEX_ATTRIB_16_CHAR ,

T.FLEX_ATTRIB_17_CHAR ,

T.FLEX_ATTRIB_18_CHAR ,

T.FLEX_ATTRIB_19_CHAR ,

T.FLEX_ATTRIB_20_CHAR ,

T.CREATED_BY_WID ,

T.CHANGED_BY_WID ,

T.CREATED_ON_DT ,

T.CHANGED_ON_DT ,

T.AUX1_CHANGED_ON_DT ,

T.AUX2_CHANGED_ON_DT ,

T.AUX3_CHANGED_ON_DT ,

T.AUX4_CHANGED_ON_DT ,

T.SRC_EFF_FROM_DT ,

T.SRC_EFF_TO_DT ,

T.EFFECTIVE_FROM_DT ,

T.EFFECTIVE_TO_DT ,

T.DELETE_FLG ,

T.CURRENT_FLG ,

T.W_INSERT_DT ,

T.W_UPDATE_DT ,

T.DATASOURCE_NUM_ID ,

T.ETL_PROC_WID ,

T.INTEGRATION_ID ,

T.TENANT_ID ,

T.X_CUSTOM ,

T.ACCNT_REGION ,

T.X_COMPANY_REG_NUM

)

VALUES

(

S.ROW_WID ,

S.GEO_WID ,

S.ACCNT_GEOSTATE_WID ,

S.ORG_NAME ,

S.MAIN_PH_NUM ,

S.ST_ADDRESS1 ,

S.ST_ADDRESS2 ,

S.ST_ADDRESS3 ,

S.ST_ADDRESS4 ,

S.POSTAL_CODE ,

S.CITY_NAME ,

S.CITY_CODE ,

S.STATE_NAME ,

S.STATE_CODE ,

S.COUNTRY_NAME ,

S.COUNTRY_CODE ,

S.REGION_NAME ,

S.REGION_CODE ,

S.ACTIVE_FLG ,

S.PROSPECT_FLG ,

S.SUPPLIER_FLG ,

S.COMPETITOR_FLG ,

S.ACCNT_FLG ,

S.ACCNT_LOC ,

S.CUST_STATUS_NAME ,

S.CUST_STATUS_CODE ,

S.CUST_TYPE_NAME ,

S.CUST_TYPE_CODE ,

S.CUST_CAT_NAME ,

S.CUST_CAT_CODE ,

S.ANNUAL_REVN_CAT_NAME ,

S.ANNUAL_REVN_CAT_CODE ,

S.BASE_CURCY_CD ,

S.BU_NAME ,

S.CHANNEL_FLG ,

S.CHNL_ANNL_SALES ,

S.CHNL_SALES_GRWTH_NAME ,

S.CHNL_SALES_GRWTH_CODE ,

S.DIVN_FLG ,

S.DIVN_TYPE_NAME ,

S.DIVN_TYPE_CODE ,

S.DOM_ULT_DUNS_NUM ,

S.DUNS_NUM ,

S.EMP_COUNT ,

S.EXPERTISE_NAME ,

S.EXPERTISE_CODE ,

S.FORMED_DT ,

S.FRGHT_TERMS_NAME ,

S.FRGHT_TERMS_CODE ,

S.GLBLULT_DUNS_NUM ,

S.HIST_SLS_VOL ,

S.LINE_OF_BUSINESS ,

S.NUM_EMPLOY_CAT_NAME ,

S.NUM_EMPLOY_CAT_CODE ,

S.ORG_TERR_NAME ,

S.ORG_FLG ,

S.ORG_PRTNR_FLG ,

S.ORG_PRTNR_TIER_NAME ,

S.ORG_PRTNR_TIER_CODE ,

S.ORG_PRTNR_TYPE_NAME ,

S.ORG_PRTNR_TYPE_CODE ,

S.PAR_DUNS_NUM ,

S.PAR_INTEGRATION_ID ,

S.PAR_ORG_NAME ,

S.PRI_LST_NAME ,

S.PRTNRSHP_START_DT ,

S.PRTNR_FLG ,

S.PRTNR_NAME ,

S.PRTNR_SALES_RANK ,

S.PR_COMPETITOR ,

S.PR_INDUST_NAME ,

S.PR_ORG_TRGT_MKT ,

S.PR_PTSHP_MKTSEG ,

S.PTNTL_SLS_VOL ,

S.PTSHP_END_DT ,

S.PTSHP_FEE_PAID_FLG ,

S.PTSHP_PRTNR_ACCNT ,

S.PTSHP_RENEWAL_DT ,

S.PTSHP_SAT_INDEX ,

S.PTSHP_STAGE_NAME ,

S.PTSHP_STAGE_CODE ,

S.PUBLIC_LISTING_FLG ,

S.REVN_GROWTH_CAT_NAME ,

S.REVN_GROWTH_CAT_CODE ,

S.SALES_EMP_CNT ,

S.SERVICE_EMP_CNT ,

S.ACCNT_AHA_NUM ,

S.ACCNT_HIN_NUM ,

S.CUST_CLASS_NAME ,

S.CUST_CLASS_CODE ,

S.CUST_VALUE_NAME ,

S.CUST_VALUE_CODE ,

S.AGENCY_FLG ,

S.AGNC_CONTRACT_DT ,

S.ANNUAL_REVENUE ,

S.BOOK_VALUE ,

S.BRANCH_FLG ,

S.CALL_FREQUENCY ,

S.CLIENT_FLG ,

S.CREDIT_SCORE ,

S.CRIME_TYPE_NAME ,

S.CRIME_TYPE_CODE ,

S.CURR_ASSET ,

S.CURR_LIAB ,

S.CUST_END_DT ,

S.CUST_SINCE_DT ,

S.DIVIDEND ,

S.EXCHANGE_LOC ,

S.FACILITY_FLG ,

S.FACILITY_TYPE_NAME ,

S.FACILITY_TYPE_CODE ,

S.FIFTYTWO_HIGH ,

S.FIFTYTWO_LOW ,

S.FIN_METHOD_NAME ,

S.FIN_METHOD_CODE ,

S.GROSS_PROFIT ,

S.GROWTH_HORIZ_NAME ,

S.GROWTH_HORIZ_CODE ,

S.GROWTH_OBJ_NAME ,

S.GROWTH_OBJ_CODE ,

S.GROWTH_PERCNTG ,

S.IDENTIFIED_DT ,

S.INVESTOR_FLG ,

S.KEY_COMPETITOR ,

S.LEGAL_FORM_NAME ,

S.LEGAL_FORM_CODE ,

S.LOYAL_SCORE1 ,

S.LOYAL_SCORE2 ,

S.LOYAL_SCORE3 ,

S.LOYAL_SCORE4 ,

S.LOYAL_SCORE5 ,

S.LOYAL_SCORE6 ,

S.LOYAL_SCORE7 ,

S.MARGIN_VS_INDUST_NAME ,

S.MARGIN_VS_INDUST_CODE ,

S.MARKET_CLASS_NAME ,

S.MARKET_CLASS_CODE ,

S.MARKET_TYPE_NAME ,

S.MARKET_TYPE_CODE ,

S.MED_PROC ,

S.MEMBER_NUM ,

S.MKT_POTENTIAL ,

S.MRKT_CAP_PREF_NAME ,

S.MRKT_CAP_PREF_CODE ,

S.NET_INCOME ,

S.NON_CASH_EXP ,

S.NUMB_OF_BEDS ,

S.OBJECTIVE_NAME ,

S.OBJECTIVE_CODE ,

S.OPER_INCOME ,

S.PERSIST_RATIO ,

S.PRIM_MARKET_NAME ,

S.PRIM_MARKET_CODE ,

S.PROJ_EPS ,

S.PR_SPEC_NAME ,

S.PR_SYN_ID ,

S.QUICK_RATIO ,

S.SHARE_OUTST ,

S.SRV_PROVDR_FLG ,

S.STAT_REASON_NAME ,

S.STAT_REASON_CODE ,

S.TICKER ,

S.TOTAL_DEBT ,

S.TOTAL_NET_WORTH ,

S.TOT_ASSET ,

S.TOT_LIABILITY ,

S.TRAIL_EPS ,

S.U_EXCH_DT ,

S.U_LOYAL_SCORE5 ,

S.VOLUME_TR ,

S.SIC_CODE ,

S.SIC_NAME ,

S.GOVT_ID_TYPE ,

S.GOVT_ID_VALUE ,

S.DUNNS_SITE_NAME ,

S.DUNNS_GLOBAL_NAME ,

S.DUNNS_LEGAL_NAME ,

S.CUSTOMER_NUM ,

S.ALT_CUSTOMER_NUM ,

S.ALT_PHONE_NUM ,

S.INTERNET_HOME_PAGE ,

S.LEGAL_STRUCT_NAME ,

S.LEGAL_STRUCT_CODE ,

S.DIRECT_MKTG_FLG ,

S.SOLICITATION_FLG ,

S.VIS_PR_BU_ID ,

S.VIS_PR_POS_ID ,

S.VIS_PR_POSTN_DH_WID ,

S.SETID_CUSTOMER ,

S.SETID_VENDOR ,

S.SUPPLIER_ID ,

S.PARENT_SUPPLIER_ID ,

S.SUPPLIER_NUM ,

S.SUPPLIER_GROUP_NAME ,

S.SUPPLIER_GROUP_CODE ,

S.SUPPLIER_CONTACT_NAME ,

S.SUPPLIER_TYPE_NAME ,

S.SUPPLIER_TYPE_CODE ,

S.MINORITY_GROUP_NAME ,

S.MINORITY_GROUP_CODE ,

S.SUPPLIER_SEARCH_STR ,

S.PREF_ORDER_METHOD ,

S.SUPPLIER_EXT_NETWORK_ID ,

S.SUPPLIER_ACTIVE_FLG ,

S.SUPPLIER_ONE_TIME_FLG ,

S.OOB_IND ,

S.MINORITY_OWNED_IND ,

S.WOMAN_OWNED_IND ,

S.SMALL_BUS_IND ,

S.YR_ESTABLISHED ,

S.DB_RATING ,

S.INTERNAL_FLG ,

S.FLEX_ATTRIB_1_CHAR ,

S.FLEX_ATTRIB_2_CHAR ,

S.FLEX_ATTRIB_3_CHAR ,

S.FLEX_ATTRIB_4_CHAR ,

S.FLEX_ATTRIB_5_CHAR ,

S.FLEX_ATTRIB_6_CHAR ,

S.FLEX_ATTRIB_7_CHAR ,

S.FLEX_ATTRIB_8_CHAR ,

S.FLEX_ATTRIB_9_CHAR ,

S.FLEX_ATTRIB_10_CHAR ,

S.FLEX_ATTRIB_11_CHAR ,

S.FLEX_ATTRIB_12_CHAR ,

S.FLEX_ATTRIB_13_CHAR ,

S.FLEX_ATTRIB_14_CHAR ,

S.FLEX_ATTRIB_15_CHAR ,

S.FLEX_ATTRIB_16_CHAR ,

S.FLEX_ATTRIB_17_CHAR ,

S.FLEX_ATTRIB_18_CHAR ,

S.FLEX_ATTRIB_19_CHAR ,

S.FLEX_ATTRIB_20_CHAR ,

S.CREATED_BY_WID ,

S.CHANGED_BY_WID ,

S.CREATED_ON_DT ,

S.CHANGED_ON_DT ,

S.AUX1_CHANGED_ON_DT ,

S.AUX2_CHANGED_ON_DT ,

S.AUX3_CHANGED_ON_DT ,

S.AUX4_CHANGED_ON_DT ,

S.SRC_EFF_FROM_DT ,

S.SRC_EFF_TO_DT ,

S.EFFECTIVE_FROM_DT ,

S.EFFECTIVE_TO_DT ,

S.DELETE_FLG ,

S.CURRENT_FLG ,

S.W_INSERT_DT ,

S.W_UPDATE_DT ,

S.DATASOURCE_NUM_ID ,

S.ETL_PROC_WID ,

S.INTEGRATION_ID ,

S.TENANT_ID ,

S.X_CUSTOM ,

S.ACCNT_REGION ,

S.X_COMPANY_REG_NUM

);

commit;






4. Once done, execute the entire worksheet by clicking on the RunScript button or F5 key.

5. When all the three queries (Delete, Index creation and Merge) are successfully executed, open DAC and login to the Prod environment.

6. In Execute section, open the current runs tab in the top pane and Tasks in the bottom pane.



7. In the bottom pane, select failed from the dropdown instead of all.





8. When selected, the failed SIL_PartyOrganizationDimension task will be shown. In that, under Task Status click on the text failed. It will open as a drop down, set it to Completed. Then click save button in the bottom pane as shown in the screenshot below.







9. Then if the load is still running, leave it as such as the load will continue. Else if the entire load is failed (ie., in the current runs tab, the load will have the Run Status as Failed), Click on the Restart button.



10. Once clicked, the load will continue from the next task to run.

Note: This procedure applies to any task failure irrespective of the loads except for the steps involving execution of the post SQL in Data Warehouse.

Kashif
mkashu: SIL_PartyOrganizationDimension failure
Review : Kashif | Kashif
Update: October 03, 2017 | Rating: 4.5

Comment for "SIL_PartyOrganizationDimension failure"

0 comments

Post a Comment

Blog Archive

Labels