Peoplesoft FSCM 9.0

peoplesoft psquery

hi
iam working upgradation 8.8/9.1 PSQUERY .....I HAVE ONE ISSUE IN 8.8 DATA IS COMMING BUT IN 9.1 DATA IS NOT COMING .........IN 8.8 that is date format'YYYY:MM:DD' BUT IN 9.1 SQL USING TIMESTAMP i.e....'YYYY-MM-DD-HH24.MI.SS.FF'.......................my code is like dis
IN 8.8
ROUND((to_date( TO_CHAR(A.SHIP_DATE,'YYYY-MM-DD'),'YYYY-MM-DD')-
to_date( TO_CHAR(C.TS_CUST_REQ_DATE,'YYYY-MM-DD'),'YYYY-MM-DD'))-0.5),
DECODE((SIGN(ROUND((to_date( TO_CHAR(A.SHIP_DATE,'YYYY-MM-DD'),'YYYY-MM-DD')-
to_date( TO_CHAR(A.REQUEST_DATE,'YYYY-MM-DD'),'YYYY-MM-DD'))-0.5))),0,100,-1,100,0),
IN 9.1

ExcelUploadforVoucher in 9.0 FSCM version

Hi ,

Have anyone tried the delivered feature of ExcelUploadforVoucher in 9.0 FSCM version?
When we tried to post the XML, its asking for the userid and password and we could nt able to trace which userid / password that is. We tried the node external userid / password and node default userid and password - none of them are working. Can anyone please throw light on this?

Unanswered Forum Posts