Supplier With More Than One Address With Same Address Type Has Invalid Value In SEQ_NO
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
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