RMSSUB_ASNOUT.CONSUME Fails With ORA-06503 Error (Doc ID 2303275.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

ASNOUT (shipment) message fails with below error when RMSSUB_ASNOUT.CONSUME  message subscribed in RMS :

 Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-06503: PL/SQL: Function returned without value returned by program unit UPDATE_SNAPSHOT_SQL.UPDATE_TSFO.; nested exception is: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-06503: PL/SQL: Function returned without value returned by program unit UPDATE_SNAPSHOT_SQL.UPDATE_TSFO. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-06503: PL/SQL: Function returned without value returned by program unit UPDATE_SNAPSHOT_SQL.UPDATE_TSFO.

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