My Oracle Support Banner

R12: How To Associate The Oracle Payments Transaction To The AR Receipt Number? (Doc ID 803787.1)

Last updated on SEPTEMBER 26, 2018

Applies to:

Oracle Payments - Version 12.0.4 and later
Information in this document applies to any platform.

Goal

How to make the association between the TANGIBLEID in Payments table IBY_TRXN_SUMMARIES_ALL and the receipt id in AR?

Previously, the Receipt Number reference used to be present in the TANGIBLEID column in the table iby_trxn_summaries_all, but this has changed after a number of AR patches have been applied.

e.g.
TANGIBLEID=AR_1001-10012_RECEIPT_1001-10011

Whereas now we are getting only:
TANGIBLEID=AR_24021 (here 24021 is the transaction extension id).

Solution

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
Goal
Solution

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