My Oracle Support Banner

APPT_DETAIL_TO_UPLOAD Table has Duplicate Records For Same Item For C Type ASN (Doc ID 2552739.1)

Last updated on SEPTEMBER 27, 2019

Applies to:

Oracle Retail Warehouse Management System - Version 16.0.1 to 16.0.2 [Release 16.0]
Information in this document applies to any platform.

Symptoms

When Advance Shipment Notic(ASN) has both store cartons and warehouse cartons, appointment message which is getting created for that ASN is failing in Retail Merchandising System (RMS) with unique constraint error due to duplicate records in APPT_DETAIL_TO_UPLOAD table. Appointment detail message has one record with actual distro number and another record with distro number as 'NONE'.

Steps To Recreate:

1. Create C type ASN.
2. Include Store Cartons as well as Warehouse Cartons for the same item in the ASN.
3. Create appointment for the same.
4. Schedule the appointment.
5. Check APPT_DETAIL_TO_UPLOAD table populated with duplicate values


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!


In this Document
Symptoms
Changes
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.