After Full Migration LOV Data Is Missing Rows
(Doc ID 2658447.1)
Last updated on MARCH 14, 2024
Applies to:
Siebel eMedia - Version 19.7 and laterInformation in this document applies to any platform.
Symptoms
Spite of full migration from Development to SIT environment there are missing parent LICs leading to only two India provinces in a picklist while the expected number is 37.
By reviewing the application log file while navigating to Administration - Data > List of values, and searching for the respective LOV_TYPE, the following query reproduced the small number of rows, i.e. 2 rows:
Select * from S_LST_OF_VAL_TARGET WHERE TYPE='PROVINCE_ABBREV' and PAR_ROW_ID in (select WS_SRC_ID from S_LST_OF_VAL_TARGET WHERE TYPE='COUNTRY' and VAL='India')
and (WS_MAX_VER=10000 AND WS_MIN_VER=0);
and (WS_MAX_VER=10000 AND WS_MIN_VER=0);
On the other hand, the following query returned the missing 35 rows:
Select * from S_LST_OF_VAL_TARGET WHERE TYPE='PROVINCE_ABBREV' and PAR_ROW_ID in (select WS_SRC_ID from S_LST_OF_VAL_TARGET WHERE TYPE='COUNTRY' and VAL='India')
and (WS_MIN_VER <=0 AND WS_MAX_VER >0);
and (WS_MIN_VER <=0 AND WS_MAX_VER >0);
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |