Inventory Transactions Open Interface Not Honouring Deviation Factor For Dual UOM Items (Doc ID 1936826.1)

Last updated on JULY 18, 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

Symptoms

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)

Expectation
Transactions Open Interface should reject such transaction as the form does.

Steps
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:
TRANSACTION_QUANTITY: 24862486
PRIMARY_QUANTITY: null
TRANSACTION_UOM: KGP
SECONDARY_UOM_CODE: BOB
SECONDARY_TRANSACTION_QUANTITY: 1
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


Changes

 

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