Hi,
My issue is similar to the one raised by Ashwin. View log files in EBS displayed below
Entering SyncRefDataToOtm.runProgram
Entering SyncRefDataToOtm.initVariables
paramName is CARRIER_NAME_LOW
paramValue is ADL Trucking
paramName is CARRIER_NAME_HIGH
paramValue is ADL Trucking
paramName is LAST_UPDATE_DATE_LOW
paramValue is
paramName is LAST_UPDATE_DATE_HIGH
paramValue is
Exiting SyncRefDataToOtm.initVariables
Entering SyncRefDataToOtm.initSecurityInfo
Connection object oracle.jdbc.driver.T4CConnection@17e121c
Exiting SyncRefDataToOtm.initSecurityInfo
Entering SyncRefDataToOtm.validateProfiles
Entering SyncRefDataToOtm.isOtmInstalled
Connection object oracle.jdbc.driver.T4CConnection@17e121c
Exiting SyncRefDataToOtm.isOtmInstalled
domain Name is GUEST
country code is USA
Exiting SyncRefDataToOtm.validateProfiles
Entering SyncRefDataToOtm.queryAndSendEntities
entity Type is CARRIER
carrierNameLow ADL Trucking
carrierNameHigh ADL Trucking
lastUpdateDateLow
lastUpdateDateHigh null
BPEL Domain is default
query String is SELECT HPS.PARTY_SITE_ID, HPS.PARTY_ID, HPS.LOCATION_ID FROM WSH_CARRIERS_V WC, HZ_PARTY_SITES HPS WHERE HPS.PARTY_ID = WC.CARRIER_ID AND WC.ACTIVE = 'A' AND WC.CARRIER_NAME BETWEEN :1 AND :2 AND ( ( (:3 is null or WC.LAST_UPDATE_DATE >= to_date(:4,'YYYY/MM/DD HH24:MI:SS')) AND (:5 is null or WC.LAST_UPDATE_DATE <= to_date(:6,'YYYY/MM/DD HH24:MI:SS') )) OR ( (:7 is null or HPS.LAST_UPDATE_DATE >= to_date(:8,'YYYY/MM/DD HH24:MI:SS')) AND (:9 is null or HPS.LAST_UPDATE_DATE <= to_date(:10,'YYYY/MM/DD HH24:MI:SS')))) ORDER BY WC.CARRIER_ID
l_dateLow is null
l_dateHigh is null
endPoint is
http://rstn-lin15.us.oracle.com:7777...efDataStlToOtm
curCarrSiteId is 6718
curCarrierId is 12516
curLocationId is 10896
prevCarrierId is 0
elementsCount is 0
totCarrCount is 0
totCarrSiteCount is 0
Calling SendDocument outside the loop
Entering SyncRefDataToOtm.sendDocument
xml is <input xmlns="http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendRefDataStlToOtm"><entityType xmlns="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound">CARRIER</entityType><entityIdList xmlns="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><entityId>6718</entityId></entityIdList><parentIdList xmlns="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><entityId>12516</entityId></parentIdList><securityContext xmlns="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><ticket>EE096E68BF8C91AAD590 99E10F7DDE53</ticket><proxyServer /><proxyPort /><dbConn /><opCode>refOpCode</opCode><argKey>refArgKey</argKey></securityContext><appsContext xmlns="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><userId /><respId /><respAppId /></appsContext></input>
endPoint is
http://rstn-lin15.us.oracle.com:7777...efDataStlToOtm
Unexpected Error Occured
Exiting SyncRefDataToOtm.sendDocument
Total number of loops = 1
Total number of Warnings = 1
Exiting SyncRefDataToOtm.queryAndSendEntities
Completion Status false
Exiting SyncRefDataToOtm.runProgram