Hi All,
I have problem with FSCM 9.0 on oracle database.
I have setup PeopleTools successfully and can sign on to website with the version below:
- IBM Webshpere 7
- PeopleTools 8.50
- People FSCM 9.0
- Tuxedo 10R3
- Oracle 11GR1
- I create and import database by manual on user SYSADM, database FSCM
- After configure Domain, websphere, and Configure Management on PeopleTools
- Login to Data Mover, import database People Tools System database, Data Type: SYSTEM to user SYSADM
- Run import successfully and log in to PeopleTool signon ok.
My problem are:
- I can not see FSCM module on the website.
- I import another database PeopleSoft FIN/SCM database, Database Type: Demo but I have problem with import, there are many errors as bellow:
File: Data MoverSQL error. Stmt #: 0 Error Position: 594 Return: 904 - ORA-00904: "SYNCDTTM": invalid identifier
Failed SQL stmt:INSERT INTO PS_COUNTRY_TBL (COUNTRY, DESCR, DESCRSHORT, COUNTRY_2CHAR, EU_MEMBER_STATE, ADDR1_LBL, ADDR1_AVAIL, ADDR2_LBL, ADDR2_AVAIL, ADDR3_LBL, ADDR3_AVAIL, ADDR4_LBL, ADDR4_AVAIL, CITY_LBL, CITY_AVAIL, NUM1_LBL, NUM1_AVAIL, NUM2_LBL, NUM2_AVAIL, HOUSE_TYPE_LBL, HOUSE_TYPE_AVAIL, ADDR_FIELD1_LBL, ADDR_FIELD1_AVAIL, ADDR_FIELD2_LBL, ADDR_FIELD2_AVAIL, ADDR_FIELD3_LBL, ADDR_FIELD3_AVAIL, COUNTY_LBL, COUNTY_AVAIL, STATE_LBL, STATE_AVAIL, POSTAL_LBL, POSTAL_AVAIL, IN_CITY_LIM_AVAIL, IN_CITY_LIM_LBL, GEO_CODE_AVAIL, GEO_CODE_LBL, POST_SRCH_AVAIL, GBSYS_NRPATH_UK, GBSYS_CFGPATH_UK, SYNCID, SYNCDTTM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, TO_TIMESTAMP(:42,'YYYY-MM-DD-HH24.MI.SS.FF'))

File: Data MoverSQL error. Stmt #: 0 Error Position: 586 Return: 904 - ORA-00904: "SYNCID": invalid identifier
Failed SQL stmt:INSERT INTO PS_COUNTRY_TBL (COUNTRY, DESCR, DESCRSHORT, COUNTRY_2CHAR, EU_MEMBER_STATE, ADDR1_LBL, ADDR1_AVAIL, ADDR2_LBL, ADDR2_AVAIL, ADDR3_LBL, ADDR3_AVAIL, ADDR4_LBL, ADDR4_AVAIL, CITY_LBL, CITY_AVAIL, NUM1_LBL, NUM1_AVAIL, NUM2_LBL, NUM2_AVAIL, HOUSE_TYPE_LBL, HOUSE_TYPE_AVAIL, ADDR_FIELD1_LBL, ADDR_FIELD1_AVAIL, ADDR_FIELD2_LBL, ADDR_FIELD2_AVAIL, ADDR_FIELD3_LBL, ADDR_FIELD3_AVAIL, COUNTY_LBL, COUNTY_AVAIL, STATE_LBL, STATE_AVAIL, POSTAL_LBL, POSTAL_AVAIL, IN_CITY_LIM_AVAIL, IN_CITY_LIM_LBL, GEO_CODE_AVAIL, GEO_CODE_LBL, POST_SRCH_AVAIL, GBSYS_NRPATH_UK, GBSYS_CFGPATH_UK, SYNCID, SYNCDTTM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, TO_TIMESTAMP(:42,'YYYY-MM-DD-HH24.MI.SS.FF'))
- How can I fix this error and see FSCM module when I login?
- Why I did not see the user VP1 on the system? (oracle user and table logon of peopletool)
Thanks for your help.
Best regards,

Thanks Nicolas,
I am importing database again.
But I did not understand about import database on Data Mover.
I want to setup for FSCM 9.0.
- If I want to install for FSCM, what is the database I should import? FIN/CSM database, PeopleSoft database system or both for system database type?
- How can I refresh database for FSCM? Drop table or just only truncate table?
- I get the newest PeopleTools 8.50 and FSCM 9.0 on edilivery.oracle.com, I think it should be the newest patch so how can I upgrade PeopleTool?
- When I import FSCM demo database, I did not get these above error, but I have another error:
Failed SQL stmt:INSERT INTO PSMSGCATDEFN (MESSAGE_SET_NBR, MESSAGE_NBR, MESSAGE_TEXT, MSG_SEVERITY, LAST_UPDATE_DTTM, DESCRLONG) VALUES (:1, :2, :3, :4, TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'), :6)
I should alter this table by sql:
alter table PSMSGCATDEFN modified column MESSAGE_TEXT varchar2(200);
and import again, it is by pass this error and still not finish, it run so long.
I am newbie with PeopleSoft so I did not understand about it so much.
Please help me soon.
Thanks again,
Toan Dang

Edited by: user589061 on Nov 3, 2009 2:02 AM

Edited by: user589061 on Nov 3, 2009 2:03 AM

- Sorry about "demo", If I want to import database system for FSCM, what is the database I should import? FIN/CSM database, PeopleSoft database system or both for system database type?
- I install new software, database,.. everything, not upgrade from old version so I think there is no new version to upgrade.
- When importing database is failed or after import PeopleSoft database system, I want to clean up all and import new database for FSCM. How can I refresh database?
Thank you so much, you answer very quickly.
Toan Dang

Let me summary again:
- IBM websphere V7
- Tuxedo 10R3
- PeopleTool 8.50
- FSCM 9.0
- Oracle 11G
I install everything on one server windows 2003 server, Sp2. I download newest version on the website until now.

My question more is:
- If I do not want to use demo database, what database I will import? FIN/CSM database, PeopleSoft database system or both for system database type.
- Can I install PeopleTool 8.49 with FSCM 9.0, Websphere 6.1 and Tuxedo 9.1? If yes, I did not find out Tuxedo 9.1 software to download, Can you send me link to download it?
Because old customer use with this version and want me upgrade to newest version.
Thanks & Best regards,
Toan Dang

Dear Nicolas,
I have problem with importing data by Data Mover, Server is full disk after one day running.
I move data file to other disk and I just want to start importing from the failed point. Can you help me how can I do it? I do not want to re-importing from the begin because I must waiting more one day again.
Thank you,
Toan Dang

Hi,
Can anybody hekp me, am trying to install FSCM 9.0 . After installing all the needed softwares, , the following errors occurs.
1) I cant log into Application designer and data mover.
2) I cannot boot the domain that I create using PSADMIN and when i open the PIA the following error comes out - bea.jolt.ServiceException: Invalid Session.

Also can you show how i can create the peoplesoft databases and also how to run the oracle files ending xxx.ora

Thank you very much