When Adding The Same Item Twice In A Purchase Order Get ORA-00001 Error (Doc ID 2226008.1)

Last updated on JANUARY 26, 2017

Applies to:

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

Symptoms

When creating a Purchase Order without a Location defined at Header Level, and entering the same Item twice to the Purchase Order, instead of returning the message saying that the Item already exists, there is the error message:


Steps to Reproduce:
1. Create a manual PO without entering the Location at header level, by entering Supplier and Department (system options mandatory; DEPT_LEVEL_ORDERS='Y').
2. Press button Items (Articulos).
3. Open the screen "Order Distribution Worksheet" (Hoja de Trabajo distribución orden).
4. Enter Item a first time and related quantity, and then press button "Apply Item" (Aplicar artículo).
5. Enter same Item a second time and related quantity (no error message up to this point).
6. Press button "Apply Item" (Aplicar artículo) and the error ORA-00001 is raised.

Changes

 

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