My Oracle Support Banner

PRC:POZ:Getting An Issue While Creating The Supplier Sites (Doc ID 2769867.1)

Last updated on APRIL 30, 2021

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.13.21.01.0 and later
Oracle Fusion Purchasing - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a supplier site with REST API, the following error occurs.

ERROR
-----------------------
Applying List binding LOV_ABCSupplierSiteSubType with given set of values leads to multiple matching rows for a row of type:SupplierSiteVO_DFF_SupplierSiteVOToPozSupplierSiteDFFVO_PozSupplierSitesDFFVO, key oracle.jbo.Key[


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a supplier and supplier address
2. Using REST API /fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites try to create a supplier site
3. In the payload for supplier site creation observe independent and dependent segments, dependent segment is null value

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create in bulk supplier sites

Changes

 NA

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!


In this Document
Symptoms
Changes
Cause
Solution


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