Inbound Acknowledge PO XML Fails: Collaboration Not Found For Application Reference ID (Doc ID 2183670.1)

Last updated on SEPTEMBER 16, 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,

When attempting to send an acknowledgment which contains the referenceID as specified from outgoing PO it errors out because it can not find a collaboration with the specified referenceID,
the following error occurs.

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

Outgoing:
21-jan-2016 15:37:14:2: ==========ENTERING CLN_CREATE_EVENT_SUB===========
21-jan-2016 15:37:14:1: ----------- PARAMETERS OBTAINED ----------
21-jan-2016 15:37:14:1: Subscriber List ----
21-jan-2016 15:37:14:1: XMLG Message ID ----
21-jan-2016 15:37:14:1: XMLG Internal Control Number ----
21-jan-2016 15:37:14:1: XMLG Ext Transaction Type ----
21-jan-2016 15:37:14:1: XMLG Ext Transaction Sub Type ----
21-jan-2016 15:37:14:1: XMLG Int Transaction Type ----PO
21-jan-2016 15:37:14:1: XMLG Int Transaction Sub Type ----PRO
21-jan-2016 15:37:14:1: XMLG Document ID ----2000457:0:5162
21-jan-2016 15:37:14:1: Document Direction ----OUT
21-jan-2016 15:37:14:1: Trading Partner Type ----S
21-jan-2016 15:37:14:1: Trading Partner ID ----33308
21-jan-2016 15:37:14:1: Trading Partner Site ----77047
21-jan-2016 15:37:14:1: Sender Protocol ----
21-jan-2016 15:37:14:1: Reference ID ----
21-jan-2016 15:37:14:1: Document Number ----2000457
21-jan-2016 15:37:14:3: Error:-6502:ORA-06502: PL/SQL: numeric or value error: character to number conversion error
21-jan-2016 15:37:14:2: ============EXITING CLN_CREATE_EVENT_SUB============

Incoming
21-jan-2016 16:14:08:1: ############### START OF XGM DEBUG FILE #################
21-jan-2016 16:14:08:2: ---- Entering PROCESS_HEADER API -----
21-jan-2016 16:14:08:1: ----- PARAMETERS RECEIVED -------
21-jan-2016 16:14:08:1: Status received - S
21-jan-2016 16:14:08:1: Message received -
21-jan-2016 16:14:08:1: Reference ID - OSST:oracle.apps.po.event.xmlpo:127535-213170
21-jan-2016 16:14:08:1: Sender Component -
21-jan-2016 16:14:08:1: PO Number - 2000457
21-jan-2016 16:14:08:1: Release Number -
21-jan-2016 16:14:08:1: Revision Number - 0
21-jan-2016 16:14:08:1: Ackcode at header level - 0
21-jan-2016 16:14:08:1: Note -
21-jan-2016 16:14:08:1: CLN reqd - TRUE
21-jan-2016 16:14:08:1: p_tp_header_id - 413
21-jan-2016 16:14:08:1: Requestor - SYSADMIN
21-jan-2016 16:14:08:1: Internal Ctrl Number - 990427
21-jan-2016 16:14:08:1: Request Origin - 9iAS
21-jan-2016 16:14:08:1: ----------------------------------
21-jan-2016 16:14:08:1: Application Reference ID is not null
21-jan-2016 16:14:08:4: Collaboration Not Found For Application reference ID :OSST:oracle.apps.po.event.xmlpo:127535-213170
21-jan-2016 16:14:08:2: ---- ERROR :Exiting PROCESS_HEADER API -----


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Sent a PO message
2. Send an acknowledgment for the PO




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