My Oracle Support Banner

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.

Symptoms

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

Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.