SIM Incorrect Sales Accounting During Stock Count Completion. (Doc ID 3014031.1)

Last updated on APRIL 02, 2024

Applies to:

Symptoms

System is configured for Timestamp processing for stock count sales processing in SIM.
There is incorrect behavior in sales calculation during stock take in SIM with this parameter.

ACTUAL BEHAVIOR
---------------
It included before and after count date and Adjustment quantities were calculated incorrectly as well.

EXPECTED BEHAVIOR
-----------------------
SIM accounts only sales happened after stock_count_datetime value in stock_count_line_item table.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Create stock Unit and Amount stock count (type 2). When stock count was in status 1 perform few sales and were registered in stock_count_sale table.

2.Then perform counting the items and perform more sales.
3. Complete stock count process and notice that count_snapshot was updated with the quantity of sales happened before and after count date and

    Adjustment quantities were calculated incorrectly.

4.We expected SIM accounts only sales happened after stock_count_datetime value in stock_count_line_item table.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Incorrect sales are accounted.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.