File Parser - Couple Of facts To Be Aware Of

I am a big fan of the File Parser Process. However, there are couple of gray areas where the File Parser can degrade the performance when combined with the Common Attribute Framework (CAF). 

If we make the right decision based on these two main facts, File Parser can expedite the entire data load process with greater efficiency.

Configurable User Profile Synchronization

Started off with the traditional USER_PROFILE sync and the user profiles on the target instance got corrupted. 

Because of two main reasons. Custom Symbolic ID and Primary Permission List on the target instance. It would have been a customization before 8.5X, to exclude the unwanted fields, but not anymore. 

The USER_PROFILE_XFR, an enhanced/configurable USER_PROFILE message, is a stand-alone message and can be used instead of USER_PROFILE message depending on the requirement of what needs to be synchronized between databases.

You can control the fields to send to the target database by checking/un-checking the fields in the message.

When you view the XFR message for the first time, you might notice that some of the fields are already unchecked. 

As per Peoplebooks, below are the ones which are excluded in the message by default. 

PSOPRDEFN.OPRCLASS

PSOPRDEFN.ROWSECCLASS

PSOPRDEFN.SYMBOLICID

PSOPRDEFN.PRCSPRFLCLS

PSOPRDEFN.DEFAULTNAVHP

Note from Oracle: The USER_PROFILE_XFR message should not be used for messaging between a PT 8.4x to PT 8.5x environment.  This is only when the publishing and subscribing database is on PT 8.5x.

Have a great day!

8.54 Fluid UI - Quick Reads & Thoughts

Enabling the Reset Password Feature in Oracle SQL Developer

It happens. We forget our password and it becomes a headache all of a sudden. Here is one way to reset the password from Oracle SQL Developer.

You might have noticed the 'Reset Password' option, when you right click on any connection. It might be grayed out if you do not have the Oracle Client installed. Here's how you can enable that option by installing the client.

Download the Oracle Client from http://www.oracle.com/technetwork/topics/winsoft-085727.html

UnZip the same and place it at your convenient location. You need the location to map the client later in the setup.

Add the above path to the Environment Variable

Go to Tools > Preferences > Database > Advanced and check 'Use Oracle Client' & 'Use OCE/Thick Driver'

Click on 'Configure' and locate the Oracle Client. Select Client Type as 'Instant Client'.

Then click on 'Test' button and make sure you get the success message as given below.

Re-start the SQL Developer, then on the corresponding Connections, right click and make sure that the 'Reset Password' option is enabled.

And you have it!

This is really really handy. Wooh!

General Availability Of PeopleTools 8.54

PeopleTools is proud to announce the release of PeopleTools 8.54.  This is a landmark release for PeopleSoft, one that offers remarkable advances to our applications and our customers.  We are particularly excited about the new PeopleSoft Fluid User Experience.  With this, our applications will offer a UI that is simple and intuitive, yet highly productive and that can be used on different devices from laptops to tablets and smart phones...

Read more from: https://blogs.oracle.com/peopletools/entry/oracle_peoplesoft_is_pleased_to