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:

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

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