After 19C Upgrade, Online Payslip Causes Database Alert Log To Fill With Warning: Too Many Parse Errors (Doc ID 2741744.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

On : 12.1 HRMS RUP13 version, Core Payroll - General

When attempting to view the Online Payslip in Self Service,
the following error occurs in the Database alert log


ERROR
-----------------------
2020-12-22T07:16:11.977786-05:00
FNFFIN(4):WARNING: too many parse errors, count=100 SQL hash=0x18aba8ed
FNFFIN(4):PARSE ERROR: ospid=86037, error=6550 for statement:
2020-12-22T07:16:11.991464-05:00
FNFFIN(4):BEGIN (1570423709, 'IN_PT_PAY', 'PAYSLIP'); END;
FNFFIN(4):Additional information: hd=0xbae04220 phd=0xbcbf7ec8 flg=0x28 cisid=83 sid=83 ciuid=83 uid=83 sqlid=buxhghncara7d
FNFFIN(4):...Current username=APPS
FNFFIN(4):...Application: e:PER:fwk:per.selfservice.common.......  Action: PER/FNFIN_ESS
2020-12-22T07:16:12.025823-05:00
FNFFIN(4):----- PL/SQL Call Stack -----
  object line object
  handle number name
0xc7227410 1 anonymous block
0xc7c5d110 1721 package body SYS.DBMS_SQL.EXECUTE
0xd3474ed8 1340 package body APPS.PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE_INTERNAL
0xd3474ed8 1400 package body APPS.PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE
0x6adf37f8 1 anonymous block
FNFFIN(4):WARNING: too many parse errors, count=200 SQL hash=0x18aba8ed
FNFFIN(4):PARSE ERROR: ospid=86037, error=6550 for statement:
2020-12-22T07:16:12.671044-05:00
FNFFIN(4):BEGIN (1570423709, 'IN_PT_PAY', 'PAYSLIP'); END;
FNFFIN(4):Additional information: hd=0xbae04220 phd=0xbcbf7ec8 flg=0x28 cisid=83 sid=83 ciuid=83 uid=83

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Uses access their online Payslip through Self Service
2. Observe the errors in the Database  alert log

WHAT HAS CHANGED
---------------------------------
Database  has been upgraded to 19c

Changes

Cause

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