Hi,
I am using a lookup transformation with the following SQL Override:
SELECT MCIX.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID, MCIX.ATTRIBUTE1 AS ATTRIBUTE1, MCIX.ATTRIBUTE2 AS ATTRIBUTE2, MCI.CUSTOMER_ID AS CUSTOMER_ID, MCI.CUSTOMER_ITEM_NUMBER AS CUSTOMER_ITEM_NUMBER
FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, MTL_SYSTEM_ITEMS_B MSI
WHERE MCI.CUSTOMER_ITEM_ID = MCIX.CUSTOMER_ITEM_ID AND MCIX.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = 81 AND MCIX.INACTIVE_FLAG = 'N'
--
I am using the first selected field as an output and the remaining 4 in my conditions. My ports have 5 lookup ports (first one also being output), and 4 input port to be used within the condition. My lookup ports have the same name as the selected fields and they are in the same order in the conditions as they are in the select (except the first selected field is not included in the select, cus I want to return it). The datatypes also match with the datatypes of the selected field within the Oracle server.
I am still getting this error:
TRANSF_1_2_1> DBG_21079 Creating Lookup Cache : (Wed Oct 04 14:10:23 2006)
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1022 Database driver error...
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1057 Error in fetching lookup data from database
TRANSF_1_2_1> DBG_21641 lkp_ORA_WARR_ID: Index cache size = [1000000], Data cache size = [2000000]
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1062 Error creating lookup cache.
TRANSF_1_2_1> DBG_21524 Transform : lkp_ORA_WARR_ID
It seems it can't fetch the data. So I guess there is still something wrong with my sql. Any help is greatly appreciated. Thanks a lot...
-Mustafa
I am using a lookup transformation with the following SQL Override:
SELECT MCIX.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID, MCIX.ATTRIBUTE1 AS ATTRIBUTE1, MCIX.ATTRIBUTE2 AS ATTRIBUTE2, MCI.CUSTOMER_ID AS CUSTOMER_ID, MCI.CUSTOMER_ITEM_NUMBER AS CUSTOMER_ITEM_NUMBER
FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, MTL_SYSTEM_ITEMS_B MSI
WHERE MCI.CUSTOMER_ITEM_ID = MCIX.CUSTOMER_ITEM_ID AND MCIX.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = 81 AND MCIX.INACTIVE_FLAG = 'N'
--
I am using the first selected field as an output and the remaining 4 in my conditions. My ports have 5 lookup ports (first one also being output), and 4 input port to be used within the condition. My lookup ports have the same name as the selected fields and they are in the same order in the conditions as they are in the select (except the first selected field is not included in the select, cus I want to return it). The datatypes also match with the datatypes of the selected field within the Oracle server.
I am still getting this error:
TRANSF_1_2_1> DBG_21079 Creating Lookup Cache : (Wed Oct 04 14:10:23 2006)
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1022 Database driver error...
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1057 Error in fetching lookup data from database
TRANSF_1_2_1> DBG_21641 lkp_ORA_WARR_ID: Index cache size = [1000000], Data cache size = [2000000]
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1062 Error creating lookup cache.
TRANSF_1_2_1> DBG_21524 Transform : lkp_ORA_WARR_ID
It seems it can't fetch the data. So I guess there is still something wrong with my sql. Any help is greatly appreciated. Thanks a lot...
-Mustafa