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