My Oracle Support Banner

Inventory Interface Errors with Distribution Account Is Not Valid For The Given Organization for a Batch Containing Internal and Standard Orders (Doc ID 1564495.1)

Last updated on JUNE 20, 2018

Applies to:

Oracle Shipping Execution - Version 12.0.6 to 12.2.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms


When attempting to interface a combination of standard orders and internal orders with a destination type of 'Inventory', the following error occurs:

 

ERROR
-----------------------

"Distribution account is not valid for the given organization. Please re-enter"

 


WORKAROUND
------------------------
Current workaround is to purge the MTI records and then resubmit the Interface Trip Stop for the specific delivery.


STEPS
-----------------------
The issue cannot be reproduced at will:
1) ITS creates INV records in MTL_TRANSACTION_INTERFACE.
2) Find sometimes these records get stuck in the interface table with error_code as "Distribution account is not valid for the given organization. Please re-enter"


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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.