My Oracle Support Banner

Wrong Sales Types While Posting Late Transaction For Clearance Sales (Doc ID 2214466.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Retail Sales Audit - Version 15.0 to 15.0 [Release 15.0]
Information in this document applies to any platform.


Wrong sales types are being posted while performing late transaction for clearance.For clearance sales, if we do the post dated late transaction when alternative price record is existed (e.g. price reset / regular price change), the wrong sales types will be picked which is not clearance tran type 8 (Single unit retail was changed in Clearance).
Steps To Recreate:

1.Create clearance on 27th Sep for item 100350016 with retail value as 17.85. Set reset date as 29th Sep,Details are created in below tables:
         price_hist with tran_type 8
         item_loc is updated the the unit_retail as 17.85

2.Create sale on the same day for the item on clearance (i.e with clearance retail 18.75).
         Sa_tran_item had the unit_retail as 17.85

3.Move the vdate to 28th sep , run the following batches: 

Check the below tables, Unit retail is reset back to original unit retail.
        item_loc updated to unit_retail as 25.5
        price_hist is updated with tran_type 4 (i.e original retail populated) 25.5

4. Move the date further (i.e 2nd Oct) run process the sale created on 27th sep

Run the following batches
         below is the created posu file:

$ cat POSU27.01
THEAD000000000220160927000000ITM100350016 240100040002N22 000000000000SN000000100000EA P00000000000001785000 N000000000000 00000000000000000000R


5. Check the tran_data postings, for the clearance late sale, sales type is updated to  'R' .

> Select item,tran_date,pgm_name,old_unit_retail,new_unit_retail,sales_type from tran_data where item='100350016'

------------------------- --------- ---------------------------------------------------------------
100350016   27-SEP-16 salesprocess                                                                  R
100350016   27-SEP-16 salesprocess           25.5               17.85




To view full details, 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 a vibrant support community of peers and Oracle experts.