R12 Projects Endeca - The View PA_BCC_ENDECA_DRAFT_INVOICE_V is Failing With Error RA-04063
Last updated on OCTOBER 11, 2016
Applies to:Oracle Project Planning and Control - Version 126.96.36.199 and later
Information in this document applies to any platform.
After the Patch 23129143:R12.PA.B was applied the view PA_BCC_ENDECA_DRAFT_INVOICE_V does not compile
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
*Action: Fix the errors and/or create referenced objects as necessary.
Error at Line: 13 Column: 28
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
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