W1-ASSET Validation Program W1ASTOOR Returns ORA Error: ORA-00942: table or view does not exist (Doc ID 2790208.1)

Last updated on JANUARY 24, 2023

Applies to:

Goal

When ran W1AST00R as part of conversion FK - Resolve XML for W1_ASSET

ERROR (com.splwg.base.support.sql.PreparedStatementImpl) Error executing iterate for rawSQL:
  select ASSET_ID from W1_ASSET t where 'Y' = ? and ASSET_ID between ? and ? and not exists ( select 'x' from WR_ASSET x where x.ASSET_ID = t.ASSET_ID ) order by ASSET_ID /* Prepare SQL for W1AST00R */
 with 'string' parameter named 'f1_lowId' to : '000000000000' to indices: 2
 with 'string' parameter named 'isEligible' to : 'Y' to indices: 1
 with 'string' parameter named 'f1_highId' to : '999999999999' to indices: 3

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not existconversion validation for FK via Resolve XML for W1_ASSET, program crashes ORA-00942: table or view does not exist
 

Solution

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