Problem Compiling PN_VAR_RENT_PKG Package Body After 12.2.4 Upgrad.

(Doc ID 2268280.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Property Manager - Version 12.2.4 and later
Information in this document applies to any platform.


Upgraded form 12.2.3 to 12.2.4 and PN_VAR_RENT_PKG is invalid after the upgrade.

PLS-00306: wrong number or types of arguments in call to 'DELETE_ROW'
PL/SQL: Statement ignored

Also when opening View Variable Rent form the following error occurs

FRM- 40735: PRE-BLOCK trigger raised unhandled exception ORA-04063


The issue can be reproduced at will with the following steps:

Upgrade from 12.2.3 to 12.2.4


Upgrade from 12.2.3 to 12.2.4



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