My Oracle Support Banner

RMSSUB_SUPPLIER.VALIDATE_ADDRESS_RECORD Not Validating if Country-State Relation Is Invalid (Doc ID 2196346.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.


The RMSSUB_SUPPLIER.VALIDATE_ADDRESS_RECORD procedure is not validating if country-state relation is invalid.

Steps to Recreate: 

  1. Inject a vendorcre message containing an invalid country_id-state relation (country-state association not in STATE table) in EtExtVendor topic.
  2. Verify that the data gets incorrectly integrated in RMS.

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.