ORA-01403 Error when Creating a PO Specific Deal

(Doc ID 2414428.1)

Last updated on JUNE 29, 2018

Applies to:

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


When trying to create a PO specific Deal and when we enter the buy get component the below error is thrown.

ORA-01403: no data found returned by program unit DEAL_ORD_LIB_SQL.GET_TOTAL_QTY

Steps to reproduce :
1. Create Purchase Order for an Item A and Item B
2. In the PO Specific Deal create off Invoice Deal (as this example)

3. Try Approving the Deal




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