My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2023

Applies to:

Oracle Human Resources - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Oracle Payroll - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
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

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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