Collaboration Not Created While Approving PO - Inbound Xml Failing For The Same (Doc ID 2137666.1)

Last updated on MAY 13, 2016

Applies to:

Oracle Supply Chain Trading Connector - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Collaboration History

Collaboration not created while approving PO - Inbound xml failing for the same
 
The XML GATEWAY Setup has:
PO--PRO--OAG--PO--PROCESS--itg_process_po_007_out(Map Name)
PO--ACKPO-- OAG--PO--ACKNOWLEDGE--CLN_PO_ACKPO_OAG72_IN(Map Name)
Details attached.

When the acknowledgements are coming from the suppliers , we found the following error:

ECX Transaction Type PO
ECX Transaction Subtype ACKNOWLEDGE
Message ID 32682B0108161837E0540010E02DB5AE
ECX Document Id 2001066:922:
ECX Error Type 25
ECX Error Message Inbound ACKPO for ( PO = 2001066 ), (Release no = 922), (Revision no= 2) failed with error : Collaboration Not Found For Application reference ID : BIOPROD.HEALTH.GE.COM:oracle.apps.po.event.xmlpo:1066-875008.
ECX Return Code 2

After looking into the issue I found that the record for PO creation is missing from the CLN_COLL_HIST_HDR table , but the Process PO outbound xml was generated in the ecx_doclogs table.

This is hampering the business flow and supplier response and changes are not working properly.
Please advise for the issue as soon as possible.

The issue is happening only when the PR released from Planning (VCP)

Requisition is converted into PO using create PO and PO approved
But no data in the table CLN_COLL_HIST_HDR

IF the same release id revised the then the table has data

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms