E-DM ORA-00911: invalid character when running Data Mover Replace_View
(Doc ID 1124415.1)
Last updated on AUGUST 11, 2022
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.50 and laterInformation in this document applies to any platform.
Symptoms
Environment:--------------
Datamover 8.50.08
Issue:
-----
While running replace_view <VIEW_NAME> in datamover, the following 'invalid character' error was encountered:
Error:
------
Started: Wed May 12 03:13:20 2010
Data Mover Release: 8.50.08
Database: GHRMS85T (ENG)
Creating View UGG_TEAMCMP_VW
- SQL Error. Error Position: 1111 Return: 911 - ORA-00911: invalid character
CREATE VIEW PS_UGG_TEAMCMP_VW (EMPLID, EMPL_RCD, EFFDT, EFFSEQ, COMP_EFFSEQ, COMP_RATECD, UGG_COMP_RT_DESC, UGG_COMPRATE, UGG_COMP_FREQ) AS SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.COMP_EFFSEQ , A.COMP_RATECD , ( SELECT B.DESCR FROM PS_COMP_RATECD_TBL B WHERE B.COMP_RATECD = A.COMP_RATECD AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_COMP_RATECD_TBL B1 WHERE B1.COMP_RATECD = B.COMP_RATECD AND B.EFFDT <= SYSDATE ) ) "COMP_RATECD_DESCR" , LPAD(TO_CHAR(A.COMPRATE, 'fm999,999,999,990.00') , 45 - LENGTH(TO_CHAR(A.COMPRATE, 'fm999999999990.00'))) || ' ' || TRIM(A.CURRENCY_CD) "COMPRATE" , ( SELECT B.DESCR50 FROM PS_FREQUENCY_TBL B WHERE B.FREQUENCY_ID = A.COMP_FREQUENCY AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_FREQUENCY_TBL B1 WHERE B1.FREQUENCY_ID = B.FREQUENCY_ID AND B.EFFDT <= SYSDATE ) ) "COMP_FREQUENCY" FROM PS_COMPENSATION A WHERE A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD
Error: Unable to process create statement for UGG_TEAMCMP_VW
Ended: Wed May 12 03:13:20 2010
Unsuccessful completion
Steps:
------
The issue can be reproduced with the following steps:
1. Launch Datamover.
2. Run replace_view command for the 3 affected views.
Business Impact:
-----------------
Due to this issue, users cannot run the datamover replace_view command for the 3 affected views, within datamover. This results in business operations inconvenience, as the views have to be build via Application Designer, and the sql statements run via sqlplus.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |