DataFix: ITS is Failing to Interface Delivery Lines into Inventory Due to Null Warehouse at Sales Order Line Level
(Doc ID 2882645.1)
Last updated on APRIL 19, 2024
Applies to:
Oracle Shipping Execution - Version 12.2.3 and laterOracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.
Symptoms
Sales Order Shipped and Closed. Interfaced to Order Management but Inventory Interface is failing. It appears Warehouse is Null for the delivery.
ERROR:
Calling program unit OE_FLEX_COGS_PUB.START_PROCESS
NO. OF OE MESSAGES :1
RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
CONCAT_SEGS IS
CONCAT_IDS IS
CONCAT_DESCRS IS
L_CONGS_RETURN_CCID IS
Please enter a Warehouse for line XXXXX
l_account ==> is NULL
Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT (06/30/2022 11:14:35 AM, .01 seconds)
RET_STATUS:E ACCOUNT_ID:
Unable to get account for delivery detail id XXXXX
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Shipping Execution Responsibility
2. Run Interface Trip Stop SRS program for problematic delivery.
3. Open the log file of ITS and check. Error occurs.
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 |