Supplier With More Than One Address With Same Address Type Has Invalid Value In SEQ_NO
(Doc ID 2023063.1)
Last updated on NOVEMBER 14, 2016
Applies to:Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.
Retail Merchandising System (RMS) v14.0.2
When creating Suppliers from (E-Business Suite) EBS having multiple contact data, this is added to ADDR table in RMS, but all duplicate address types (addr_type) for example 04, has the same value for SEQ_NO as value of 1. Where this should be incremented for each, resulting so that the additional entry of same address type will have an incremented value for SEQ_NO.
Steps to Reproduce:
1 - Run standard Supplier conversion of (Retail Financial Integration) RFI and populate RFI staging tables;
2 - Turn on the supplier Publisher in RFI Console Admin
3 - Check invalid records in ADDR table
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