My Oracle Support Banner

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 later
Oracle 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


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