My Oracle Support Banner

PSFT_GENFEED Error When Run Search Definition: EP_CS_CWB_CONTRACT (Doc ID 2558298.1)

Last updated on MAY 20, 2021

Applies to:

PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PSFT_GENFEED Error when run search definition: EP_CS_CWB_CONTRACT 


ERROR
"File: /vob/peopletools/src/pssys/qpm.cppSQL error. Stmt #: 7966 Error Position: 3421 Return: 1830 - ORA-01830: date format picture ends before converting entire input string
Failed SQL stmt: SELECT A.CS_DOC_ID, A.SETID, A.CNTRCT_ID, A.VERSION_NBR, A.CS_CONTENT_ID, A.DESCR60, A.CS_DOC_STATUS, A.CS_DOCUMENT_TYPE, A.CS_DOC_OWNER, A.CS_SPONSOR, A.DEPTID, A.CS_SETID, A.CS_TMPL_TYPE, A.CS_TEMPLATE_ID, A.CS_TEMPLATE_AMEND, A.CS_VERSION, A.CS_AMENDMENT, A.CS_SOURCE_TRANS, A.CLOSE_FLAG, A.HOLD_FLAG, TO_CHAR(A.CNTRCT_BEGIN_DT,'YYYY-MM-DD'), TO_CHAR(A.CNTRCT_EXPIRE_DT,'YYYY-MM-DD'), TO_CHAR(A.APPROVAL_DT,'YYYY-MM-DD'), TO_CHAR(A.RENEWAL_DATE,'YYYY-MM-DD'), TO_CHAR(CAST((A.CREATED_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), A.CREATED_BY_USER, TO_CHAR(CAST((A.LAST_MODIFIED_DATE) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), A.LASTUPDOPRID, A.CS_IMPORT_CODE, TO_CHAR(A.CS_DOC_DUE_DATE,'YYYY-MM-DD'), TO_CHAR(A.CS_DOC_START_DATE,'YYYY-MM-DD'), TO_CHAR(A.CS_DOC_STATUS_DATE,'YYYY-MM-DD'), A.VENDOR_SETID, A.VENDOR_ID, A.VENDOR_NAME_SHORT, A.CNTRCT_STATUS, A.CNTRCT_PROC_OPT, A.VNDR_CNTRCT_REF, A.DESCR, A.MSTR_CNTRCT_ID, A.BUYER_ID, 'psp/EMPLOYEE/ERP/c/CONTRACT_MGMT.CNTRCT_ENTRY.GBL?Page=CNTRCT_HDR&Action=U&CNTRCT_ID=%A.CNTRCT_ID%&SETID=%A.SETID%&VERSION_NBR=%A.VERSION_NBR%', A.SES_YEAR, A.SES_DAY, A.SES_MONTH, A.VERSION_STATUS, TO_CHAR(CAST((A.SES_LAST_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), A.CS_CWB_TRANS_SES, A.CS_DOC_AVAILABLE, B.CS_CLSTYP_DESC, C.DESCR, D52X.XLATLONGNAME, E53X.XLATLONGNAME, F54X.XLATLONGNAME, A.CNTRCT_STYLE, A.CNTRCT_STYLE_NAME, A.CONTROL_TYPE, CASE WHEN NVL(A.SES_DAY,'No Value') = ' ' THEN 'No Value' ELSE NVL(A.SES_DAY,'No Value') END , CASE WHEN NVL(A.SES_MONTH,'No Value') = ' ' THEN 'No Value' ELSE NVL(A.SES_MONTH,'No Value') END , CASE WHEN NVL(A.SES_YEAR,'No Value') = ' ' THEN 'No Value' ELSE NVL(A.SES_YEAR,'No Value') END , CASE WHEN NVL(A.VENDOR_NAME_SHORT,'No Value') = ' ' THEN 'No Value' ELSE NVL(A.VENDOR_NAME_SHORT,'No Value') END "



STEPS
The issue can be reproduced at will with the following steps:
1. Run Build Search Index for search Definition: EP_CS_CWB_CONTRACT.
(PeopleTools > Search Framework > Administration > Schedule Search Index)



Changes

 TBD

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.