R12 Cannot Upload Asset With Prorate Convention Through Additions Integrator On WebADI After Patch 9538685 (Doc ID 1409403.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Assets - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When uploading assets with a prorate convention through the Additions Integrator on WebADI, an error is received:  "You must define a prorate period for this prorate convention."  The prorate convention is valid with a valid calendar for the Date Placed in Service.

BNE log Shows:
-----------------------
2/2/12 4:09 PM Web ADI Upload Job 871731 ERROR          BneBaseSQL.executeQuery: Exception while running query.  Error Code: 904, Message: ORA-00904: "PRORATE_CONVENTION": invalid identifier

2/2/12 4:09 PM Web ADI Upload Job 871731 ERROR          BneBaseSQL.executeQuery: Query: SELECT PRORATE_CONVENTION_CODE, DESCRIPTION FROM FA_CONVENTION_TYPES  WHERE  FISCAL_YEAR_NAME IN (SELECT FISCAL_YEAR_NAME FROM FA_BOOK_CONTROLS WHERE BOOK_TYPE_CODE = :1) AND  PRORATE_CONVENTION = :1  ORDER BY 1
2/2/12 4:09 PM Web ADI Upload Job 871731 ERROR          BneBaseSQL.executeQuery: Args : TEST_BOOK20, TEST_CONV02
2/2/12 4:09 PM Web ADI Upload Job 871731 ERROR          BneBaseSQL.executeQuery: Stack trace: java.sql.SQLSyntaxErrorException: ORA-00904: "PRORATE_CONVENTION": invalid identifier

Changes

 Applied <Patch 9538685>.

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