RPMtoORPOSPublishBatch Creating Wrong XML Tags For Clearance DEL Messages (Doc ID 1969892.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

RPMtoORPOSPublishBatch and RPMtoORPOSPublishExport batches are creating incorrect XML messages in case of clearance un-approval.

After the clearance status is changed from Approved to Worksheet and the batches are run, XML files are generated with duplicate incorrect ITEM tags for DEL (delete) messages
The incorrect tags and message formation have been observed for clearance DEL and not for clearance ADD.

The issue can be reproduced at will with the following steps:
1. Create a clearance and approve for future date, CRE (Create) records are inserted in RPM_PRICE_EVENT_PAYLOAD and RPM_CLEARANCE_PAYLOAD tables.
2. Select the clearance and change the status from approved to worksheet. The clearance state changes to worksheet and DEL records are inserted in RPM_PRICE_EVENT_PAYLOAD and RPM_CLEARANCE_PAYLOAD tables.
3. Run the RPMtoORPOSPublishBatch.sh, entries are created in RPM_ORPOS_PRICE_CHANGE_PUBLISH table for the clearance.
4. Run the RPMtoORPOSPublishExport.sh, XML Files are generated with duplicate incorrect ITEM tags for DEL messages.
The incorrect tags and message formation has been observed for clearance DEL and not for clearance ADD.

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