Inbound XML Transaction Not Being Processed (Doc ID 977884.1)

Last updated on MAY 13, 2013

Applies to:

Oracle XML Gateway - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 06-MAR-2013


Symptoms

The following are the steps followed to generate INBOUND Messages:

1. Load the MAP file using:

java oracle.apps.ecx.loader.LoadMap



2. Load the dtd file using:

java oracle.apps.ecx.loader.LoadDTDToClob



3. Created Custom table SO_DATA:

create table SO_DATA (SONUM VARCHAR2(10), SOTITLE VARCHAR2(20),
BUYERID VARCHAR2(20), BUYERNAME VARCHAR2(20), ITEMNUM VARCHAR2(10),ITEMQTY VARCHAR2(10));



4. XML Gateway Setup: Create a new Transaction

Go in XML Gateway responsibility-> Define Transactions
Party Type : Internal,Transaction Type : AAA
Transaction Sub Type : BBB,Transaction Description : Simple Test transaction type,Standard Code : OAG,Direction : IN
External Transaction Type : AAA,External Transaction Sub Type : BBB
Queue : APPS.ECX_IN_OAG_Q (select from LOV)



The ECX Agent Listener goes to error :

SVC-GSM-WFALSNRSVC-467575-10001 : oracle.apps.fnd.cp.gsc.SvcComponentThreadManager.maxErrorCountReached(Connection, ProcessorException)]:BEGIN (oracle.jdbc.driver.OracleConnection@149b290, oracle.apps.fnd.cp.gsc.ProcessorException: Could not executeUpdate() on { CALL WF_EVENT.LISTEN
( p_agent_name => :1, p_wait => :2, p_correlation => :3, p_deq_condition => null, p_message_count => :4, p_max_error_count => :5 )} ->
java.sql.SQLException: ORA-01086: savepoint 'BES_BEFORE_DEQUEUE_QH' never established
ORA-01086: savepoint 'BEFORE_DEQUEUE' never established
ORA-06512: at "APPS.ECX_INBOUND_ENGINE_QH", line 306
ORA-01086: savepoint 'BEFORE_PROCESSING' never established
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.WF_EVENT", line 1086
ORA-06512: at line 1

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