Blogs | Hexaware

Blogs


Latest Post
In this blog, I will answer two questions. How to trace AE? There are a few ways to trace an AE program. You can enable the trace using some of the below methods: In the process scheduler configuration file psprcs.cfg You can enable the trace in the“Process Definition”. Grab the Oracle session information and generate SQL Trace It is not advised to enable the trace using psprcs.cfg because it will enable trace for ALL AE programs using that scheduler. However, this might be the best choice in an environment where you want to trace multiple AE programs or you do…
Posted by Nitin Pai
Comments (0)
December 17th, 2007
In the last 2 posts, we looked at the way Agile Framework can be implemented to manage BI systems. Diagram below is intended to reiterate the process of Agile Framework implementation with its Planning & Execution phases. Having taking care of managing the evolution of enterprise BI systems, the next important aspect of implementation is "How to measure the evolution"? This brings us to the next important enabler – "Calibrating Business Intelligence systems" What is Calibration? Calibration = “Measurement” - Can be defined as the alignment of process to certain calibration factors so that the health of the process can…
Posted by Karthikeyan Sankaran
Comments (0)
December 10th, 2007
As everyone knows, PeopleSoft itself provides a lot of MSS transaction. For example Transfer Employee Job Change Promote Employee Terminate Employee Like that, say for example, if we are getting new MSS related requirements for Paygroup Change, How will we accomplish? Here is an insight!!! Broadly saying, we should have 3 types of components that needs to be built to accomplish any MSS transaction Transaction Level Components Approval related Components (If Required) Viewing Transaction/Approval Workflow Status related Components Each of these components are in turn driven by 2 types of Component Pages, one for Launching Manager’s Direct Reports and the…
Posted by Kannappan Krishnan
Comments (2)
December 8th, 2007
In my previous post, I established the fact that Agile Framework can be used to manage complexity in enterprise wide Business Intelligence systems. Two phases to the Agile framework implementation are: Planning Phase Execution Phase Agile Framework – Planning Phase Planning is typically done at the end of a particular year for the subsequent year, once the business plans & budgets are finalized. Assumptions / Pre-requisites Enterprise BI infrastructure is already in place in the organization Technology Architecture (BI Tools/Technologies) and Process Architecture (Standards, Policies, Procedures) are already defined. Start --> End Activities Deliverables Create & Prioritize the Stories Conduct…
Posted by Karthikeyan Sankaran
Comments (0)
December 3rd, 2007
As part of the Business Intelligence Utopia series, I am going to focus on the implementation enablers in the next few posts. The first implementation enabler is: Agile Framework for Managing Business Intelligence systems BI systems are complex to manage due to the following reasons: Keeps Evolving over time – Enterprise DW can never be completely built BI drives business decisions – Needs “Total Alignment” with corporate vision Power of BI applications increases exponentially as the number of information consumers increases Data Warehouses need to be measured & calibrated against pre-set goals Development & Support has to be managed concurrently…
Posted by Karthikeyan Sankaran
Comments (1)
November 29th, 2007
One other challenge in a data integration project as it is with any other IT system is to build a data integration environment that is agile and flexible enough to accommodate the system changes related to business rules. The benefit of building a dynamic system is that the code changes are less frequently done or completely avoided in many cases, so it is very much a de-facto process to look for design opportunities to build a DI system that is dynamic. A dynamic DI system accommodates variation in the incoming data and is able to respond without system failures or…
Posted by Muneeswara C Pandian
Comments (0)
November 28th, 2007
One of the Key for Manager Self Service transactions is setting up of Direct Reports for Manager. For every MSS Transaction, The First page is always Direct Reports Listing Page. Generally this list is determined by Organizational Hierarchy Setup. (For Eg: Departmental Hierarchy or Supervisor driven Hierarchy). If we correlate with PeopleSoft Terminology, I would say this will come under any of these access types By Supervisor Id By Reports To Position By Department Manager Id By Department Security Tree By Part Position Management Supervisor By Part Position Management Department Manager ID By Group Id If we take access type“By…
Posted by Kannappan Krishnan
Comments (4)
November 26th, 2007
SAP Business Process Outsourcing’ might sound new to many but it is one of the popular service in SAP’s solutions profile. SAP is not a BPO company but SAP solution empowers the companies that provide BPO services. SAP Business Suite, the world's most comprehensive family of adaptive business applications built on three decades of experience and best practices, is already the choice of many BPO providers and their customers. Customers benefit from solutions aligned with BPO, such as SAP ERP HCM and SAP SRM, that support human capital management, procurement, and finance and administration. SAP also covers industry-specific processes in…
Posted by Inigo Angelus
Comments (1)
November 24th, 2007
Peoplesoft provides an online page to delete OPRID. However, this can become cumbersome if you need to purge or delete 10+ OPRID’s as part of your cleanup exercise. I have created the below PL/SQL script which basically mimics what the online purge process executes. DECLARE CURSOR C1 IS SELECT decode(A.SQLTABLENAME,' ','PS_'||A.RECNAME,A.SQLTABLENAME) RECNAME FROM PSRECDEFN A WHERE RECNAME IN (SELECT RECNAME FROM PS_TBLSELECTION_VW) AND RECNAME != 'PSOPRDEFN' ORDER BY 1; CURSOR C2 IS SELECT decode(B.SQLTABLENAME,' ','PS_'||B.RECNAME,B.SQLTABLENAME) RECNAME FROM PSRECDEFN B WHERE RECNAME IN (SELECT RECNAME FROM PS_ROLEUSR_TBLS_VW) AND RECNAME != 'PSOPRDEFN'
Posted by Nitin Pai
Comments (1)
November 23rd, 2007
Login to the url http://helix.hexaware.com/Innovation/ and navigate to the menu HRIT>SOD>Thursday forums to view the presentation as well as the video of Princeton Softec's Optim and Human Concepts Workforce modelling and Intelligence tool - Orgplus.
Posted by Pon ArunKumar Ramalingam
Comments (1)
November 22nd, 2007
Contact Us