ORA-01791 Error When Trying to Select an IRC in the Transfer Pricing Rule Using RDBMS 11.2.0.4 (Doc ID 1598688.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

When attempting to select any Interest Rate Code (IRC) trying to define a Transfer Pricing Rules with method of Spread from Interest Rate Code, the Drop-down list is empty. The following error is displayed in ftpapp.log file: 

ERROR
ORA-01791: not a SELECTed expression

Methos is fetchIrcCD ::: infodom is :::: ORAINFODOM
[29-10-13 12:23:08 PM] ~ DEBUG ~ FTP ~ DBManager::executeQuery() Start :
[29-10-13 12:23:08 PM] ~ DEBUG ~ FTP ~ DBManager::executeQuery() Query : select distinct interest_rate_cd,'[' || iso_currency_cd || '] ' || IRC_NAME || ' (' || interest_rate_cd || ')' as IRC_NAME,upper(IRC_NAME) as IRC_NAME2 from FSI_IRCS where (iso_currency_cd = 'CNY' or display_for_all_ccy_flg = 1) and volatility_curve_flg != 1 order by iso_currency_cd, IRC_NAME2
[29-10-13 12:23:08 PM] ~ DEBUG ~ FTP ~ DBManager::executeQuery() : ORA-01791: not a SELECTed expression

The database version is 11.2.0.4.0. This error/issue is not reproducible if using versions lower than 11.2.0.4.

Note: In some cases, the error is not displayed but the ftpapp.log shows "fetchircCD" returns no values:

[08-03-17 11:48:25 AM] ~ INFO ~ FTP ~ Inside class com.ofs.fsapps.ftp.util.LookupUtil
Methos is fetchIrcCD ::: infodom is :::: ATOMICUSER
[08-03-17 11:48:25 AM] ~ INFO ~ FTP ~ fetchircCD query::: :::: {}
 

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

1. Add product member, Add product hierarchies.
2. Add some Interest Rates Code. Input IRC rate.
3. Add Transfer Pricing Rules, using Spread from Interest Rate Code method. Then can not select any Interest Rate Code.

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