My Oracle Support Banner

Sales Order Interface Trip Stop Gives Error "For a Fixed Conversion the secondary quantity cannot deviate" and MTI Record is Missing Primary Quantity (Doc ID 2686694.1)

Last updated on APRIL 05, 2023

Applies to:

Oracle Inventory Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Inventory Convergence

Frequently when processing sales orders, transactions get stuck in mtl_transactions_interface (MTI) with
the following error:

ERROR
-----------------------
For a Fixed Conversion the secondary quantity cannot deviate

Frequently the primary_quantity in MTI and MTLI is also missing.

STEPS
-----------
1. Create Sales Order, Book, and Pick Release
2. Transact Move Order
3. Ship Confirm

BUSINESS IMPACT
-------------------------------
Customer is having to manually fix the stuck transactions every day, wasting lots of time

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.