My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2018

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

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.