Reim Posting Aborting While Fetching Vendor Site Id
(Doc ID 2593027.1)
Last updated on OCTOBER 01, 2019
Applies to:Oracle Retail Invoice Matching - Version 15.0.1 and later
Information in this document applies to any platform.
After deploying the Cumulative <Patch 29326707>: REIM_15.0.1_CUMULATIVE_HF_FEB_2019_1 reimposting process sometimes aborts with the following message:
oracle.retail.apps.reim.data.DataAccessException: error occurred while fetching vendor site id
This query was introduced in the solution provided in REIM_WRAPPER_SQL.GET_ORACLE_VENDOR_SITE_ID function:
--Query to handle the supplier site off scenario
SELECT /*+ INDEX(ad ADDR_I4) */
FROM ADDR ad
WHERE ad.addr_type = REIM_WRAPPER_SQL.ADDR_TYPE_6
AND ad.module = REIM_WRAPPER_SQL.MODULE_SUPP
AND ad.KEY_VALUE_1 = TO_NUMBER(I_vendor_id)
the problem is that ADDR.key_value_1 column also has values that are not numeric and sometimes the function terminates with the following error:
ORA-01722: invalid number from REIM_WRAPPER_SQL.GET_ORACLE_VENDOR_SITE_ID.
To reproduce the problem:
1-Add record to addr with key_value_1 with a non numeric value (partners addresses for example)
2-Create any non merchandise invoice without an order number associated with it
3-Run Reim Posting
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document