My Oracle Support Banner

Applying Change Package Fails with Error 'Return: 904 - ORA-00904: "SCC_ENT_PT_AUDIT": invalid identifier ' (Doc ID 2706369.1)

Last updated on AUGUST 31, 2020

Applies to:

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

Symptoms

Applying a change package from a Campus Solutions PUM image fails with the message:

Importing SCC_ENTITY_REG

Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 229 Return: 904 - ORA-00904: "SCC_ENT_PT_AUDIT": invalid identifier
Failed SQL stmt: INSERT INTO PS_SCC_ENTITY_REG (SCC_ENTITY_ID, SCC_STATUS, SCC_ENT_LOCK, SCC_ENTITY_NAME, SCC_ENTITY_TYPE_ID, SCC_ENTITY_DESCR, SCC_APPCLASSNAME, SCC_RECNAME, SCC_STG_RECNAME, SCC_ELEMENT_NAME, SCC_APPLY_UPD_RULE, SCC_ENTITY_MSG, SCC_ENT_PT_AUDIT, SCC_ROW_ADD_OPRID, SCC_ROW_ADD_DTTM, SCC_ROW_UPD_OPRID, SCC_ROW_UPD_DTTM) VALUES (:1, :2, :3, :4, :5, :6, :7, (200,0)
SQL Error. Error Position: 229 Return: 904 - ORA-00904: "SCC_ENT_PT_AUDIT": invalid identifier

INSERT INTO PS_SCC_ENTITY_REG (SCC_ENTITY_ID, SCC_STATUS, SCC_ENT_LOCK, SCC_ENTITY_NAME, SCC_ENTITY_TYPE_ID, SCC_ENTITY_DESCR, SCC_APPCLASSNAME, SCC_RECNAME, SCC_STG_RECNAME, SCC_ELEMENT_NAME, SCC_APPLY_UPD_RULE, SCC_ENTITY_MSG, SCC_ENT_PT_AUDIT, SCC_ROW_ADD_OPRID, SCC_ROW_ADD_DTTM, SCC_ROW_UPD_OPRID, SCC_ROW_UPD_DTTM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, TO_TIMESTAMP(:15,'YYYY-MM-DD-HH24.MI.SS.FF'), :16, TO_TIMESTAMP(:17,'YYYY-MM-DD-HH24.MI.SS.FF'))

Error: Unable to insert row 1

Error: SQL execute error for SCC_ENTITY_REG




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.