E-AD: ORA-01483 When Applying Project Via Application Designer Or Package Via Change Assistant.
Last updated on FEBRUARY 02, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
When I try to apply a package via Change Assistant, I receive the following message when there are peoplecodes in the project/package:
Record PeopleCode Application Upgrade Copy started: 2018-01-10-10.27.36
Record PeopleCode Application Upgrade Copy ended: 2018-01-10-10.27.37
Component Record PeopleCode Application Upgrade Copy started: 2018-01-10-10.27.37
File: E:\pt85516b-retail\peopletools\src\pssys\pcmupd.cppErro de SQL. Instrução no.:356Posição de Erro:0Retorno:1483 - ORA-01483: invalid length for DATE or NUMBER bind variable
Failed SQL stmt: INSERT INTO PSPCMPROG (PROGSEQ, VERSION, PROGRUNLOC, NAMECOUNT, PROGLEN, LICENSE_CODE, LASTUPDDTTM, LASTUPDOPRID, PROGFLAGS, PROGEXTENDS, PTTOOLSREL, PROGTXT, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6, OBJECTID7, OBJECTVALUE7) VALUES (:1, :2, :3, :4, :5, :6, TO_TIMESTAMP(:7,'YYYY-MM-DD-HH24.MI.SS.FF'), :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26)
System Error : Component Record PeopleCode
Error - failure during Copy From File process.
If I try to apply the same package via Application Designer, I get the same error message.
The strange part is: this error only occurs occasionally and the error did not occur for the Record PeopleCode, only for the Component Record PeopleCode (but it has happened for Record PeopleCode in the past).
The strangest part of all is: when it happened in the past, I tried applying the same package days later and I was able to apply it successfully.
I have tried cleaning up the Application Designer Cache, tried to use everything set to English (Application Designer language and PeopleSoft Operator also set to English) and the error message keeps popping up.
Can you give me some guidance?
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