My Oracle Support Banner

DLYPRG Batch is Not Deleting the Items Attached to PO in C Status (Doc ID 2891074.1)

Last updated on AUGUST 22, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and later
Information in this document applies to any platform.


 Dlyprg batch is not deleting the items attached to Purchase Order(PO) in C status.

Steps To Recreate:

1. Create a Customer Order using REF_ITEM (Level-3 Item).
2. MFCS internally creates a Purchase Order for the Customer Order.
3. Check the PO data in ORHEAD, ORDLOC and ORDSKU tables.
4. Receive the Purchase Order fully.
5. Run the DOCCLOSE batch from POM. (PO is now in C (closed) status ).
6. Delete the Level-3 item from MFCS UI.
7. Check the DAILY_PURGE Table (Level-3 Item is present).
8. Run the DAILY_PURGE_JOB .

Result : Level-3 item is not getting deleted even though the PO is closed and when checked in DAILY_PURGE_ERROR_LOG table ,could see the below error :


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.