My Oracle Support Banner

INVITEM in POS_ASN SEEDED Map Not Allowing Serial Number Updates (Doc ID 2396847.1)

Last updated on MAY 09, 2018

Applies to:

Oracle XML Gateway - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, XML Transactions - Documents

In Oracle XML Gateway, INVITEM in POS_ASN seeded map not allowing serial number updates  
When using Seeded POS_ASN XML mapping the file fails to post when we add the INVITEM details to include the INVDETAIL which post to the mtl_serial table.  
We are getting the following errors.
ORA-01003: no statement parsed - ECX_ACTIONS.BIND_PROC_VARIABLES


ERROR
-----------------------
ORA-01003: no statement parsed - ECX_ACTIONS.BIND_PROC_VARIABLES


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. XML Gateway partner is set up.
2. Ship to and ship from supplier and inventory locations have been updated with EDI ID
3. file is posted as SHIPMENT-SHOW using POS_ASN mapping

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import POS_ASN transactions without error.

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!


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