Wednesday, June 25, 2008

XML Publisher - How to do sorting on the XML dataset

How to do sorting in XMLP
---------------------------
Sorting can be done by inserting the tag within the repeating group.

Multiple sorts is possible by using multiple sort tags


There is no end tag required for this XMLP directive.

Ascending or descending order sorting is also possible using the following syntax
order='descending'?>

Data type sorting is also possible. This is especially useful if you want to do numeric sorting on an alphanumeric field. This can be done using the syntax below:
data-type='number'?>

The sort XMLP directive should immediately follow the XMLP for-each directive

E.g.

Monday, June 23, 2008

Introduction

About Myself:
I have been working as an Oracle Applications implementor and consultant for the past eight years. My career in software application development spans around 11 years.

The main focus of my experience has been in the technical aspects of Oracle Applications (integrations, conversions, workflow, forms, reports) with experience around the Supply Chain modules including ASCP, Inventory, Order Management, and Purchasing. I also have experience in Project Accounting and Manufacturing as well as Receivables and Payables modules.

Technically, I have considerable experience with SQL, PLSQL, Forms, Reports and workflow, XML Publisher and use of middleware integration technology (SOA).

My Oracle Applications consulting experience includes live implementations at Singapore,Australia, offshore support for implementations for GE Power Systems.

I am currently based in Sydney, Australia where I work as a senior technical consultant specializing in Oracle Applications consulting.

Oracle Applications R12 is the latest release of the Oracle ERP suite of products at the moment. The consulting community is excited about the soon to be released Oracle Fusion - which promises to bring together the disparate products which Oracle has acquired recently. There is also considerable excitement over SOA/BPEL middleware which Oracle is definitely touting as the backbone for Oracle Fusion.

My aim with this blog is to post my experiences using Oracle Applications which may be useful information for other Oracle Application consultants. I would also be posting my thoughts around the latest and greatest happenings in the Oracle Applications consulting space.