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 MARCH 08, 2017

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

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