Receiving Error Message ORA-00904: "FILL"."SCC_ZERO_NUMBER": Invalid Identifier After Applying Campus Solutions(CS) Bundle #38 (Doc ID 2043123.1)

Last updated on OCTOBER 27, 2015

Applies to:

PeopleSoft Enterprise CS Student Administration - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

On Campus Solutions 9, after applying Bundle #38 when attempting to run the app engine SCC_ESYNCALL the following error occurs.

ERROR
-----------------------
Message Set Number: 200
Message Number: 0
Message Reason: File: E:\\peopletools\src\pspcm\pcmosql.cppSQL error. Stmt #: 760 Error Position: 587 Return: 904 - ORA-00904: "FILL"."SCC_ZERO_NUMBER": invalid identifier
Failed SQL stmt: SELECT FILL.SCC_ENT_VIEW_ID,FILL.SCC_ENTITY_ID,FILL.SCC_PROP_NAME,FILL.SCC_PROP_TYPE,FILL.SCC_ENT_LOCK,FILL.SCC_ORDER_NBR,FILL.FIELDNAME,FILL.SCC_SHOW_TO_XML,FILL.SCC_PARSE_FROM_XML,FILL.SCC_SHOW_LOV_DESCR,FILL.SCC_PROP_XML_TAG,FILL.SCC_IN_PROD,FILL.SCC_IN_STAGE,FILL.SCC_PROP_REQUIRED,FILL.SCC_PROP_LABEL,FI (200,0)
SQL error. Function: Rowset.Fill
 Error Position: 587
 Return: 904 - ORA-00904: "FILL"."SCC_ZERO_NUMBER": invalid identifier
 Statement: select fill.scc_ent_view_id,fill.scc_entity_id,fill.scc_prop_name,fill.scc_prop_type,fill.scc_ent_lock,fill.scc_order_nbr,fill.fieldname,fill.scc_show_to_xml,fill.scc_parse_from_xml,fill.scc_show_lov_descr,fill.scc_prop_xml_tag,fill.scc_in_prod,fill.scc_in_stage,fill.scc_prop_required,fill.scc_prop_label,fill.scc_prop_descr,fill.scc_ep_def


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set Up SACR System Administration Entity Entity Property Sync
  scroll down to click "sync all entity properties"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with installing CS bundle 38.

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