Package CORESVC_ITEM Fails to Compile with ORA-00600 Error During Upgrade

(Doc ID 2305323.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 to 14.1.3 [Release 14.1]
Information in this document applies to any platform.


Trying to upgrade RMS DB from version 14.1.0 to 14.1.3 but it fails as mention below.

Excerpt from ORPatch log:
"Creating synonyms in SCH_RMS13 pointing to RMS_ASYNC_USER ...
File CREATE_SYNONYMS_ONE_USER.SQL successfully executed
Invalid Compilation attempt 1
Compiling 1 invalid objects...
 1 invalid objects remain:
 See logs in DETAIL_LOGS/DBSQL_RMS/invalids for USER_ERRORS information
 1 invalid objects
 Failed to complete Post-action for action: DBSQL_RMS
 ORPatch session completed with errors"

"PL/SQL: ORA-00600: internal error code"

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Upgrade RMS DB from 14.1.0 from 14.1.3




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