Payroll Errors After Patch R12.HR_PF.C.delta.12 or Patch R12.HR_PF.B.delta.11: 'ORA-34 occurred at line [number] of formula [FORMULA_NAME]'
(Doc ID 2416140.1)
Last updated on SEPTEMBER 07, 2018
Applies to:Oracle Payroll - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.
Oracle payroll errored for the assignments who have earning elements with fast formula having a call to function which has call to PRAGMA AUTONOMOUS_TRANSACTION.
The same error will come for functions that call the seeded API PAY_ELEMENT_ENTRY_API
ASGNO [assignment number]
APP-PAY-51118: Error was encountered when processing assignment [ASSIGNMENT]
ETNAME [ELEMENT NAME]
APP-PAY-51119: Error was encountered when processing Element Type [ELEMENT_NAME]
FMLANAME [FORMULA NAME]
APP-PAY-51120: Error was encountered when processing formula [FORMULA_NAME]
FORMULA_ERROR_TEXT ORA-34 occurred at line 283 of formula [FORMULA_NAME]
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Create a Fast Formula with a call to PRAGMA AUTONOMOUS_TRANSACTION or API PAY_ELEMENT_ENTRY_API
2. Attach the FF to a Payroll element
3. Attach the element to employee
4. Run Payroll
5. Observe errors
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!