Skip to Main Content

Cloud Platform

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.

Sorting in not working in Etext Template

User_8KHWFOct 28 2019

Hi, We have HCM extract which feeds data to e-text template. I have a requirement to sort the data by person number/Payroll Relationship Number. In e-text template, I am using the below criteria to do the sorting but it's not working. I did not see any option to sort the data in HCM Advanced filtration criteria as well. Please suggest or share if you have any sample e-test template with Sort function.

<LEVEL>

Employee_Details

<SORT ASCENDING>

To_number(Person_Number)

<POSITION>

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

<NEW RECORD>

EMPLPIM _Details

Thank you

Comments
Post Details
Added on Oct 28 2019
1 comment
522 views