PAYWSDRP Adding an Element to an Element Set Errors with: FRM_40735:ON_ERROR trigger raised unhandled exception ORA-03114 (Doc ID 1365738.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
*** Checked for currency on 17-FEB-2015 ***

Symptoms

Attempting to add a new element to an element set results in error.


FRM_40735:ON_ERROR trigger raised unhandled exception ORA-03114

APP_FND_01564: Oracle error 3114 in audfrm
Cause: audfrm failed due to ORA_03114: not connected to Oracle
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE

 

Have tried to recompile forms using adadmin but get the following error:

The following Oracle Forms objects did not generate successfully:

pay forms/US PAYWSDRP.fmx

FRM-30064: Unable to parse statement select et.element_type_id, ettl.element_name, et.processing_type, hl.meaning, ecl.classification_id, ecltl.classification_name from pay_element_types_f et, pay_element_classifications ecl, hr_lookups hl, pay_element_types_f_tl ettl, pay_element_classifications_tl ecltl where
ettl.language = userenv('LANG') and
ecltl.language = userenv('LANG') and
ecl.classification_id = ecltl.classification_id and et.element_type_id = ettl.element_type_id and nvl(et.business_group_id,nvl(:ctl_globals.business_group_id,-1)) = nvl(:ctl_globals.business_group_id,-1) and nvl(et.legislation_code,nvl(:ctl_globals.legislation_code,' ')) = nvl(:ctl_globals.legislation_code,' ') and :ctl_globals.session_date between et.effective_start_date and et.effective_end_date and ecl.classification_id = et.classification_id and hl.lookup_type = 'PROCESSING_TYPE' and hl.lookup_code = et.processing_type and ((not exists (select null from pay_ele_classification_rules ecr where ecr.element_set_id = :els.element_set_id and ecr.classification_id = ecl.classification_id) and not exists (select null from pay_element_type_rules etr where etr.element_set_id = :els.element_set_id and etr.element_type_id = et.element_type_id and etr.include_or_exclude = 'I')) or exists (select null from pay_element_type_rules etr2 where etr2.element_set_id = :els.element_set_id and etr2.element_type_id = et.element_type_id and etr2.include_or_exclude = 'E')) and ((:els.element_set_type = 'D' and ecl.distributable_over_flag = 'Y' and exists (select null from hr_lookups hl2, pay_input_values_f iv where iv.element_type_id = et.element_type_id and iv.uom = 'M' and hl2.lookup_type = 'NAME_TRANSLATIONS' and hl2.lookup_code = 'PAY VALUE' and iv.name = 'Pay Value' and :ctl_globals.session_date between iv.effective_start_date and iv.effective_end_date)) or :els.element_set_type in ('R','C','E')) order by ettl.element_name.
ORA-03113: end-of-file on communication channel
Record Group INCLUDE_ELEMENT
Form: PAYWSDRP

FRM-30085: Unable to adjust form for output.

Form not created

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ZA HRMS Manager > Payroll > Element Set
2. When you click on Include Element ====> error is raised

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