Retail Merchandising System (MOSC)

MOSC Banner

PLS-00201: identifier 'RMS13.RMSSUB_RECEIVING' must be declared

edited Jan 23, 2014 2:06AM in Retail Merchandising System (MOSC) 3 commentsAnswered ✓
 Hello everyone, 
we have did a cloning of RMS 13.2.4. before cloning RMS schema name was "RMS13" after cloning RMS schema name is RMSCLONE. 

in this clone environment some of the functionality is not working because in some of the tables still it is taking the old schema name "RMS13" . For your reference please check the below error.


javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-06550: line 1, column 10:
PLS-00201: identifier 'RMS13.RMSSUB_RECEIVING' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored returned by program unit L10N_SQL.EXEC_FUNCTION.; nested exception is: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-06550: line 1, column 10:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center