Adjusting Asset Cost in Asset Workbench Returns ORA-04063: package body "APPS.CLE_F078_FA_CHMATE_PKG" has errors (Doc ID 2738637.1)

Last updated on MARCH 20, 2025

Applies to:

Symptoms

When attempting to adjust an asset cost in the Asset Workbench, the following errors occur:

ERROR
-----------------------
APP-OFA-48397 Program exited with errors:

ORA-04063: package body "APPS.CLE_F078_FA_CHMATE_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.CLE_F078_FA_CHMATE_PKG"
ORA-06512: at "APPS.CLEF078_FATHTRIG_AUI", line 25
ORA-04088 error during execution of trigger 'APPS.CLEF078_FATHTRIG_AUI'

Error: function FA_TRANSACTIONS_HEADERS_PKG.Insert_row has errors

ORA-04063: package body "APPS.CLE_F078_FA_CHMATE_PKG" has errors


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the Asset Workbench
2. Query an asset, attempt to change the cost

Cause

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