My Oracle Support Banner

Transformation Install In Production Life Cycle Ends With Warning (Doc ID 2936116.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.1.1.2 and later
Information in this document applies to any platform.

Symptoms

A Transformation install in production life cycle ends in warning status. In the logs the following error is seen:

Checking for invalid source codes,synonyms in PG_<program object ID>_PRG Program
Source code is invalid.Hence Recompiling the objects to resolve any compilation errors.
Program has valid Package Body
Program's Package Body is in invalid state.
Package Body has following errors at:
Line 5 with PL/SQL: SQL Statement ignored
Line 210 with PL/SQL: ORA-00942: table or view does not exist
Line 215 with PL/SQL: SQL Statement ignored
Line 420 with PL/SQL: ORA-00942: table or view does not exist

The same transformation installs in the Dev and QC life cycles were successful.

Changes

 

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!

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