My Oracle Support Banner

Using ADM to Export Updated LOVs (Doc ID 509839.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel System Software - Version 7.8.2 [19213] and later
Information in this document applies to any platform.
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213]

***Checked for relevance on 18-Nov-2013***


While using ADM to export Child LOV Types that are associated to a Parent Vanilla LOV Type, the LOVs are not being displayed when validating the filter.

We determined that our best filtering is based on Updated > 01/01/1980 and Language code being ENU.  Yet, we are not seeing the results that we expect.

Given the following filter:

[Updated] > '01/01/1980'
[List Of Values Child (UDA).Updated] => '01/01/1980'

The filter does not output vanilla LOVs that have been modified. Only new parent and child LOVs that were added are retrieved by the filters.

Why do these filters NOT display the updated vanilla child LOVs?

We then created another filter to capture our modified vanilla parents and child LOVs.

Note the following filter:

([Value] = 'MR_MS'  OR  [Value] = 'OFFER_MEDIA'  OR [Value] = 'REVENUE_TYPE' OR  
 [Value] = 'TODO_TYPE')
 AND ([List Of Values Child (UDA).Language] = 'ENU')

However, the Integration Object is not able to filter on the language field for these LOVs: this filter retrieves the child LOVs for all languages.

Why are these filters are not working?  What can be done to make them behave as we expect?




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

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