My Oracle Support Banner

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

Last updated on MARCH 10, 2019

Applies to:

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


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'





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.