Why PeopleSoft roles can not be compared using Compare & Report option available in Applicaiton Designer when permission lists can be?

– Ramesh

Thanks for posting your question!

Roles are not static PeopleTools objects like Permission lists. For E.g. Roles can be dynamically created and maintained through PS Query, PeopleCode and also at LDAP server. Hence PeopleSoft is not considering the roles as comparable PeopleTools objects between the environments. PeopleSoft provides a number of vanilla PS queries on Role definitions & User profiles for the Users to verify the role and User profile information in the following navigation:

Root > PeopleTools > Security > Common Queries

To further add to your question, Roles cannot be exported in to a file also. But PeopleSoft considers that as a bug in PeopleTools 8.4x and plan to provide fix in the next tools release.

Thanks,

Vijayakumar Janagiraman

I am running some PL/SQL in an app engine to generate web page files. I’m having great difficulty with the slashes (/). The first line of the file is the typical %execute(/) that lets a series of commands run in one section. But every time I have a slash, even in a quoted string, it ends input and complains of a syntax error, e.g. …href =’htt p://…’ (spaces put in so it doesn’t look like html to your form). If I try another character in the %execute() directive, I get an error about illegal character “at or about position 10” which is exactly the spot where I have tried something other than a slash. I got around the problem in a very ugly way by substituting “chr(47)” with appropriate concatenates for each slash, but there are many of them in the code, and now it is both unreadable and unmaintainable. Any help on changing the character from slash to something else or escaping the slashes in the strings would be greatly appreciated.

– Jim

Thanks for posting your question!

%Execute() function supports only two parameters ‘/’ or ‘;’

You might want to try to reverse the slash on the HTTP text you are generating because HTTP works with both forward and backward slash. Example http://blogs.hexaware.com and http:\\blogs.hexaware.com are both valid.

You can consider using the REPLACE function as below.

%Execute(/)

DECLARE

V_TEMP VARCHAR2(100);

BEGIN

SELECT REPLACE(‘HTTP:??www.abc123.com?index.htm’ ,’?’ ,chr(47)) INTO V_TEMP

FROM DUAL;

INSERT INTO test (a)

VALUES(v_temp);

END;

/

Posted by Nitin Pai
Comments (1)
July 24th, 2008

Comments (1)

nataraj.cheedella - July 25th, 2008

Hi, Iam facing with database error like conflicting with existing data. In which scenarios this error will be coming. Please explain. Thanks, Nataraj.ch

Comments are closed.