My Oracle Support Banner

Event For Generating ASN XML Not Getting Created Via CLN: Send XML Show Shipment Document. (Doc ID 1917744.1)

Last updated on MARCH 13, 2025

Applies to:

Oracle Supply Chain Trading Connector - Version 12.1.3 to 12.2.14 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to execute CLN : Send XML Show Shipment Document , the following error occurs.

-- Error
The cursor is fetching more than one record .

-- What is working
Works if the location is not assigned to multiple customer sites.

 -- Steps
The issue can be reproduced at will with the following steps.
1. Instance has customer data which is setup in the XML Gateway Trading Partner setup.

Customer - XXXXXXX
Site - XXXXXXXX
Transaction Type- CLN
Transaction Subtype - SHOWSHIPO
Standard Code - OAG


2. After executing CLN : Send XML Show Shipment Document,  Event for ASN XML is not getting generated for Deliveries for the particular customer site.

-- Business Impact
The issue has the following business impact:
Due to this issue, ASN Transactions for a customer site combination is not getting delivered causing issues to the customer is processing the deliveries.

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
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.