Tuesday, 15 July 2014

People Tools 8.54 is available with lot more capabilities

People Tools 8.54 is now generally available for the customers. Oracle has released its landmark release of People Tools (version 8.54) on 11th July 2014.

With the release 8.54, PeopleSoft is bringing in fluid UI capabilities which could render on any devices and specifically targeted for mobile devices. There are many improvements and capabilities in reporting features available with the newest release.

For new implementation the tools 8.54 is ready to use and for upgrade customers, they may have to wait until patch 02 is available.

Apart from the major fluid UI capability, PeopleSoft has brought up improvements in the below mentioned functional areas.
Branding Framework
Activity Guides
Related Content/Actions
Introduced Global Temporary Tables
Materialized Views
Meta SQLs
PS Query
Pivot Grids
BI Publisher
Application Designer Capabilities

To see what has improved over your current version of People Tools, visit Oracles Cumulative Feature Overview site.

Watch interview with Willie Suh, Vice President of PeopleTools Development, for more information on fluid UI.

Wednesday, 18 June 2014

No PeopleSoft 9.3??? (erroneous announcement???)

Note: This announcement is missing from the My Oracle Support (MOS) link from today (19-Jun-2014). It can be an erroneous announcement or it might be under re-evaluation. Kindly ignore the article until the announcement is re-posted. However you may watch the new Delivery Model video that is added below which will provide you a overall roadmap of PeopleSoft delivery model.

Oracle has announced there won’t be a release 9.3 for certain PeopleSoft products. As per the list published by Oracle, the products include

·         HRMS Human Resources
·         HRMS Benefits and Administration
·         SCM Billing
·         HRMS Global Payroll
·         Enterprise Learning Management

No 9.3 doesn’t means Oracle is stopping investments in the PeopleSoft. Oracle describes it as shift in the delivery mechanism and emphasis that the new capabilities and features will be delivered more frequently on a continuous basis.

What it matters to PeopleSoft customers is that the mechanism will be reducing the cost in doing upgrades for the  huge releases and getting the latest features in the same release with a low cost continuous delivery model. In the announcement it is mentioned “The level of Oracle’s commitment to PeopleSoft and the investment in new features, functions, and capabilities remains the same regardless of the delivery mechanism.“.

As per my understanding, Oracle will be delivering new features and functionalities in the same release and customers in 9.2 will get the features via the normal maintenance mechanism, in which case it will be huge win for the PeopleSoft customers.

Check out the announcement here.

Watch Oracle’s PeopleSoft SVP talking about the new Delivery Model.

Tuesday, 17 June 2014

Currency Control Fields in PeopleSoft

People working in Financials or Money related modules in PeopleSoft might come across situations where they need to format the amounts to the format which is more common to the transaction currency used. This might seem to be a simple task if you are always working in same currency say USD. The amounts can be formatted using PeopleCode or other methods to display in the format which is required for your client (eg. 98.53 USD). But the situation become little complicated if you are working for a firm where the PeopleSoft is implemented globally and you have many multi currency transactions. In that case, formatting the field using PeopleCode for each and every currency using an IF or Evaluate logic will become pretty cumbersome.

PeopleSoft has provided a much simpler mechanism to do the same without writing any PeopleCode. This is called as currency control field.
Currency Control Field in PeopleSoft
Fig 1. Record Field Properties - Currency Control Field

This property can be found on the record field property. To make this work, you should be having a field which stores the currency code (usually CURRENCY_CD field) in the same record and the multicurrency option set in the application level. Once you have the field and options set, just mention the field name which contains the currency code in the Currency Control Field option in the record field property. Setting this option will automatically take care of the currency symbol, decimal digits and the scale of the number field. This helps you avoid a lot many PeopleCode. I know this is an obvious fact for those working in financials, but may be of a lot more help to the newbie’s.

As I mentioned earlier, you might need a field in the record which contains the currency code for the corresponding amount. What if you don’t have that field and you are arriving at the amount dynamically. PeopleSoft has again extended a little bit of help in this regard with a built in function called RoundCurrencyRoundCurrency function will return the amount with decimal precision formatted to the currency code passed. The syntax of the function is as shown below.
RoundCurrency(amount,currency code,effective date);

/* The below example will return the currency in AUD format effective today. */
/* Instead of hard coding the currency, you can pass dynamic values in real scenarios. */

LEDGER.AMOUNT.Value = RoundCurrency(AP_AMOUNTS_WRK.AMOUNT.Value,”AUD”,%Date);