My Oracle Support Banner

Cannot Validate W1_VENDOR_LOG Index Using All Batch Procedure (Doc ID 2743064.1)

Last updated on JANUARY 11, 2021

Applies to:

Oracle Utilities Work and Asset Cloud Service - Version 20C and later
Information in this document applies to any platform.


Cannot Validate W1_VENDOR_LOG index using all batch procedure

During conversion testing we are truncating and loading the production and staging schemas multiple times per day. The W1_VENDOR_LOG indexes will not go valid using the "ALL" procedures.

Steps to reproduce:
1. Switch schema to staging.
2. Run K1-RIUSS
3. Run K1-SCLTB
4. Validate all indexes are valid:
select * from all_indexes
where status != 'VALID'
and owner = 'STGADM'


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.