error on field PT_OVRDFROMEMAILID - creates on People Soft an oracle error ORA-01722

Products

• CA Automic Dollar Universe

Issue/Introduction

Customer upgraded their Dollar Universe with an acitve Peoplesoft Manager from 6.8.41 to 6.10.101 and after that  an issue appeared internally on People Soft. On Dollar Universe's side all jobs are running fine.

The affects the job of the type  'Application Engine'.

Each time such a job is submitted the PSoft System logs an Oracle error :

====================================================================================

File: /vob/peopletools/src/pspsm/psmemaildistribute.cppSQL error. Stmt #:

1301  Error Position: 7  Return: 1722 - ORA-01722: invalid number Failed SQL stmt: select r.PT_OVRDFROMEMAILID, r.MAINJOBINSTANCE, o.EMAILID OPREMAIL, p.EMAILID PRCSE MAIL

from PSPRCSQUE r join PSOPRDEFN o on r.OPRID=o.oprid join PS_PRCSDEFN p on p.prcstype=r.prcstype and p.PRCSNAME=r.PRCSNAME and r.PRCSINSTANCE=:1

====================================================================================

 

Environment

Dollar Universe 6.10.101 and Peoplesoft 8.58.05.

 

Cause

This is due to a change on PSoft from Oracle on the usage of PT_OVRDFROMEMAILID structure that was introduce in version 8.5.8

Resolution

Workaround:

If you have updated to DUAS version 6.10.101, the Devbuild of the uxstrpfsoft program that is attached to this article can be downloaded and used. Download it and replace the existing uxstrpsoft.sqr file with this one.

Resolution:

A fix will be come in a near version of DUAS

Additional Information

Related R&D ticket 

Ticket ID: DU_AS-7392
Ticket Title : error on field PT_OVRDFROMEMAILID