Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Human Resources and ELM - PSFT (MOSC)

PUM 40 UPD33250624_01_DMS FAILS on MS SQL DB SQL TO_DATE is not a recognized built-in function name.

Nov 16, 2021 3:32PM edited Mar 30, 2022 1:45PM in Human Resources and ELM - PSFT (MOSC) 1 commentAnswered

if you install NATIVE OS windows and run PUM 40 change control, you might get this error on the DMS Script.

PUM 40 UPD33250624_01_DMS FAILS on MS SQL DB SQL TO_DATE is not a recognized built-in function name.

this fails when using MSSQL PUM 40 change control.

a bug has been posted

Bug 33523206 : PUM 40 UPD33250624_01_DMS FAILS ON MS SQL TO_DATE IS NOT A RECOGNIZED BUILT-IN

to keep moving on PUM 40 to get what you need i figured out the fix myself. waiting for PUM 41 as stated is too late

here is my workaround that was successful.

Update PS_HR_SSTEXT_TEXT SET EFFDT = '1900-01-01 00:00:00.000' WHERE TEXT_ID='BENEFIT_SUMMARY_TP' AND EFFDT = '2020-05-15'

Tagged:

peopletools

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month