Get Error "The subinventories have incompatible types with respect to transaction type and item type" When Using the API GME_API_PUB.CREATE_MATERIAL_TXN (Doc ID 1504986.1)

Last updated on JANUARY 22, 2020

Applies to:

Symptoms

When attempting to run the api gme_api_pub.create_material_txn to create a material transaction against a non-quantity tracked subinventory, get the following error:

ERROR (INV_INT_SUBTYPEXP)
The subinventories have incompatible types with respect to transaction type and item type.

STEPS
1. Use the api gme_api_pub.create_material_txn to create a WIP issue transactions against a non-quantity tracked subinventory.

Or you can insert records into the transaction open interface (MTL_TRANSACTIONS_INTERFACE).

2. The record fails with the error.

BUSINESS IMPACT
Due to this issue, users cannot use the api to create a transactions as they can in the form.

Cause

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