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 JANUARY 03, 2023

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"


Changes

 

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
Changes
Cause
Solution
References


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