Payload Tables Not Populated for Re-approved Clearance

Applies to:

Oracle Retail Price Management - Version 14.1.1 and laterInformation in this document applies to any platform.

Symptoms

Retail Price Management (RPM) does not update RPM_CLEARANCE_PAYLOAD table for a re-approved clearance.

Steps to Reproduce:

1. Create a Clearance at any level with future effective date.2. Approve the Clearance.3. Un-approve the same clearance.4. Change the change type or change amount, but do not change the effective date.5. Re approve the clearance.6. Run RPM Clearance Publish batch and RPM Clearance Export batch.7. Look at the .PUB file that is generated. Only CREATE CLEARANCE and DELETE CLEARANCE messages are available. There should be another CREATE CLEARANCE messages after the DELETE CLEARANCE messages.

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