Online Payslip Causes Database Alert Log To Fill With WARNING: Too Many Parse Errors (Doc ID 2750165.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

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


ERROR
-----------------------
2020-11-03T15:47:12.879959+02:00
EBS_I3(3):WARNING: too many parse errors, count=400 SQL hash=0x27b22696
EBS_I3(3):PARSE ERROR: ospid=69624, error=6550 for statement:
2020-11-03T15:47:12.880110+02:00
EBS_I3(3):BEGIN (2781579113, 'EMEA ELEMENT DEFINITION', 'PAYSLIP'); END;
EBS_I3(3):Additional information: hd=0xcfb33600 phd=0xd789d2c0 flg=0x28 cisid=118 sid=118 ciuid=118 uid=118 sqlid=5n9pbr0mv49nq
EBS_I3(3):...Current username=APPS
EBS_I3(3):...Application: e:PER:fwk:per.selfservice.common.server.CommonAM Action: PER/EMPLOYEE_DIRECT_ACCESS_V4.0
2020-11-03T15:47:12.880398+02:00
EBS_I3(3):----- PL/SQL Call Stack -----
  object line object
  handle number name
0xeb2475f0 1 anonymous block
0xe3593630 1721 package body SYS.DBMS_SQL.EXECUTE
0xb3b23a30 1339 package body APPS.PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE_INTERNAL
0xb3b23a30 1399 package body APPS.PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE
0xebe3a9a8 1 anonymous block


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

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

Changes

 Database has been upgraded to 19c

Cause

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