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

Last updated on JANUARY 16, 2015

Applies to:

Oracle Payments - Version 12.0.4 and later
Information in this document applies to any platform.
Checked for relevance on 21-NOV-2013.


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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms