Late Customer Order Not Processed If Stock Count Was Processed After Customer Order Transaction Date (Doc ID 2566957.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

When a stock count has a date later than the transaction's date, no update is made to the status of the transaction in POS_TRANSACTION table.

Steps to Reproduce:

1. Create a unit stock count for item A.
2. Complete the stock count process.
3. Send a FULFILL transaction to POS_TRANSACTION for that item with TRANSACTION_DATE < LAST_STK_CNT_APPROVE_DATE.
4. FULFILL should fail because FUL_ORD still does not exists.
5. Create the FUL_ORD for that same item A and same CREATE_DATE as TRANSACTION_DATE.
6. Execute POSTransactionRetry.sh batch.
7. Note that FULFILL in POS_TRANSACTION stays a status 3 (Retry) and record in STORE_ITEM_STOCK_HISTORY was created, adjust was sent to RMS.
8. Execute POSTransactionRetry.sh batch again.
9. Note that FULFILL in POS_TRANSACTION remains in status 3 (Retry) and a new record in STORE_ITEM_STOCK_HISTORY was created, and another adjust was sent to RMS.

Changes

Cause