Actual Cost Is Changed In Physical Adjustment Table After Entering Tag Quantity (Doc ID 2221747.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
After users enter Tag Count, when trying to view adjustments in Approve Adjustments form, the Actual Cost is updated as 1

In Oracle Warehouse Management, in a WMS enabled organization which uses Average Costing, 'actual_cost' column in mtl_physical_adjustments table
is getting incorrectly updated to 1 after entering Tag Count.

This is happening when there are multiple records for the item being counted in CST_QUANTITY_LAYERS table.

EXPECTED BEHAVIOR
-----------------------
Actual Cost column value is calculated correctly

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

1. In a WMS organization which uses Average Costing, pick an item that has multiple cost layers i.e. multiple rows in cst_quantity_layers table.
     Also, the item should have Unit Cost for Average Cost Type as greater than 1.
2. Define a new Physical Inventory. Set Approvals to Required Always and check the Allow Dynamic Tags box. Perform the snapshot.
3. In Tag Counts form, enter a count for the item selected in Step 1 in any sub/loc that does not have onhand for the item. Enter Qty as 1.
4. Next, on Approve Adjustments form, check the Adjustment Value ( or actual_cost column value in mtl_physical_adjustments table) , it shows as Actual Cost = 1

 

Cause

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 hundreds of Community platforms