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

Last updated on MAY 02, 2023

Applies to:

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

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