E1: 43E: P40243 UNSPSC to Account Relationship Does Not Allow an Account to Relate to Multiple UNSPSC Codes

(Doc ID 2366595.1)

Last updated on FEBRUARY 27, 2018

Applies to:

JD Edwards EnterpriseOne Requisition Self Service - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

UNSPSC to Account Relationship (P40243) application and Commodity Relationship (F40243) table.

Only one UNSPSC can be associated with an Object Account without receiving a "Commodity Relationship Record Exists" error in the application. The primary key for F40243 is MCU, OBJ, SUB. Due to the table key, multiple UNSPSC codes cannot point to the same object account.

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