HCM / FSCM 9.2 RVP

PeopleSoft Human Capital Management (HCM) and Financials and Supply Chain Management (FSCM) are world-class solutions for organizations of every size, region, and industry. Oracle’s planned product roadmap for PeopleSoft applications is to deliver valuable, needed features for all of an organization’s constituents along three design principles — Simplicity, Productivity, and Lowered Total Cost of Ownership — as well as new application functionality as prioritized by our customers.

The upcoming 9.2 releases of PeopleSoft Human Capital Management, Enterprise Learning Management, Asset Lifecycle Management, Enterprise Service Automation, Financial Management Solution, Supply Chain Management, and Supplier Relationship Management focus on these themes of Simplicity, Productivity, and Lower Total Cost of Ownership while also delivering robust new functionality to help your organization succeed.

The recently published PeopleSoft HCM and ELM 9.2 Release Value Proposition and PeopleSoft ALM, ESA, FMS, SCM, and SRM 9.2 Release Value Proposition provide overviews of the new features and enhancements planned for these applications for Release 9.2. These documents offer customers a road map intended to help them assess the business benefits of upgrading to the 9.2 release while also helping them plan their IT projects and investments. (Links are to My Oracle Support pages, available to customers and partners.)

Oracle continues to deliver enterprise-wide features that enhance our customer ownership experience and helps them run their businesses more efficiently and profitably. With the HCM and FSCM 9.2 releases, we continue to abide by this firm commitment we’ve made to our customers.

Re-posting from Oracle Blog...

9.2 Release Notes

Last week at Oracle Open World we announced the following changes to PeopleSoft support:

• The PeopleSoft 9.0 Extended Support window has been lengthened to June 2015. (Includes PeopleSoft HCM, FSCM, CRM)
• All Extended Support fees for PeopleSoft 9.0 have been waived through the June 2015 date.
• All Extended Support fees for PeopleSoft 9.1 have been waived through their 2017 dates.

These changes provided customers with more flexibility to plan for the adoption of PeopleSoft 9.2. You can start your upgrade planning today, as PeopleSoft 9.2 Release Notes provide extensive documentation on 9.2 features. Access the Prerelease Notes on My Oracle Support to start planning your upgrade.

PeopleSoft HCM 9.2 Prerelease Notes: Doc ID 1494911.1

PeopleSoft FSCM 9.2 Prerelease Notes: Doc ID 1495347.1

AP's that should not be modified

Thanks Ramesh Balakrishnan - for sharing this snippet.

Process Definition	Process Name	Process Type
Accrue Receipts	RECVACCR	APP ENGINE
Ben Admin	PSPBARUN	COBOL SQL
Budget Checking Module	FSPBBCHK	COBOL SQL
Calc Deductions	PSPDCRUN	COBOL SQL
Calc Pay	PSPPYRUN	COBOL SQL
COBRA Admin	PSPCOBRA	COBOL SQL
Confirm Deductions	PSPDCCNF	COBOL SQL
Confirm Pay	PSPCNFRM	COBOL SQL
Delete Balances	PSPDLBAL	COBOL SQL
EDI Manager	ECIN001	SQR REPORT
Final Check Pay	PSPFCBLD	COBOL SQL
Journal Generator	FSPGJGEN	COBOL SQL
OM Billing Interface	OMBILL	SQR REPORT
Payment Predictor	ARPREDCT	APP ENGINE
Paysheet	PSPPYBLD	COBOL SQL
PO Build	POBUILD	APP ENGINE
PO Edit	POEDIT	APP ENGINE
PO Post	POPPENCM	COBOL SQL
PO Reconcile	PORECON	APP ENGINE
PO Reconciliation	PORECON	APP ENGINE
PO Rollover	POCHNG	APP ENGINE
Receivables Update	ARUPDATE	APP ENGINE
Requisition Edit	REQEDIT	APP ENGINE
Requisition Post	REQPOST	APP ENGINE
Requisition Reconciliation	REQRCON	APP ENGINE
Retro Deductions	PSPRDEXT	COBOL SQL
Retro Pay	PSPRPEXT	COBOL SQL
Reversal Process	PSPPYREV	COBOL SQL
Transaction Loader	FSPLOADR	COBOL SQL
Treasury Acct App Engine	TRACCTG	APP ENGINE
Unconfirm Deductions	PSPDCUNC	COBOL SQL
Unconfirm Pay	PSPUNCNF	COBOL SQL

No Changes can be made to any annual and quarterly Tax Reporting Processes/Panels

in HR.

Log XMLP Reports

Create a file named xdodebug.cfg and place it under [PS_HOME]\JRE\Lib] folder.The file should include the following line:

Under Windows 

LogLevel=STATEMENT

LogDir=c:\temp

Under Unix

The file Should look like this (point to an appropriate temporary directory under the Unix box) 

LogLevel=STATEMENT

LogDir=/ds3/ps/dssgrp/t849xr21/appserv/ 

Remove xdodebug.cfg when finished replicating the issue.

The logging is specifically useful for troubleshooting the Template(RTF/PDF) or Data File(XML file) specific issues. The generated XML file is the actual data file which is run from the MS Word Design Helper Preview mode to narrow down the issue.

Contributed by: Rajesh Prasad

hr828473_01.dms Issue

