Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to call a SQL function from an XSL expression

user11177735Oct 18 2012
Hi

In R12, in Payroll Deposit adivce/Check writer, We need to sort the earnings tag <AC_Earnings> in to two different categories as regular and other earnings. In the DB and form level of element defintiion we have a DFF which differentiates between the two kinds of earnings. But the seeded XML that is gerneated by the check writer does not have this field.
The seeded template displays all the earnings in one column. How can we achieve this in the template without modifying the seeded XML.

The one approach i have is to write a function and based on the return value sort the data. For this I need to know :

1) How to call a SQL function from an XSL expression that is allowed in BI template.

If anyone ahs faced similar requirements please share your approach.

Thanks
Srimathi

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 15 2012
Added on Oct 18 2012
0 comments
109 views