MRTUPD.PC Batch is Updating MRT.CLOSE_DATE Value to the Current Date
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.
'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'
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