Conn_Execute_Update_Error when Navigate to BSP Current Position Prepayment, Transfer Pricing, or Adjustment Entry (Doc ID 1603199.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.1 to 6.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 6.1 version, Calculation Engine

When attempting to add Current Position Prepayment Details, Transfer Pricing, or Adjustment Entry in Balance Sheet Planning (BSP) UI the following error occurs.
Navigation: Master Maintenance -> Assumption Forms and select Prepayment for Current Position.


Error:
2013-10-09 11:49:55,458 [DEBUG] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.ui.prepayments.dao.PrepaymentsDao - SQL_INSERT_PPMTS_OBJ_DEF_B:::INSERT INTO FSI_M_OBJECT_DEFINITION_B(OBJECT_DEFINITION_ID,OBJECT_ORIGIN_APP_CD,LEAF_NUM_ID,ID_TYPE,TABLE_NAME,FOLDER_ID,FOLDER_NAME,ACCESS_CD,APPL_NAME,DELETED_FLAG,SOURCE_LANG,CREATED_BY,CREATION_DATE) VALUES (?,'USER',( select rp.default_product_dimension from rev_app_user_preferences rp where appid='BSP' and upper(rp.user_id)='ADMIN' ),300,'FSI_M_PPMT','','BSP','W','BSP','N',UPPER(?),UPPER(?),SYSDATE)
2013-10-09 11:49:55,459 [ERROR] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.framework.dao.impl.BaseDaoImpl - Error occured at index====4
2013-10-09 11:49:55,459 [ERROR] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.framework.dao.impl.BaseDaoImpl - java.sql.SQLException: Invalid column index
java.sql.SQLException: Invalid column index

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