My Oracle Support Banner

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.


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

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"

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.