MRTUPD.PC Batch is Updating MRT.CLOSE_DATE Value to the Current Date (Doc ID 2228692.1)

Last updated on FEBRUARY 07, 2017

Applies to:

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

Symptoms

'mrtupd' batch is updating MRT.CLOSE_DATE value to the current date value due to which MRT and related transfers are not purged from the system.

Steps to Recreate:

1. Verify that the MRT.CLOSE_DATE column has values showing past date for the MRTs which have MRT.STATUS=C
2. Notice the PERIOD.VDATE value and Run "mrtupd" batch
3. After running "mrtupd", below query shows that the MRT.CLOSE_DATE values are updated to current VDATE value noticed in Step 2
> SELECT close_date FROM mrt WHERE mrt_status='C'

 

Changes


 

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