My Oracle Support Banner

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

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
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.