Transactions Stuck In Table MTL_TRANSACTIONS_INTERFACE Failing With Error Invalid Distribution Account
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.
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.
Invalid distribution account
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"
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