My Oracle Support Banner

Claim Shows The Incorrect AP Invoice Number If There Is an Existing Reference_key1 (Doc ID 1460891.1)

Last updated on JULY 03, 2019

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.


When settling Claim with Check method, incorrect Invoice is pulled when reference key value is same in ap_invoices_all.

Steps to Reproduce:

1) Steps to Reproduce
1. Crate manual Claim
2. Associate Earnings
3. Approve Claim
4. Settle Claim
5. Process Invoice
6. Invoice not paid yet

In Settlement page, Payment Detail, incorrect Invoice is shown. Instead of CLAXXXXX, it shows the Invoice XXXXX , which is not a Trade Management sourced Invoice.)

select * from apps.ap_invoices_all
where invoice_num in ('XXXXX','CLAXXXXX'); results show that both Invoices has the same reference key value.


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.