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!

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
529 views