ORA-20000: Exception:Flexbuilder Error Deriving Gain Loss Account ORA-06512 (Doc ID 605483.1)

Last updated on JULY 21, 2010

Applies to:

Oracle Receivables - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
ar115app.sql upgrade script

Symptoms

During upgrade to 11.5.10.2  the upgrade script ar115app.sql fails with the following error.

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

Calling AR_FLEXBUILDER_WF_PKG for APP: 573564
AR_FLEXBUILDER_WF_PKG x_arflexnum : 101
AR_FLEXBUILDER_WF_PKG x_arorigccid : 62356
AR_FLEXBUILDER_WF_PKG x_arsubsticcid : 17714
Exception : Flexbuilder error deriving Gain or Loss Account
ORA-20000:
Applications Processed : 203
Org Id : 422
Chart of Accounts : 101
Cash Receipt Id :
Application Id : 573564
Application Type : CM
Original ccid : 62356
Substitute ccid : 17714
Flex Error : FND FLEX-VALUE IS EXPIRED N VALUE 202
Exception : Flexbuilder error deriving Gain or Loss Account
ccount
Exception : Flexbuilder error deriving Gain or Loss Account
ORA-20000:
Applications Processed : 47
Org Id : 422
Chart of Accounts : 101
Cash Receipt Id : 82349
Application Id : 624232
Application Type : CASH
Original ccid : 62225
Substitute ccid : 17714
Flex Error : FND FLEX-VALUE IS EXPIRED N VALUE 202
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