My Oracle Support Banner

R11: PA: Invalid error on PA_COST_EXCEPTIONS_DET_V (Doc ID 2440723.1)

Last updated on SEPTEMBER 11, 2018

Applies to:

Oracle Project Foundation - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

After fresh installation of 11.5.10.2,
According to the execution result of PatchWizard, when applying the Recommend patch by merge patch
INVALID object occurred in PA.

SQL> select object_type,object_name from user_objects
  2 where status= 'INVALID';

OBJECT_TYPE OBJECT_NAME
------------------- ------------------------------
PACKAGE BODY ARP_STAX_MINUS99
VIEW PA_COST_EXCEPTIONS_DET_V

SQL> alter view PA_COST_EXCEPTIONS_DET_V compile;

Warning: View altered with compilation errors.

SQL> select text from user_errors
  2 where name = 'PA_COST_EXCEPTIONS_DET_V';

TEXT
--------------------------------------------------------------------------------
ORA-00904: "SMRY"."UNIT_OF_MEASURE": invalid identifier
 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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