My Oracle Support Banner

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 OCTOBER 08, 2021

Applies to:

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


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.




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

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