E-ES: UNABLE TO DOWNLOAD CURRENT CONFIG FOR SEARCH FRAMEWORK USING ACM IN PT 8.56

(Doc ID 2355271.1)

Last updated on FEBRUARY 20, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, Automated Configuration Manager

Unable to download current config for Search framework using ACM through below navigation

Navigation: PeopleTools > Automated Config Manager > ACM Templates > Template Export/Import
Clicking on SEARCH_TEMPLATE > Download current config


ERROR
-----------------------
SQL error. Function: SQLExec
  Error Position: 7
  Return: 904 - ORA-00904: "PTSF_PROVIDER": invalid identifier
  Statement: select PTSF_PROVIDER,PTSF_SS_URL,PTSF_SS_USER_NAME FROM PS_PTSF_SRCH_ENGN WHERE PTSF_SRCH_ENG_INS = :1
  Original Statement: SELECT PTSF_PROVIDER,PTSF_SS_URL,PTSF_SS_USER_NAME FROM PS_PTSF_SRCH_ENGN WHERE PTSF_SRCH_ENG_INS = :1
=================
SQL error in Exec. (2,280) PTEM_CONFIG.PTSFConfigureSrchInstance.OnExecute Name:getCurrentConfiguration PCPC:46255 Statement:584
Called from:PTACM_TEMPL_WRK.PTACM_CONF_EXPORT.FieldChange Statement:151


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to PT 8.56 HRMS Instance.
2. Navigate to "PeopleTools > Automated Config Manager > ACM Templates > Template Export/Import"
3.Click on 'SEARCH_TEMPLATE > Download current config'

 

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