The Upgrade Scripts Ar120bnk.sql and Ar120pay.sql Create Multiple Instrument Assignment IDs in the Extension Tables

(Doc ID 1507881.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.


There are multiple Instrument Assignment IDs in the extension tables for some transactions.

The Instrument Assignment IDs are different for the Transaction extension and the Receipt extension, but the Payer_id is same for both the records.

Verified the assignments data and for one record it is in sync with the Payer_id and for other it is not in sync.

The following scripts populate the extension tables:


Upgrade from 11i to R12


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