Last updated on JULY 31, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.
Find that POSUPLD.PC batch books sales under wrong sales_type. This issue occurs every time when there are multiple tran_type entries on same action_date in PRICE_HIST (for example - tran_type 4 and 8 entries with same action_date).
Steps To Recreate:
- Have an item/loc where clearance and promotion both are active and both are going to end on same date. (In this case: Promotion DETAIL_END_DATE = 4th OCT 2015 and Clearance RESET_DATE = 5 Oct 2015).
- On 4th nightly batch, we get two price_hist entries one tran_type 4 and other tran_type 8 with action date as '5-OCT-15'.
- Now post a sale by POSUPLD.
- Notice the sale has been booked as Clearance sale however the item is neither on Clearance nor on Promotion.
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