My Oracle Support Banner

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.

Symptoms

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

Error:

HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO [assignment number]
APP-PAY-51118: Error was encountered when processing assignment [ASSIGNMENT]
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME [ELEMENT NAME]
APP-PAY-51119: Error was encountered when processing Element Type [ELEMENT_NAME]
HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME [FORMULA NAME]
APP-PAY-51120: Error was encountered when processing formula [FORMULA_NAME]
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
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


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!


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