Inventory Transactions Open Interface Not Honouring Deviation Factor For Dual UOM Items
Last updated on DECEMBER 19, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Concurrent: INCTCM - Process transaction interface
Concurrent: INCTCW - Inventory transaction worker
Form: INVTTMTX.fmb - Inventory Transactions
You are able to import a Subinventory Transfer transaction through the Transactions Open Interface, for a dual UOM item that will violate the Deviation Factor settings at item level.
When performing a similar transaction manually through the Subinventory Transfer transaction form (INVTTMTX), the form displays the error seen below.
Error (in the form)
Transactions Open Interface should reject such transaction as the form does.
The issue can be replicated per the following steps:
1. Create a plain item with below settings:
Primary UOM: Paper Net Kilogram (KGP)
Tracking: Primary & Secondary
Secondary: Bobbin (BOB)
Defaulting: No Default
Deviation Factor +: 9900%
Deviation Factor -: 80%
Also an Inter-class conversion is defined for the item as below:
1 BOB of class Bobbin = 2800 KGP of class Paper Mass
2. Populate table MTL_TRANSACTIONS_INTERFACE to import a Subinventory Transfer transaction with the following data:
3. Submit the above transaction
See it gets successfully processed which is unexpected
4. Try to perform a similar transaction with same data through the Subinventory Transfer transaction form
See above error is raised as expected
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