Error 1110 Multiple Instrument/Transaction cannot be selected in Source/Driver/Output When Creating or Updating Allocation Specifying Multiple Tables

(Doc ID 1525970.1)

Last updated on FEBRUARY 04, 2013

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.x

Symptoms

On Oracle Financial Services Profitability Management (PFT) 6.0.3, when attempting to create a Transaction to Instrument Percent Distribution allocation, the following error occurs when saving:

ERROR
Error 1110 - Multiple Instrument/Transaction cannot be selected in Source/Driver/Output

This rule references two tables, one in the source, and another in the driver/output tables.



The error does not occur in PFT 5.6.

STEPS

The issue can be reproduced at will with the following steps:

1. Create a new Dynamic Driver allocation
2. Choose any transaction table / column for source
3. Choose a different instrument table /column for driver
4. Choose the same instrument table for Debit
5. Define no Credit
6. Attempt to save, pop-up error occurs.

Cause

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