BSP Transfer Pricing Screen Does Not Save Records Log Shows ORA-01795 (Doc ID 2283696.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.9 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.2.0.9 version, Standard Forms

When user clicks Save button on BSP Transfer Pricing Rule screen, the screen does not respond.

Error:
bsplog.log shows:
2017-06-23 14:40:12,867 [INFO] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.ui.products.dao.ProductsDao - Product selector query : SELECT PRODUCT_DISPLAY_CODE, PRODUCT_NAME, '{"id":"' || PRODUCT_DISPLAY_CODE || '","nc":"' || PRODUCT_DISPLAY_CODE || '","name":"' || PRODUCT_NAME || '","nd":"null","if":"N","pid":"' || DIM_PRODUCTS_HIER.PARENT_ID || '","pnc":"' || DIM_PRODUCTS_HIER.PARENT_ID || '","lid":"3","lv":""}' DETAILS FROM DIM_PRODUCTS_HIER INNER JOIN DIM_PRODUCTS_B ON DIM_PRODUCTS_HIER.CHILD_ID = DIM_PRODUCTS_B.PRODUCT_ID INNER JOIN DIM_PRODUCTS_TL ON DIM_PRODUCTS_B.PRODUCT_ID = DIM_PRODUCTS_TL.PRODUCT_ID AND DIM_PRODUCTS_B.DEFINITION_LANGUAGE = DIM_PRODUCTS_TL.LANGUAGE WHERE DIM_PRODUCTS_HIER.HIERARCHY_ID = ? AND DIM_PRODUCTS_B.DEFINITION_LANGUAGE = ? AND ENABLED_FLAG = 'Y'AND PRODUCT_DISPLAY_CODE IN (61000265,61000264,61000263,61000262,61000261,61000260,61000259,61000258,61000257,61000256,61000255,61000254,61000253,61000252,61000251,61000250,61000249,....)
ORDER BY PRODUCT_DISPLAY_CODE
HIERARCHY_ID : 200004 DEFINITION_LANGUAGE : US
2017-06-23 14:40:12,871 [ERROR] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.framework.dao.impl.BaseDaoImpl - java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

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