My Oracle Support Banner

19c database upgrade failed with error that wf_wl_config_types does not exist (Doc ID 2771461.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After 19c database upgrade,  the following warning and error is encountered.


DOAPROD(3):WARNING: too many parse errors, count=18357 SQL hash=0xbcee36c4
DOAPROD(3):PARSE ERROR: ospid=25630, error=942 for statement:
2021-03-26T16:30:55.350339-04:00
DOAPROD(3):select count(1) from wf_wl_config_types where item_type = :i1 and message_name = :i2
DOAPROD(3):Additional information: hd=0x1cfb39750 phd=0x1cfb3ab78 flg=0x101476 cisid=103 sid=103 ciuid=103 uid=103 sqlid=08a0qyuyfwdq4
DOAPROD(3):...Current username=APPS
DOAPROD(3):...Application: e:ICX:bes:oracle.apps.wf.notification.send Action: ICX/RI_075_SSPO_REQ
2021-03-26T16:30:55.356908-04:00

wf_wl_config_types should exist.

 

Changes

 Database upgrade to 19c. Before 19c, parsing errors were not reported in database alert.log

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


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