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.

Symptoms


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


ERROR
-----------------------
PLS-00306

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

Upgrade from 12.2.3 to 12.2.4


Changes

Upgrade from 12.2.3 to 12.2.4

 

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