About
I started my PeopleSoft career ten year ago, as a developer, worked in Finance, HRMS, Time and Labor Modules, gradually entered the PS admin area. Currently working as Tech Lead. In this blog, I register what I have worked on during my career, so it forms as a reference for my self and share my PeopleSoft experience with others.
-Balakrishna Ningaiah, PMP
Hai Everyone…
This site/blog is very useful Thnks to all
Thanks Srinivas,
E-mail phantom – I’m trouble-shooting a very unusual problem. So far I have come up empty. Please help.
Origin: Process Scheduler Request – Type: Email Format: PDF Distribution: Enter multiple email addressses – They’re deliverd plus an undefined address.
An undefined email address continues to appear in the log and is distributed to this email address. It is probably getting picked up by some table; however, I’m unable to find such a table so far.
Any assitance is greatly appreciated.
Dennis,
the email related to Login Id, could be added by default to the distribution list. When you are in Distribtuion page, under “Distribute To”, by default the user and his ID will be present. The email for this User Id (which is Login ID) will be present in his User Profile (SELECT * FROM PSUSEREMAIL WHERE OPRID = ‘PS’).
Solutions are, you could either delete the User Id under “Distribute To” when you are scheduling, or remove the email from this User’s User profile, or Login as one of the ID you need to distribute the report to.
Hope this helps and let me know if you need additional help.
Thanks,
Bala.
Hi Bala,
Hope you could help me. I’m trying to understand about report index and Report Distribution List. The Security Admin told me that this certain role has a dual purpose, it is a report distribution and granting report index access. This part i dont understand, how do u do the report distribution and report index access?
Hope you would reply real quick.
Thanks,
Ces
Ces,
report index page access is related to nVision report. Sorry I don’t know the answer.
Folks
I am trying to call a User Defined Function from PeopleSoft. Do you have any idea how to do this?
johnchemers at hot*mail
T-SQL in a PeopleCode / SQLExec
I have successfully created a user defined function…. It is
giving me my anticipated output when run in database. But the
same thing when run in PeopleSoft/SQLExec, I get an error:
CREATE FUNCTION people.UDFENCRYPT (@clearText varchar(8000))
RETURNS varchar(8000) AS
BEGIN
DECLARE @cryptor int
DECLARE @encryptedText varchar(8000)
IF @clearText IS NOT NULL
BEGIN
IF (RIGHT(RTRIM(@clearText), 2) != ‘==’)
BEGIN
EXEC sp_OACreate ‘Cryptor.Crypt’, @cryptor OUTPUT
EXEC sp_OAMethod @cryptor, ‘Encrypt’, @encryptedText OUTPUT, @plainText=@clearText
EXEC sp_OADestroy @cryptor
IF (@encryptedText = ” OR @encryptedText IS NULL)
BEGIN
SET @encryptedText = ”
END
RETURN @encryptedText
END
RETURN @clearText
END
RETURN NULL
END
——————————–
SQLExec(“select dbo.UDFENCRYPT(‘JOHN’) CC from PS_H_ENCRYPT_VW”, &MY_ENCRYPT_CC);
Hi Bala,
Do u have any idea about how to use the session on integeration broker communication with third party .I need to send a msg syn communication between the sys.how can i moniter and manage the sessions while using the xml messages using post method transactions.
Hi Bala,
I see you cover SQR in your blog. I’ve just started a blog at http://www.peoplesoftsqr.com. I hope you’ll visit me. Would you like to exchange links?
Steve,
Your blog is very good. I have added it in my Links.