Upgrade Errors: Autoupgrade Script Ar115app.Sql Fails with ORA-20000: Exception : Flexbuilder error deriving Gain or Loss Account

(Doc ID 401373.1)

Last updated on NOVEMBER 13, 2012

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.


Symptoms

You are running the upgrade tool from 11.0.3 to 11.5.10. When running the script ar115app.sql it errors with:

DECLARE
*
ERROR at line 1:
ORA-20000: Exception : Flexbuilder error deriving Gain or Loss Account
ORA-06512: at line 613


To investigate the issue, run the script in debug mode, See <Note 158812.1> for instructions. The log file will show something like the following:

Creating accounting for Receivable, Gain, Loss, Discount Accounts(+)

Calling AR_FLEXBUILDER_WF_PKG for APP: 1526564
AR_FLEXBUILDER_WF_PKG x_arflexnum : 101
AR_FLEXBUILDER_WF_PKG x_arorigccid : 38149
AR_FLEXBUILDER_WF_PKG x_arsubsticcid : 32697
Exception : Flexbuilder error deriving Gain or Loss Account
ORA-20000:
Applications Processed : 197
Org Id : 157
Chart of Accounts : 101
Cash Receipt Id : 348261
Application Id : 1526564
Application Type : CASH
Original ccid : 38149
Substitute ccid : 32697
Flex Error : FNDFLEX-VALUE NOT FOUNDNVALUE05
Exception : Flexbuilder error deriving Gain or Loss Account

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