ASNin Messages Stuck In MPS Staged (Doc ID 2977884.1)

Last updated on OCTOBER 06, 2023

Applies to:

Symptoms

On : 19.6 version, Integration

When attempting to process ASNInCre messages in MPS, the following error occurs.

ERROR
-----------------------

<?xml version="1.0" encoding="UTF-8"?>
<AsnInDeo>
<asn>204123829</asn>
<asnInPoList>
<containerList>
<containerId>005888866-1</containerId>
<itemDeoList>
<custOrderNbr>005888866-1</custOrderNbr>
<fulfillOrderNbr>005888866-1</fulfillOrderNbr>
<itemId>7020025</itemId>
<unitQty>100.0000</unitQty>
</itemDeoList>
<itemDeoList>
<custOrderNbr>005888866-1</custOrderNbr>
<fulfillOrderNbr>005888866-1</fulfillOrderNbr>
<itemId>50380007</itemId>
<unitQty>3.0000</unitQty>
</itemDeoList>
<itemDeoList>
<custOrderNbr>005888866-1</custOrderNbr>
<fulfillOrderNbr>005888866-1</fulfillOrderNbr>
<itemId>50380001</itemId>
<unitQty>2.0000</unitQty>
</itemDeoList>
<itemDeoList>
<custOrderNbr>005888866-1</custOrderNbr>
<fulfillOrderNbr>005888866-1</fulfillOrderNbr>
<itemId>9107014</itemId>
<unitQty>1.0000</unitQty>
</itemDeoList>
<itemDeoList>
<custOrderNbr>005888866-1</custOrderNbr>
<fulfillOrderNbr>005888866-1</fulfillOrderNbr>
<itemId>130711010</itemId>
<unitQty>2.0000</unitQty>
</itemDeoList>
</containerList>
<docType>T</docType>
<poNumber>283017080</poNumber>
</asnInPoList>
<autoConfirm>false</autoConfirm>
<bolExternalId>204123829</bolExternalId>
<fromLocType>S</fromLocType>
<fromLocation>13</fromLocation>
<shipmentDate>2023-03-16T05:00:00Z</shipmentDate>
<stockHolding>Y</stockHolding>
<toLocType>S</toLocType>
<toLocation>85</toLocation>
</AsnInDeo>

From the server log:

2023-03-20 13:22:08,836 ERROR [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'][o.r.s.s.e.MpsServiceBean_mgpxbe_Impl] Error occurred during service invocation.

ERROR-60756 Time: 3/20/23 1:22 PM Type: SimServerException Message: Error processing message! [Inbound: true, MessageType: ASNInCre, BusinessId: 005888866-1] Root Cause: null
java.lang.NullPointerException: null

2023-03-20 13:21:48,482 ERROR [[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'][o.r.s.s.e.MpsServiceBean_mgpxbe_Impl] Error occurred during service invocation.

ERROR-28062 Time: 3/20/23 1:21 PM Type: SimServerException Message: Error processing message! [Inbound: true, MessageType: ASNInCre, BusinessId: 006152665-1] Root Cause: null
java.lang.NullPointerException: null

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. ASNInCre messages listed above fail to process once in MPS table.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the ASN into SIOCS.

Cause

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