If you have ever encountered this issue while upgrade,do not change the field property to make it work :)
The solution is available with Oracle Support.
Importing HCM_EO_TXN 
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_HCM_EO_TXN"."HR_PTCS_SERVICEID") 
Failed SQL stmt:INSERT INTO PS_HCM_EO_TXN (TRANSACTION_NAME, EOAWPRCS_ID, DELEGATION_APPR, DELEGATION_INIT) VALUES (:1, :2, :3, :4) (200,0)
SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_HCM_EO_TXN"."HR_PTCS_SERVICEID") 
INSERT INTO PS_HCM_EO_TXN (TRANSACTION_NAME, EOAWPRCS_ID, DELEGATION_APPR, DELEGATION_INIT) VALUES (:1, :2, :3, :4)
SQL Error. Error Position: 0 Return: 0 - Error: SQL unable to commit transaction for HCM_EO_TXN 
Ended: Wed Aug 01 06:49:00 2012
Unsuccessful completion
'ORA-01400: cannot insert NULL into' - issue is not one or two in Oracle Support. There are a lot out there reported. For majority of this issue has a patch to resolve the bug.

Efficient Reporting

Join our Directors -John Gilligan & Bruce W. Moore - to have a glance on the new products from Ciber. 

Streamline, Centralize and Simplify Reporting:

https://www.facebook.com/events/469678893051948/

Register for the HEUG event:
https://www2.gotomeeting.com/register/931838538

Blog is on Google Currents now!

I tried Google Currents few days back on Samsung Galaxy tab and found to be a fantastic app to live with. A direct competitor for Flipboard (which is also my favorite).

The feature which made me love Google Currents is that you can publish your content with ease on it and people can subscribe to it. And the interface to set up the publication - very straight forward & simple.

That's the reason I tried publishing The PeopleSoft Blog on Google Currents and its live now!

You can get the link under Science & Technology division of currents. And try it out. it is really simple to navigate and read through.

Android Smart Phones

iPad

iPhone

Tablet

PT 8.52 - Decoupled PS_HOMES

You might have already noted this point. Thought of sharing with the people who might have missed it.

So the need is a Calendar View!

The requirement was to have a calendar view to show the enrolled classes details for a student. And what I had was a narrow right side column to fit it. As and when the student enrolls to various classes he should be able to view the details in a calendar view and I was like - oops!

The requirement came up with a tip - the calendar view in the Student Center. And when I opened the code behind it...oh no and I decided not to go with that approach. First I cannot fit that in the area available in the application, secondly recreating the code was insane. But the final decision was this.

Was trying for the past few days for a way to get this requirement done and finally it is done! Thank god!

I will give you a small example:

The below is the screen capture of the Student Enrollment database.

Conside the student 0136 is logged in. The data is pulled up from the STDNT_ENRL table as given above.

A couple of assumptions here: 

ENRL_ADD_DT is the Class Date

LAST_UPD_TM_STMP is the Class Date and Time

Student sees the calender in the form below:

Now from the database we know that the Class Dates are as follows:

06-JUNE-2012

07-JUNE-2012

08-JUNE-2012

16-JUNE-2012

So in the above screenshot we are in the month of August 2012. So two clicks back...

Now we have his details on the calendar view. Just hover with the mouse on the dates to view the details.

PeopleSoft Feed Publishing Framework

Has anyone tried out this feature? am stuck in between.

Update: Could configure it end to end and integrate with mobile site :)

New Project

It is been a while since I have written a post. Got stuck between a project which can make a difference. I am now able to build my dreams brick by brick. The execution freedom is what I am going through now. More information on this is coming soon. Till then have  a fantastic day!

PeopleSoft Documents Technology

Just started reading to understand what exactly this is :)

http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tdoc/chapter.htm?File=tdoc/htm/tdoc01.htm

Taming the COBOL Issue

Never worked before on COBOL in PeopleSoft and that was the reason we were stuck when the COBOL bite us when the instance was build. In all good ways that was a wonderful learning.

The COBOL need to be compiled before you can use the processes which executes these COBOL's. For this you need a compiler. You can download MicroSoft Netexpress verisons from Oracle e-Delivery. And you need to check the certified version of the compiler which depends on the OS and the PeopleTools version.

If the COBOLs are not compiled you might get the 'Child program could not start...' error.

The compiler comes in two shapes. With/without license. You can use the trial version of the compiler and it will last only for 30 days and can compile only upto 2000 lines.

What is meant by compiling?

The delivered COBOL files can be found under PS_HOME\src\cbl\base folder. You can see .cbl/.cfg/.dms files in it. Compilation steps/commands you can Google and find it out. It is all over the place.

Once you compile we have to put the compiled .exe/.gnt/.ini files in the CBLBINA/CBLBINU (which depends on the unicode/non-unicode installation).

with the above step the COBOL process should be live and kicking. However you might confront this error - 'Child program XXX aborted'

Why this error is due to the absence of some DLL files from the compiler base folder. They are these: CBLINTS.DLL,CBLRTSS.DLL,CBLVIOS.DLL,COB32API.DLL

Copy these files from the compiler base folder and paste it in the  CBLBINA/CBLBINU along with the executables. Then it should work.

The above steps is for the non-unicode database.

For non-unicode database you need to compile the COBOLS to unicode compatible format using the conversion .bat file Oracle provides.