Wholesale Return Purge Is Not Purging The Returns Which Do Not Have Entry In Table WF_BILLING_RETURNS
Last updated on OCTOBER 18, 2016
Applies to:Oracle Retail Merchandising System - Version 13.1.6 and later
Information in this document applies to any platform.
On : 13.1.6 version, Batches
WFRTNPRG program is not deleting Franchise (WF) returns which were closed from approved status if no corresponding records are found in WF_BILLING_RETURNS.
Steps to reproduce:
The issue can be reproduced at will with the following steps:
- Create WF return and approve.
- Close the WF return.
- Change the vdate such that the WFRTNPRG to pick up the return for purging.
- Notice the return is not purged due to no records in WF_BILLING_RETURNS table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms