My Oracle Support Banner

Cannot Save Conditional Assumptions for Adjustment Rules Due to "Select a product to apply" Error (Doc ID 3010271.1)

Last updated on MARCH 15, 2024

Applies to:

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

Symptoms

On FTP 8.1.2.2 cannot save conditional assumptions for adjustment rules.

The saving of conditional assumption rules are failing with the following error in the Web Server ftpapp.log:

ERROR

[05-02-24 19:44:38,539 GMT PM] [DEBUG] [WEB] DBManager::wrapQuery() Param : {1=227915, 2=51000, 3=USD, 4=227926, 5=0, 6=208601}
[05-02-24 19:44:38,540 GMT PM] [DEBUG] [WEB] Query=INSERT INTO FSI_M_ADJUSTMENT_RULE(ADJUSTMENT_SYS_ID,PRODUCT_ID,CCY_CD,ADJUSTMENT_TYPE_CD,COND_SEQUENCE,PRODUCT_HIERARCHY_ID,ADJUSTMENT_METHOD_CD,RATE_TERM_CD,ASSIGNMENT_DATE_CD,LOOKUP_METHOD_CD,INTEREST_RATE_CD,BREAK_FUNDING_AMT,MINIMUM_CHARGE,RATE_SPREAD,BREAK_FUNDING_RATE,TP_CF_INTEREST_TYPE,EXCLUDE_ACCRUED_INT_FLG,INTEREST_ONLY_FLG,COND_SYS_ID, HOLIDAY_CALENDAR_CODE,HOLIDAY_ROLLING_CONVENTION_CD,HOLIDAY_CALC_OPTION_CD,OUTPUT_AUDIT_FLG,TP_RULE_SYS_ID, TP_RATE_TERM,TP_RATE_CAP,TP_RATE_FLOOR,IGNORE_ADJ_EFFECTIVE_DATE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?)
[05-02-24 19:44:38,540 GMT PM] [DEBUG] [WEB] DBManager::wrapQuery() Param : {1=227915, 2=51000, 3=USD, 4=1, 5=0, 6=208601, 7=3, 8=1, 9=1, 10=0, 11=7999, 12=, 13=, 14=, 15=, 16=, 17=0, 18=0, 19=227926, 20=-1, 21=1, 22=1, 23=false, 24=, 25=, 26=, 27=}
[05-02-24 19:44:38,540 GMT PM] [ERROR] [WEB] java.sql.SQLException: Missing IN or OUT parameter at index:: 28
java.sql.SQLException: Missing IN or OUT parameter at index:: 28
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1937) ~[ojdbc8.jar:19.16.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3657) ~[ojdbc8.jar:19.16.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[ojdbc8.jar:19.16.0.0.0]

The UI throws the error after pressing Save in the Conditional Assumption screen even though only a single product is already selected:

ERROR
Select a product to apply

The issue can be reproduced at will with the following steps:
1. Create a new Adjustment Rule

Select: Adjustment type = Liquidity Adjustment

2. Select the product and apply the TP method as "Do not calculate"

3. Define conditional assumption for the product and apply.

Filters: ADJ_RLS_AT_PRODUCT_FILTER
Condition: Loan Contracts-TP_EFFECTIVE_DATE include range values between 08/01/2023 and 12/31/2099 Method: Fixed Rate

Changes Applied shows Green Yes

Fixed Rate

Reference Term: Original Term
Lookup Method: Range
Holiday Calendar: None

Parameters:
>= 1 M <= 9999 Months Rate: 2.0000
Output Audit Detail is checked

4. Click on Save and it throws the error “Select a product to apply “ which was already selected in the previous screen.

Returns to Assumption Browser (out of Conditional Assumption)
Pop-up screen with Select a product to apply error

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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