Transactions Stuck In Table MTL_TRANSACTIONS_INTERFACE Failing With Error Invalid Distribution Account (Doc ID 2132578.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Inventory Transactions

Records stuck in the table MTL_TRANSACTIONS_INTERFACE with error stating that the distribution account is not valid for the given organization.

Error

Invalid distribution account

Steps

1. Interface Trip Stop creates records in MTL_TRANSACTIONS_INTERFACE table
2. Navigate: Inventory > Transactions > Transactions Open Interface
3. Find records stuck in the interface table with error code as " Invalid distribution account"


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