R12.2.6: Oracle Fast Formula Errored Out After Patch R12.HR_PF.C.delta.12: R12.HR_PF.C.delta.12

(Doc ID 2416140.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Payroll - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Problem Description:

Oracle payroll errored for the assignments who has earning elements with fast formula
having a call to function which has call to PRAGMA AUTONOMOUS_TRANSACTION; to enable the debug messages


HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 6013
APP-PAY-51118: Error was encountered when processing assignment 6013
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME PBSO FT2
APP-PAY-51119: Error was encountered when processing Element Type PBSO FT2
HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME PBSO_FT2_PCT_EARN_RWSI
APP-PAY-51120: Error was encountered when processing formula PBSO_FT2_PCT_EARN_RWSI
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT ORA-34 occurred at line 283 of formula PBSO_FT2_PCT_EARN_RWSI





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 in it
2. Attach the FF to a Payroll element
3. Attach the element to employee
4. Run Payroll
5. Observe errors


Changes

 

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