My Oracle Support Banner

PAYMENT_TRX_ID field from the OE_PAYMENTS table is not being updated when payment entered against sales order (Doc ID 604031.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Order Management - Version to [Release 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.


On 11.5.10
Find PAYMENT_TRX_ID field is not populated in OE_PAYMENTS table , after Payments Header action is completed.

Expect Payment_trx_id to have a value.

The issue can be reproduced at will with the following steps:
1. Enter at the responsibility Order Management Super User

2. Enter at the Orders, Returns > Sales Orders
3. Create a sales order and select at the order header the Actions button
4. Select the Payments function

The issue has the following business impact:
Impact for the business is that the required data for PAYMENT_TRX_ID field from the OE_PAYMENTS table is not available.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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