Malformed XML from ORPOS Extract (after Installing Bundled Patch) (Doc ID 2198456.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Retail Price Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Oracle Retail Price Management (RPM) 14.1

Finding malformed XML from ORPOS extract (after installing bundled <patch 24438494>).
Getting malformed ORPOS XML due to duplicates in payload when changing end date of an active multibuy promotion and it will not load.


Instructions to Re-create:
1. Login to RPM.
2. Navigate to Promotions -> Maintain Promotion.
3. Select a multibuy active promotion having huge data. Ex: merch hierarchy/zone level promotion.
4. Change the end date of the promotion. The approval process should go through chunking process.

Note the duplicates in rpm_promo_item_payload, rpm_promo_disc_ldr_payload and rpm_promo_dtl_list_payload tables.
And note that PricingExtract.xml has incorrect xml formatting....

 

Changes

 Previously, applied <Patch 24438494> - RPM 14.1.0 BUNDLE HOT FIX RELEASE, 53 bug fixes

Cause

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