Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Pragmatically edit Peoplecode

3599071Feb 27 2018 — edited Feb 28 2018

Hi, I have one requirement in my business that has event mapping to be configured for the components. In 8.55 event mapping there is a bug where the event mapping applied for the prebuild component level would not get triggered for the component with search record. The component without search record works as expected. The only problem is with those components with search record. In order to resolve the issue we simply would write a line of code in components Prebuild event to make the event mapping work. But we are trying to create a custom logic to make this work.

My question here is, can we check if the components prebuild code is blank? I know we can search it in a record(PSPCMPROG). But after checking if the code is present or not in the event, I need to add a line of code in the component's event through my custom peoplecode. Can someone tell me if its doable in peoplecode?

Comments

in oracle 11g , the passwords are case sensitive , so check once again in toad and try to connect with the smaller case as you used in cmd prompt
138180
It seems to me you may have an old TOAD version. TOAD prior to 9.5 is capitalizing password strings before sending them to the database and therefore is unable to connect to Oracle 11g unless passwords in your database are capitalized as well or Oracle 11g context sensitive password feature is turned off.

Dusan
621707
I am aware about the case sensitivity in oracle 11g.

So i used to copy same password which i use on SQL prompt.

And regarding toad version i can login with other user only i face error for test user.
584650
Don't type your password in TOAD when you try to connect and let it popup a dialog box for your password. Type the password in there and it will work. Not sure what they've done in TOAD with passwords but that is a workaround. It has to do with case sensitive passwords in 11g. I think if you change the password to all upper case it will work with TOAD.

The parameter for this is SEC_CASE_SENSITIVE_LOGON http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams.htm#insertedID211

The next problem you'll probably have in 11g is accounts expiring, because they've set a default password expiry time of accounts to 180 days:
DEFAULT                PASSWORD_LIFE_TIME      PASSWORD 180
DEFAULT                PASSWORD_GRACE_TIME     PASSWORD 7
It's bound to make some applications stop working out there and catch people out.
720731
This was perfect! I cannot belive my first hit when i googled this issue was your post. I had 4 dba members stumped on why toad was not working right
CKPT
hi,

the toad is in server machine, or different?

in case if different machine, make sure of tns entry.

can you post error message

Thanks.
mseberg
alter system set sec_case_sensitive_logon=False scope=spfile;

Bounce.

We have user still using Toad 8 with oracle 11
811024
Thank you, Thank you, Thank you!

I've been wrestling with this bit of rubbish off and on for over a MONTH! I flipped over to SQL Developer when I really needed a GUI into the database, but the experience was, uh, "not the same."
866510
This was awesome, I never post anything on any of the forums. Doing it for the first time for this brilliant answer/solution. This really works....!!!!
User_NABCB
This workaround works. TOAD 9 version is converting passwords into uppercase and with 11g, it gives username/password invalid error.
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 28 2018
Added on Feb 27 2018
#peoplesoft-general-discussion
5 comments
530 views