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 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

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

EXPECTED BEHAVIOR
Expect Payment_trx_id to have a value.

STEPS
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

BUSINESS IMPACT
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.

.

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!


In this Document
Symptoms
Cause
Solution


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