Oracle BI PUblisher

Для группировки и фетча вне таблицы необходимо

<?for-each-group:ROW;./DEPARTMENT_NAME?><?sort:DEPARTMENT_NAME;'ascending';data-type='text'?>
<?end for-each-group?>

Для фетча внутри таблицы
<?for-each:current-group()?><?sort:SM_SAL;'ascending';data-type='text'?>
<?end for-each?>
Пример 
 <?for-each-group:ROW;./DEPARTMENT_NAME?><?sort:DEPARTMENT_NAME;'ascending';data-type='text'?>
<?DEPARTMENT_NAME?>
<?for-each:current-group()?><?sort:SM_SAL;'ascending';data-type='text'?>
<?FIRST_NAME?>
<?LAST_NAME?>
<?SALARY?>
<?SM_SAL?>
<?end for-each?>
<?end for-each-group?>