Additional Query on Calling "ISS Promotion Management Service" BS "LoadExternalPromAsset" Method.

Hi All,

The Vanilla WF  "ISS Promotion WS-Upgrade Promotion-Order" has a step "Load Promotion Asset". In this step "LoadExternalPromAsset" method of ISS Promotion Management Service Business Service is getting called. on checking the log we see that there is an extra query with Sort Spec as Asset_NUM is getting called and for large account this step is taking long time. PFB the Query

SELECT /*+ ALL_ROWS */ T11.CONFLICT_ID, T11.LAST_UPD, T11.CREATED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODIFICATION_NUM, T11.ROW_ID, T11.ASSET_VAL_CURCY_CD, T11.DESC_TEXT, T11.ASSET_NUM, T11.ASSET_VAL_EXCH_DT, T7.NAME, T11.BILL_ACCNT_ID, T1.ONL_PAGESET_ID, T11.CFG_STATE_CD, T11.CFG_TYPE_CD, T6.CMPND_PROD_NUM, T11.COST_LST_ID, T11.EXTD_QTY, T11.INTEGRATION_ID, T11.ASSET_MEM_INTEG_ID, T11.PR_ACCNT_ID, T11.OWNER_ACCNT_ID, T11.OWNER_CON_ID, T11.OWNERSHIP_TYPE_CD, T11.PAR_ASSET_ID, T11.PR_CON_ID, T11.PR_EMP_ID, T11.BU_ID, T11.PR_POSTN_ID, T11.PORT_VALID_PROD_ID, T11.PROM_INTEG_ID, T1.PROD_TYPE_CD, T1.DESC_TEXT, T11.PROD_ID, T1.NAME, T11.ASSEMBLY_PORT_ID, T5.NAME, T1.PR_PROD_LN_ID, T1.SERIALIZED_FLG, T1.PROD_CD, T11.XA_CLASS_ID, T11.PROM_GROUP_ID, T11.PROM_GROUP_ITEM_ID, T1.PROMO_TYPE_CD, T11.QTY, T11.REGISTERED_DT, T11.ROOT_ASSET_ID, T9.CFG_TYPE_CD, T9.INTEGRATION_ID, T2.PROD_TYPE_CD, T9.PROD_ID, T11.SERIAL_NUM, T3.NAME, T11.SERV_ACCT_ID, T11.SP_NUM, T11.STATUS_CD, T11.VERSION, T8.PAR_BU_ID, T6.ROW_ID, T6.PAR_ROW_ID, T6.MODIFICATION_NUM, T6.CREATED_BY, T6.LAST_UPD_BY, T6.CREATED, T6.LAST_UPD, T6.CONFLICT_ID, T6.PAR_ROW_ID, T4.ROW_ID, T10.ROW_ID