TRXN_EXTENSION_ID gets cleared when updating OE_PAYMENTS Using Oe_order_pub.Process_Order (Doc ID 1573992.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version

When attempting to use the Process Order API to update the receipt_method_id on an Order created with Payment Type = Credit Card , the Trxn_Extension_Id is cleared on the Oe_Payments table.
This is breaking the link between IBY table and the OE table , causing the Credit Card details to be cleared on the Payments screen.

The Receipt Method , however , can be updated successfully from Applications.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Use the Process Order API to update the Receipt Method on an existing Credit Card Order

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the Process Order API to update the Receipt Method.

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