My Oracle Support Banner

9.2: When Running EODP_QRY_REF Generate Query References SQL error in Exec. (2,280) EODP_QRY_REF.QRYREF.GBL.default.1900-01-01.Step02.OnExecute Error Occurs In Log File, But Runs Success (Doc ID 2820721.1)

Last updated on NOVEMBER 10, 2021

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running application engine program EODP_QRY_REF Generate Query References, the following error occurs:

SQL error. Function: SQLExec

Error Position: 0

Return: 8601 - [CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999

Statement: SELECT 'X' FROM PS_EODP_RECFIELD WHERE RECNAME=:1 AND FIELDNAME=:2 FETCH FIRST 1 ROWS ONLY

Original Statement: SELECT 'X' from PS_EODP_RECFIELD where RECNAME=:1 and FIELDNAME=:2
2019-10-09-09.54.22.950405 GetNextStateRecord [68] Exception logged: RC=3.

SQL error. Function: SQLExec

Error Position: 0

Return: 8601 - [CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999

Statement: SELECT 'X' FROM PS_EODP_RECFIELD WHERE RECNAME=:1 AND FIELDNAME=:2 FETCH FIRST 1 ROWS ONLY

Original Statement: SELECT 'X' from PS_EODP_RECFIELD where RECNAME=:1 and FIELDNAME=:2

SQL error in Exec. (2,280) EODP_QRY_REF.QRYREF.GBL.default.1900-01-01.Step02.OnExecute PCPC:2695 Statement:45

BI_LINE--GROSS_EXTENDED_BSE-

SQL error in Exec. (2,280) EODP_QRY_REF.QRYREF.GBL.default.1900-01-01.Step02.OnExecute PCPC:2695 Statement:45


Replication steps:
1) Navigate to Enterprise Components / Data Privacy Framework / Maintain Data Privacy Settings;
2) Click on button Manage References, Update References, Done.


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
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.