PO 12.2 Application Snapshots Failing on DEFINE SURVEY ORA-00942
(Doc ID 2109027.1)
Last updated on OCTOBER 10, 2023
Applies to:
Oracle Configuration Controls Governor - Version 5.5.1 and laterInformation in this document applies to any platform.
Symptoms
On : 5.5.1 version, Integra Apps
When attempting to run snapshot for PO 12.2 Object Define Survey
the following error occurs.
ERROR
-----------------------
CREATE TABLE snapshot_temp_data_13696_1
( pks_string_value, col_string_value1 )
AS SELECT /*+ CHOOSE */ COL_PKS,
COL1
FROM PO.POA_CM_DISTRIBUTIONS# A0
Error: Snapshot Get Target Data routine failed. ORA-00942: table or view does not exist
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. submit snapshot for PO Object Define Survey
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 |
Cause |
Solution |
References |