E1: 76B: P76B805 - Returns With Duplicate Key While Creating The Sales Order Return (Doc ID 2172856.1)

Last updated on AUGUST 16, 2016

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When user tries to create a Credit Memo Sales Order Return for more than one nota fiscal / original sales order, P76B805 displays error indicating duplicate key.

ERROR
-----------------------
Error ID 317

JAS MSG317: Duplicate key not allowed. Please correct the duplicate key field

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter 2 Sales orders for the same customer, both with 1 single line 1.000 (LNID = 1), generate Nota Fiscal, Add Tax Lines and Run Sales Update
2. Create a Sales Return process and try to select both Nota Fiscais for the same VL order, in credit memo functionality.
3. Note that the second line, as it has the same Related Order Line number as 1.000, you won't be able to save the VL. Duplicate Key error will display

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