R12 Projects Endeca - The View PA_BCC_ENDECA_DRAFT_INVOICE_V is Failing With Error RA-04063 (Doc ID 2188024.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Project Planning and Control - Version 12.1.3.3 and later
Information in this document applies to any platform.

Symptoms

After the Patch 23129143:R12.PA.B was applied the view PA_BCC_ENDECA_DRAFT_INVOICE_V does not compile

ERROR
---------
select COUNT(*)  from APPS.PA_BCC_ENDECA_DRAFT_INVOICE_V;
RA-04063: view "APPS.PA_BCC_ENDECA_DRAFT_INVOICE_V" has errors
04063. 00000 -  "%s has errors"
*Cause:    Attempt to execute a stored procedure or use a view that has
          errors.  For stored procedures, the problem could be syntax errors
          or references to other, non-existent procedures.  For views,
          the problem could be a reference in the view's defining query to
          a non-existent table.
          Can also be a table which has references to non-existent or
          inaccessible types.
*Action:   Fix the errors and/or create referenced objects as necessary.
Error at Line: 13 Column: 28


STEPS
---------
The issue can be reproduced at will with the following steps:

1. Apply the Patch 23129143:R12.PA.B
2. The view PA_BCC_ENDECA_DRAFT_INVOICE_V is not compiled

Changes

 

Cause

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 hundreds of Community platforms