My Oracle Support Banner

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

Last updated on JULY 08, 2020

Applies to:

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


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.

Actual Cost column value is calculated correctly

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





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.