Phone Type Prompt Does Not Work With Customized View In Template Based Hire (Doc ID 1585050.1)

Last updated on JUNE 15, 2017

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


Phone type prompt does not work with customized view in Template Based Hire

Steps to Replicate:
============

Navigate to Set Up HRMS > Product Related > Workforce Administration > Template-Based Hire > Template Section
Choose PHONE_NUMBER_01
Under Section Fields > Field PHONE_TYPE > click on Field Configuration
In DEMO, Prompt Table points to PSXLATITEM and Prompt Field points to XLATLONGNAME.

The users did not want phone type BUSN to show in the template, therefore a view was created which excluded BUSN phone type. Even after the change, BUSN phone type still appears in template base hire.

Create SQL view
 

 SELECT A.FIELDNAME
 , A.FIELDVALUE
 ,A.EFFDT
 ,A.XLATLONGNAME
  FROM PSXLATITEM A
 WHERE A.FIELDNAME ='PHONE_TYPE'
   AND A.EFFDT= (
 SELECT MAX(A1.EFFDT)
  FROM PSXLATITEM A1
 WHERE A1.FIELDNAME = A.FIELDNAME
   AND A1.FIELDVALUE = A.FIELDVALUE
   AND A1.EFFDT < %CurrentDateIn)
   AND A.EFF_STATUS ='A'
   AND A.FIELDVALUE NOT IN ('BUSN')


and change the prompt value to SQL view

 

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