My Oracle Support Banner

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

Last updated on SEPTEMBER 06, 2021

Applies to:

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


 Actual Cost is changed in Physical adjustment table after entering the tag quantity.

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.

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 is 1 or verify from backend that actual_cost column value in mtl_physical_adjustments table is 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.