My Oracle Support Banner

Address Type 04 Creates Mandatory Supplier Addresses with the Wrong Seq Number (Doc ID 2610886.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

For suppliers created with multiple addresses where the same address type is in multiple records, the seq_no for records having only a record for another address_type is not 1.


##STEPS TO REPRODUCE##
1. Create a supplier  using VendorPublishingService XML. The supplier must have at least 2 records for a certain addr_type and no record for the mandatory addresses.
2. Import the supplier through SOAPUI/REST using VendorPublishingService Create.
3. Check the database:

4. Notice that the SEQ_NO for the ADDR_TYPE which is mandatory in the system that has the last number found in the addr_type specified at step 1 instead of  seq_no = 1.

Changes

 

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.