Uncompiled objects after creating UDFs (Doc ID 1522266.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms

A UDF was added to the Account module. Now, when a User tries to approve an Invoice, the following error is displayed

ERROR
-----------------------
ORA-04061- existing state of package "SYNERGEN.SDBP_ACCOUNT_COST" has been invalidated. ORA-04065: not executed,altered,or dropped package "SYNERGEN.SDBP_ACCOUNT_COST"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Pull up an invoice in Created status
2. Set Invoice status to Approved
3. SAVE - Error is displayed

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