Arrays in SQR
An Array, like a database record, is organized as rows and columns. But unlike a database record, Arrays exists only in memory and NOT in the disk. This post discusses the arrays in SQR in detail
SPARC T3 Servers: Record PeopleSoft Performance
This solution showcases an ideal environment for hosting complex multi-tier PeopleSoft Financial Applications for enterprise-scale customers.
PeopleBooks 9.1
Here’s a list of PeopleBooks 9.1 that are available online. We have also included the PeopleTools 8.50 PeopleBook so that all’s in one place.
PeopleSoft Cloud Solution from HP
Enterproses are increasingly moving towards the cloud model and HP is all set to enter the market with its ‘HP Private Cloud Solutions for Oracle Applications’.
Wipro Wins Oracle North America Titan Award
Wipro Technologies has announced that it has won an Oracle North America Titan Award for the Human Capital Management Solution category. The award was handed over at the North American Partner award ceremony held at Oracle Open World on 19th September 2010.
Oracle Fusion Launch by Q1 2011
The long wait for Fusion Apps is over … well almost; Oracle has confirmed that the Fusion apps would be available by Q1 of 2011. Fusions apps which took over 5 years in the making has as many as 100 modules that are highly configurable spread over seven product families.
CherryRoad Technologies Plans Acquisition
CherryRoad Technologies Inc., a leading integrator of enterprise software and an Oracle PartnerNetwork Platinum Partner, announced today that it has signed a definitive purchase agreement to acquire the U.S.-based Oracle PeopleSoft ERP business of MAXIMUS, Inc. (NYSE:MMS), a leading provider of government services worldwide.
Load-Lookup in SQR
It’s common to join tables within SQRs to retrieve data from normalized tables. As SQL statements consume significant computing resources, such joins may be a hindrance to performance of the SQR. Further, as the number of tables that are used in the join increases, the performance decreases.
Multiple Reports in SQR
Generating multiple reports in SQR is common these days. Writing SQRs that produce multiple reports have many advantages over the other approach of having multiple SQRs do this job. This post discusses how to generate multiple reports in SQR.
Comments in SQR
It’s always a good practice to comment your code. By doing this, your code become more understandable and thus maintainable. This holds good for all programming languages and SQR is no exception.