Czech Republic : ORA-04063 package body apps.CLE_F078_FA_CHMATE_PKG has errors. (Doc ID 2785258.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Problem Description
---------------------
Error observed when trying to perform an adjustment for an asset.
Issue is observed for all assets pertaining to country Czech Republic.

Error message
-----------------
APP-OFA-48397: Program existed 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_TRANSACTION_HEADERS_PKG.Insert_row' returned failure.
ORA-04063: package body APPS.CLE_F078_FA_CHMATE_PKG has errors.
Error: function fa_adjustment_pvt.do_adjustment returned failure.
Error: function fa_adjustment_pub.do_all_books returned failure.
Error: function fa_adjustment_pub.do_adjustment returned failure.

Steps for replication
---------------------
1. (N) - Fixed Assets - Assets 
     Try to make an adjustment for any asset by providing the 
     Current cost and Original cost an error is observed. 

Expected Behavior
---------------------
Expectation is such that the adjustment should be allowed to complete without any errors.

Changes

Cause

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