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 DECEMBER 30, 2023
Applies to:
Oracle Payroll - Version 11.5.10.2 and laterInformation in this document applies to any platform.
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
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
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 |