FRM-40735 POST UPDATE Trigger raised unhandled exception ORA 04063 When Saving Assignment Information (Doc ID 2242661.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.
This note provides a brief overview of .

Symptoms

Problem Statement:

When attempting to update assignment, the following error occurs.

FRM-40735 POST UPDATE Trigger raised unhandled exception ORA 04063

 

PYUPIP shows that it fails at the trigger.

Hard call PAY_DYT_ELEMENT_ENTRY_VAL_PKG.after_insert
Ele ent Val ID: 70139
New Screen Val:
****************************************
Sqlcode>-6508<
Sqlerrm>ORA-06508: PL/SQL: could not find program unit being called<
**************************************

.....

HRG: ON-ROLLBACK                                                        10
hr_utils.app_trace_trigger
Status:0

 

Compiling package "PAY_DYT_ELEMENT_ENTRY_VAL_PKG" fails with the error below.

SQ> alter package PAY_DYT_ELEMENT_ENTRY_VAL_PKG compile body;


Error:

Errors for PACKAGE BODY PAY_DYT_ELEMENT_ENTRY_VAL_PKG:

LINE/COL ERROR
-------- ----------------------------------------------------------------------------------------
182/1    PLS-00103: Encountered the symbol "RETURN_VARIABLE" when expecting one of the following:
       
        . ( * @ % & = - + ; < / > at in is mod remainder not rem
        <an exponent (**)> <> or != or ~= >= <= <> and or like like2
        like4 likec between || multiset member submultiset
        The symbol ";" was substituted for "RETURN_VARIABLE" to continue.
       
184/3    PLS-00103: Encountered the symbol "IF" when expecting one of the following:
       
        . ( * @ % & = - + ; < / > at in is mod remainder not rem
        <an exponent (**)> <> or != or ~= >= <= <> and or like like2
        like4 likec between || multiset member submultiset
        The symbol ";" was substituted for "IF" to continue.

 

Generating the Dynamic Trigger "PAY_ELEMENT_ENTRY_VALUES_F_ARU" fails with the error below.

PL/SQL: Statement ignored
PLS-00306: wrong number of types of arguments in call to 'PAY_ELEMENT_ENTRY_VALUES_F_ARU'

 

Steps to Reproduce:

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

  1.  Create custom Dynamic Trigger similar to the seeded definition "PAY_ELEMENT_ENTRY_VALUES_F_ARU"
     (N) Other Definitions > Dynamic Triggers
     e.g.
       Name: XXPAY_ELEMENT_ENTRY_VALUES_F_ARU
       Table: PAY_ELEMENT_ENTRY_VALUES_F
       Component tab 
         Module Name: pay_continuous_calc.PAY_ELEMENT_ENTRY_VALUES_F_aru
         Enable: Check

  2.  Click on "Generated" but it fails with the error.
  3.  The seeded Dynamic Trigger "PAY_ELEMENT_ENTRY_VALUES_F_ARU" also fails to generate.
  4.  Package body PAY_DYT_ELEMENT_ENTRY_VAL_PKG becomes invalid.
  5.  Go to the Assignment form, change any information and save.
     (N) People > Enter and Maintain > (B) Assignment
  6.  Error occurs

 

 

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