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

  1. srinivas Reddy
    January 2, 2008 at 6:16 am

    Hai Everyone…

    This site/blog is very useful Thnks to all

  2. balaglobal
    January 2, 2008 at 1:49 pm

    Thanks Srinivas,

  3. Dennis Witt
    March 3, 2008 at 2:24 pm

    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.

  4. balaglobal
    March 3, 2008 at 2:41 pm

    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.

  5. ces garcia
    March 28, 2008 at 8:01 pm

    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

  6. balaglobal
    March 28, 2008 at 8:18 pm

    Ces,
    report index page access is related to nVision report. Sorry I don’t know the answer.

  7. May 30, 2008 at 8:29 pm

    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);

  8. ashok kumar
    December 17, 2008 at 9:47 am

    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.

  9. February 8, 2009 at 5:45 am

    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?

  10. balaglobal
    February 8, 2009 at 2:14 pm

    Steve,
    Your blog is very good. I have added it in my Links.

  11. Jay
    May 28, 2010 at 1:30 pm

    Bala,
    Your blog is very useful and thank you for sharing the information.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: