Over the years, the number of supported PeopleSoft platforms has declined. In PeopleTools 8.45, it went down from 9 to 6 and in PeopleTools 8.55 it has gone down to just 4, but there are still 9 columns on PSINDEXDEFN that correspond to the original 9 supported platforms.
I explained in a previous blog that you can have all or none of the platform flags set to the same value, but with the platform radio button on the index properties dialogue box is still set to 'some' because one or more of the platform flag columns for some of the unsupported platforms is set differently. Of course, this is a purely cosmetic problem, but one that can cause confusion in Application Designer.
PeopleTools 8.45 | PeopleTools 8.55 |
column RECNAME format a15 column INDEXID format a3 heading 'Idx|ID' column DDLCOUNT format 999 heading 'DDL|Cnt' column CUSTKEYORDER format 9999 heading 'Cust|Key|Order' column KEYCOUNT format 999 heading 'Key|Cnt' column PLATFORM_SBS format 999 heading 'SBS' column PLATFORM_DB2 format 999 heading 'DB2' column PLATFORM_ORA format 999 heading 'ORA' column PLATFORM_INF format 999 heading 'INF' column PLATFORM_DBX format 999 heading 'DBx' column PLATFORM_ALB format 999 heading 'ALB' column PLATFORM_SYB format 999 heading 'SYB' column PLATFORM_MSS format 999 heading 'MSS' column PLATFORM_DB4 format 999 heading 'DB4' column ACTIVEFLAG Format 999 heading 'Active' column CLUSTERFLAG format 999 heading 'Clst|Flg' column UNIQUEFLAG format 999 heading 'Uniq|Flg' column INDEXTYPE format 999 heading 'Idx|Type' column IDXCOMMENTS format a60
spool platformfix855 SELECT * FROM PSINDEXDEFN WHERE PLATFORM_DB2=PLATFORM_DBX AND PLATFORM_DBX=PLATFORM_ORA AND PLATFORM_ORA=PLATFORM_MSS AND (PLATFORM_ORA!=PLATFORM_SBS OR PLATFORM_ORA!=PLATFORM_ALB OR PLATFORM_ORA!=PLATFORM_SYB OR PLATFORM_ORA!=PLATFORM_INF OR PLATFORM_ORA!=PLATFORM_DB4) ;
Cust Idx Idx Uniq Clst Key Key DDL RECNAME ID Type Flg Flg Active Order Cnt Cnt SBS DB2 ORA INF DBx ALB SYB MSS DB4 --------------- --- ---- ---- ---- ------ ----- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- IDXCOMMENTS ------------------------------------------------------------ PSPMTRANSHIST _ 1 1 1 1 0 4 1 1 1 1 1 1 1 1 1 0 …
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN('SYS','RDM'); UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN('SYS','RDM'); UPDATE PSRECDEFN SET VERSION = ( SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'RDM') WHERE RECNAME IN ( SELECT RECNAME FROM PSINDEXDEFN WHERE PLATFORM_DB2=PLATFORM_DBX AND PLATFORM_DBX=PLATFORM_INF AND PLATFORM_INF=PLATFORM_ORA AND PLATFORM_ORA=PLATFORM_SYB AND ( PLATFORM_ORA!=PLATFORM_SBS OR PLATFORM_ORA!=PLATFORM_ALB OR PLATFORM_ORA!=PLATFORM_DB4) ); UPDATE psindexdefn SET PLATFORM_DB4=PLATFORM_ORA WHERE PLATFORM_DB2=PLATFORM_DBX AND PLATFORM_DBX=PLATFORM_INF AND PLATFORM_INF=PLATFORM_ORA AND PLATFORM_ORA=PLATFORM_SYB AND PLATFORM_SYB=PLATFORM_MSS AND PLATFORM_ORA!=PLATFORM_DB4; UPDATE psindexdefn SET PLATFORM_ALB=PLATFORM_ORA WHERE PLATFORM_DB2=PLATFORM_DBX AND PLATFORM_DBX=PLATFORM_INF AND PLATFORM_INF=PLATFORM_ORA AND PLATFORM_ORA=PLATFORM_SYB AND PLATFORM_SYB=PLATFORM_MSS AND PLATFORM_ORA!=PLATFORM_ALB; UPDATE psindexdefn SET PLATFORM_SBS=PLATFORM_ORA WHERE PLATFORM_DB2=PLATFORM_DBX AND PLATFORM_DBX=PLATFORM_INF AND PLATFORM_INF=PLATFORM_ORA AND PLATFORM_ORA=PLATFORM_SYB AND PLATFORM_SYB=PLATFORM_MSS AND PLATFORM_ORA!=PLATFORM_SBS;
The new platformfix855.sql script is available on collection of miscellaneous scripts on Github.
1 comment :
Hello there..Has anyone had any success with implementing Peoplesoft Enterprise in their enviornment?
Post a Comment