My Oracle Support Banner

SALE_ITEM_REQ Error in Retail Sales Audit (ReSA) While Importing RTLOG For Changing Status of an Item to Pending (Doc ID 2055451.1)

Last updated on MAY 28, 2021

Applies to:

Oracle Retail Point-of-Service - Version 13.4 to 13.4.8 [Release 13.4]
Information in this document applies to any platform.


Importing a Retail Transaction Log (RTLOG) of transaction having a partial Pick up of an item is causing SALE_ITEM_REQ error in Retail Sales Audit (ReSA).

Steps to Reproduce:

1. Login to Point of Service (POS) application and scan an item for 4 times.
2. Select an item and then select Item Tab -> Pickup.
3. Enter Customer ID and then Pickup Date.
4. Click on Tender and complete the Transaction.
5. Receipt prints with Order details.
          RTLOG generated for this ORDINT record, along with Item details.
6. Now select TRANSACTION -> ORDER -> Modify -> PICK UP tab and Enter the order number created in Step(4).
7. Now select the Pickup item and Click on Pending Button, the status of the item changes to Pending.
8. Click on Tender and complete the Transaction.
       RTLOG generated for ORDPAR record, with No ITEM information available.
9.When consume this RTLOG in ReSA, it gives an error "SALE_ITEM_REQ".




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.