My Oracle Support Banner

Effort Reports Are Not Being Generated ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275 ORA-06512: AT "APPS.PSP_XMLGEN", LINE 550 ORA-06502 (Doc ID 2936746.1)

Last updated on JANUARY 23, 2024

Applies to:

Oracle Labor Distribution - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When attempting to run PSP: Create Effort Reports concurrent process, an error occurs and is seen in the log file.

ERROR
-----------------------

Initiator First Page Template Code: null
Generating Initiator XML Wed Jan 11 09:43:59 EST 2023
Error while generating initiator xml content
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "APPS.PSP_XMLGEN", line 550
ORA-06512: at "SYS.DBMS_LOB", line 727
ORA-06512: at "APPS.PSP_XMLGEN", line 388
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at oracle.apps.psp.effortreporting.EffortReportCP.runProgram(EffortReportCP.java:316)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)
EffortReportCP::runProgram() - Exception while generating approver PDF:
java.lang.Exception: Error while initiator XML generation :ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "APPS.PSP_XMLGEN", line 550
ORA-06512: at "SYS.DBMS_LOB", line 727
ORA-06512: at "APPS.PSP_XMLGEN", line 388
ORA-06512: at line 1

at oracle.apps.psp.effortreporting.EffortReportCP.runProgram(EffortReportCP.java:335)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)
java.lang.Exception: Error while generating approver PDF :Error while initiator XML generation :ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "APPS.PSP_XMLGEN", line 550
ORA-06512: at "SYS.DBMS_LOB", line 727
ORA-06512: at "APPS.PSP_XMLGEN", line 388
ORA-06512: at line 1

java.lang.Exception: Error while generating approver PDF :Error while initiator XML generation :ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "APPS.PSP_XMLGEN", line 550
ORA-06512: at "SYS.DBMS_LOB", line 727
ORA-06512: at "APPS.PSP_XMLGEN", line 388
ORA-06512: at line 1

at oracle.apps.psp.effortreporting.EffortReportCP.runProgram(EffortReportCP.java:457)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)
CP main completed runProgram for oracle.apps.psp.effortreporting.EffortReportCP



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Labor Distribution Responsibility

2. Navigate Effort Reporting - Configure and  Run Report - Select Template and enter parameters

3. Submit PSP: Generate Effort Report

  see no report generated and View log files see erro

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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