AUC_* Views Delivered in Image 15 Fail to Build (Doc ID 2107731.1)

Last updated on JULY 11, 2016

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to build new views delivered in Image #15, a number of them failed to build.

Record Name
---------------
AUC_AWARD_DT_VW
AUC_AWD_BI_VW
AUC_AWD_P1_VW
AUC_AWD_P2_VW
AUC_BID_PART_VW
AUC_BID_RE_P_VW
AUC_BI_PART_VW
AUC_FL_BASE_VW
AUC_IN_BI_VW
AUC_PAR_BI_VW
AUC_PAR_P1_VW
AUC_RESP_BID_VW
AUC_SWL_INV_VW
AUC_UNSO_BID_VW

The errors varied from view to view... some failed because the previous view did not build, but of the views with actual errors, they were mostly related to the inappropriate use of SYSDATE or GROUP functionality


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