hfjf (guest) 1268231177|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Instantiating an Excel Object from Peoplesoft page
Recent Forum Posts
hfjf (guest) 1268231177|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Instantiating an Excel Object from Peoplesoft page
Steve (guest) 1268146278|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Duplicate Invoice Checking
Can duplicate invoice checking be configured to reject one criteria (Duplicate invoice numbers) and warn on another criteria, same vendor and dollar amount. v 8.9
Anisha (guest) 1268073675|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Instantiating an Excel Object from Peoplesoft page
Hello Susan,
Are you still having the same error "Invalid parameter: CreateObject Excel.Application invalid class string for function ObjectGetProperty." ? What have you done to correct this error?
I am actually facing the same error when using the following code in my AE peoplecode:
Local object &oWorkApp,&oWorkBook;
&oWorkApp = CreateObject("COM", "Excel.Application");
&oWorkBook = ObjectGetProperty(&oWorkApp, "Workbooks");
Thank you for your help.
Re: Instantiating an Excel Object from Peoplesoft page by Anisha (guest), 1268073675|%e %b %Y, %H:%M %Z|agohover
Anisha (guest), 1268073675|%e %b %Y, %H:%M %Z|agohover
Praj 1267735569|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » display bold letters in mail using app pacakge PT_WF_NOTIFICATION
Can you try adding the line:
&mynotification.AddHeader("Content-Type", "text/html");
Before the line:
&mynotification.ContentType = "text/html; charset=UTF-8";
Also what email program are you testing this in ?
Re: display bold letters in mail using app pacakge PT_WF_NOTIFICATION by Praj, 1267735569|%e %b %Y, %H:%M %Z|agohover
Praj, 1267735569|%e %b %Y, %H:%M %Z|agohover
Guest (guest) 1267707996|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » display bold letters in mail using app pacakge PT_WF_NOTIFICATION
Below is the code.I have created a notification template and then used html tags but still unable to get the text in bold.The html tags are visible.Any idea how to avoid display of html tags?
Local PT_WF_NOTIFICATION:NotificationTemplate &ETemplate; &Msg1 = MsgGetExplainText(30000, 5, "some text"); &Msg2 = "Descr: <html><body><b>" | &Err_Msg | "</b></body></html>"; &Msg = &Msg1 | &Msg2; &ETemplate = create PT_WF_NOTIFICATION:NotificationTemplate("", "", "Example", "G"); &aryValues = CreateArrayRept("", 0); &aryValues.Push(&Msg); &xmlVars = &ETemplate.SetupGenericVars(&aryValues); &Temp = &ETemplate.GetAndExpandTemplate(%Language, &xmlVars); &mynotification.Message = &ETemplate.Text; &mynotification.ContentType = "text/html; charset=UTF-8"; &mynotification.Send();
Thanks,
Re: display bold letters in mail using app pacakge PT_WF_NOTIFICATION by Guest (guest), 1267707996|%e %b %Y, %H:%M %Z|agohover
Guest (guest), 1267707996|%e %b %Y, %H:%M %Z|agohover
Praj 1267691391|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » display bold letters in mail using app pacakge PT_WF_NOTIFICATION
Just to confirm:
- Are you adding a header with the content type of "text/html"
&oEmail.AddHeader("Content-Type", "text/html");
- Sounds like you are setting your ContentType property to "text/html"
- Are you wrapping your email message text with the tags: <html><body> … </body></html>?
Re: display bold letters in mail using app pacakge PT_WF_NOTIFICATION by Praj, 1267691391|%e %b %Y, %H:%M %Z|agohover
Praj, 1267691391|%e %b %Y, %H:%M %Z|agohover
Praj 1267403196|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Is it possible to select a random of EmplID's from a Query
Hi Gilbert,
Thanks for your question, I've actually created an article that shows the SQL required to do this in either SQL Server or Oracle. This is available in the following article:
What you'll need to do in PS Query is create a sub-query that produces the SQL shown above for your database platform. If you are on SQL server this will be fairly straightforward.
If you are on Oracle, this will be a lot harder. I tried messing around with it for a bit but the catch is making it order by dbms_random.value in a sub-query, which isn't possible as you can only have one field in a sub-query and you can only order by that field.
The way to make this work in Oracle is to create a view with the logic that generates the random EMPLIDs. The SQL in this view will be:
SELECT EMPLID FROM ( SELECT EMPLID FROM PS_PERSON ORDER BY dbms_random.value )
And you will need to save it as a record and add it to the query tree so you can see it through query manager. Join to this view in your existing query, and then add one more expression: rownum and add that expression to your criteria equal to a constant (which will = 450).
Good luck with this and please post any more questions.
Re: Is it possible to select a random of EmplID's from a Query by Praj, 1267403196|%e %b %Y, %H:%M %Z|agohover
Praj, 1267403196|%e %b %Y, %H:%M %Z|agohover
Gilbert Solorio (guest) 1267214660|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Is it possible to select a random of EmplID's from a Query
I will need to create a query that would select 450 random ID's from PS Query. Does PS Query allow me to create such an expression? Or another way of achieving this?
Thanks!
Is it possible to select a random of EmplID's from a Query by Gilbert Solorio (guest), 1267214660|%e %b %Y, %H:%M %Z|agohover
Gilbert Solorio (guest), 1267214660|%e %b %Y, %H:%M %Z|agohover
SriLakshmi (guest) 1267190162|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » display bold letters in mail using app pacakge PT_WF_NOTIFICATION
I am using PT_WF_NOTIFICATION app package to send mails.
The body of mail is displayed using message catalog.
I have used ¬ification.ContentType = "text/html; charset=UTF-8";
I tried splitting the message in message catalog.
For the Part of text to be displayed in bold,i am using HTML tags and then concatinating with remaining message from message catalog.
Thanks in advance.
display bold letters in mail using app package PT_WF_NOTIFICATION by SriLakshmi (guest), 1267190162|%e %b %Y, %H:%M %Z|agohover
SriLakshmi (guest), 1267190162|%e %b %Y, %H:%M %Z|agohover
Praj 1267138613|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » How to get Latest Effective Record (Effective Date is not an option)
Hi,
You'll need to add a criteria in your main query for C.RUNDTTM with a condition type of equal to a subquery. Your subquery should be on the same table that C.RUNDTTM comes from with one field; RUNDTTM and the max aggregate function applied. Your subquery should also join on other key fields if appropriate.
So you should end up with SQL that looks like this (in the View SQL tab)
and C.RUNDTTM = (SELECT MAX(D.RUNDTTM) FROM YOUR_TABLE D WHERE D.KEY1 = C.KEY1 ... etc)
Re: How to get Latest Effective Record (Effective Date is not an option) by Praj, 1267138613|%e %b %Y, %H:%M %Z|agohover
Praj, 1267138613|%e %b %Y, %H:%M %Z|agohover
Praj 1267138129|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Existing Content » Component Interface based Web Services
Try navigating to PeopleTools > Integration Broker > Configuration > Service Configuration
Check that the service name space has been set (e.g. http://xmlns.oracle.com/Enterprise/Tools/services).
Also make sure that the target location has been configured properly.
kitchensink 1267107402|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Existing Content » Component Interface based Web Services
Hi,
When I am select on 'display selected actions', I am getting an error of 'Service Configuration information has not been defined'. Has anyone else received this error?
Anon (guest) 1266927074|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Existing Content » Campus Solutions Tables
This looks rather handy!
Great, glad I could help and thanks for your feedback on the wiki.
Tina (guest) 1266888536|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Delivered CI Security
Praj,
I finally found the solution. The WEBLIB_SOAPTOCI Web Library also has to be added to the ZZ_AM_ADDITIONAL_CONFIG permission list.
It's now working.
Thanks for your help. This is my first experience with PeopleSoftWiki.com I found it extremely helpful - as well as your own personal wiki! They are now both on my favorites list.
Thanks,
Tina
Thanks Tina.
In your connect information in ExcelToCI, what is the node you are using?
If you navigate to:
PeopleTools > Integration Broker > Integration Setup > Nodes and open that node up (e.g. PT_LOCAL) can you confirm that this is the local node? (local node check box is checked)
The other thing it could be is that web library security to WEBLIB_SOAPTOCI. You can use the view, PSAUTHWEBLIBVW to see which permission lists have access to this web library with the following SQL:
select distinct CLASSID from PSAUTHWEBLIBVW where MENUNAME = 'WEBLIB_SOAPTOCI';
If your user doesn't have access to any of these permission lists then the error will occur. You can either give the user access to one of these permission lists (e.g. PTPT1200), however if you want to lock security down, then find a permission list that the user already has, then navigate to:
PeopleTools > Security > Permissions & Roles
Open the permission list you want to use, then go to the web libaries tab, add WEBLIB_SOAPTOCI, press Edit, and confirm they have full access to all functions.
Tina (guest) 1266881523|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Delivered CI Security
Praj,
From the Excel CI tool I get the following error messages after pressing the Submit Data button:
"The response text is not valid XML. Login data cleared"
If I run it again and enter my UserID/Password (a clone of VP1) I do not receive the error and my data is uploaded successfully.
Thanks,
Tina
Hi Tina,
Could you please post the error you get for the user when they try to use the CI / what they are trying to do?
Tina (guest) 1266876341|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Delivered CI Security
Praj,
Thank you for your response. I have run both SQL's and got the following results.
My permission list contains full access to this CI:
CLASSID BCNAME BCMETHOD AUTHORIZEDACTIONS
ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Cancel 4
ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Create 4
ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Find 4
ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Get 4
ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Save 4
And my user (PAP3396) has security to this permission list:
OPRID OPRCLASS CLASSID BCNAME BCMETHOD AUTHROIZEDACTIONS
PAP3396 ZZ_AM_ADDITIONAL_CONFIG ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Cancel 4
PAP3396 ZZ_AM_ADDITIONAL_CONFIG ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Create 4
PAP3396 ZZ_AM_ADDITIONAL_CONFIG ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Find 4
PAP3396 ZZ_AM_ADDITIONAL_CONFIG ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Get 4
PAP3396 ZZ_AM_ADDITIONAL_CONFIG ZZ_AM_ADDITIONAL_CONFIG INTFC_FINPHY_SS_A Save 4
Any other ideas?
Thanks,
Tina
It could be the automatic effective date join that's causing the issue? Have tried taking that out of query to see if you get any results?
