Danish E-Income Tax Card Requisition error: invalid LOB locator specified: ORA-22275 (Doc ID 1677032.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (Denmark) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Denmark Payroll

When attempting to run Danish E-Income Tax Card Requisition
the following error occurs.

ERROR
-----------------------
PYDKTCR module: Danish E-Income Tax Card Requisition
+---------------------------------------------------------------------------+

Current system time is 02-APR-2014 06:38:49

+---------------------------------------------------------------------------+

Setting system temp directory to : /pnoi1i/applcsf/tmp
***** Inside runProgram *****
Param Test Debug value
Program Name is NULL checking for PLSQL package name !!!
Old encoding=UTF-8
SELECT tag charset FROM fnd_lookup_values WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP' AND lookup_code = SUBSTR(USERENV('LANGUAGE'), INSTR(USERENV('LANGUAGE'), '.') + 1) AND language = 'US'
New encoding=UTF-8
BEGIN PAY_XML_GEN_PKG.EXEC_REPORT_MAP_FUNCTION ( :1, :2, :3, :4 ); END;
Problem:java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 710
ORA-06512: at "APPS.PAY_XML_GEN_PKG", line 67
ORA-06512: at line 1

Exception inside runProgramjava.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 710
ORA-06512: at "APPS.PAY_XML_GEN_PKG", line 67
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. submit Danish E-Income Tax Card Requisition



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