When attempting to run Order Import and passing Install Base details,
some time we will get error message "Cannot get valid ID for - ib_current_location".
Solution:-
Send IB_CURRENT_LOCATION as the value returned from below query:
SELECT MEANING
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'ITEM_CURRENT_LOCATION'
AND LOOKUP_CODE = 'END_CUSTOMER'
Here based on the requirement pass the LOOKUP_CODE as 'END_CUSTOMER' , 'DELIVER_TO', 'BILL_TO', 'SHIP_TO' or 'SOLD_TO'.
Solution:-
Send IB_CURRENT_LOCATION as the value returned from below query:
SELECT MEANING
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'ITEM_CURRENT_LOCATION'
AND LOOKUP_CODE = 'END_CUSTOMER'
Here based on the requirement pass the LOOKUP_CODE as 'END_CUSTOMER' , 'DELIVER_TO', 'BILL_TO', 'SHIP_TO' or 'SOLD_TO'.
No comments:
Post a Comment