E1: 76B: IPI Legal Framing Code (P7613B) Returns Error "JAS-MSG317: Duplicate key not allowed" (Doc ID 2753197.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Symptoms

If a user attempts to add a record in the IPI Legal Framing Code (P7613B) program where the Transaction Nature, Transaction Nature Suffix, and IPI Tax Situation are the same as another record and the IPI Legal Framing Code is the only thing different the following error will be returned:

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

In the Work With IPI Legal Framing Code (P7613B) enter “55” in the IPI Tax Situation field (B76TSIPI) and click Find. Only one row appears as follows:
-    Transaction Nature = “611”
-    Transaction Nature Suffix = “00”
-    IPI Tax Situation = “55”
-    IPI Legal Framing Code “108”.

Attempt to add a new record as follows:
-    Transaction Nature = “611”
-    Transaction Nature Suffix = “00”
-    IPI Tax Situation = “55”
-    IPI Legal Framing Code “117”.
-    Click the green checkmark to add the record.

The following error is displayed:

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

Changes

Cause

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