My Oracle Support Banner

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

Last updated on AUGUST 08, 2018

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

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.