My Oracle Support Banner

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

Last updated on APRIL 23, 2021

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)


On : 6.1 version, 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.

2013-10-09 11:49:55,458 [DEBUG] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] - 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)'] - Error occured at index====4
2013-10-09 11:49:55,459 [ERROR] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] - java.sql.SQLException: Invalid column index
java.sql.SQLException: Invalid column index




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

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