ECM: TR_EXTERNAL_ACCOUNTS_CI does not work when trying to load two Bank Accounts (Doc ID 1903280.1)

Last updated on MARCH 17, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 and later
Information in this document applies to any platform.

Goal

Upload the External Accounts data using the delivered Excel to CI template, TR_EXTERNAL_ACCOUNTS_CI. When the upload process is completed, most of the rows of data in the template resulted in error.

ERROR
#2 - Unable to commit managed object in StoreSQL. There are already some pending Database updates. (2,904) FUNCLIB_BANK.SQL_FUNCTION.FieldFormula Name:Store_Bank_CFI_SQL PCPC:727 Statement:9
Called from:FUNCLIB_BANK.SQL_FUNCTION.FieldFormula Name:Bld_Bank_CFI_SQL Statement:98
Called from:BANK_ACCT_CHRT.BANK_ACCT_LED_TYPE.SavePreChange Statement:10
#3 - Error saving Component Interface. {TR_EXTERNAL_ACCOUNTS_CI} (91,37)
#4 - Error saving Component Interface. {TR_EXTERNAL_ACCOUNTS_CI}

Solution

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