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