My Oracle Support Banner

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.

Symptoms

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) */
COUNT(*) cnt
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


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.