By using Data Template we can create report in oracle apps without report builder

<?xml version = '1.0' encoding = 'UTF-8'?>
<dataTemplate name="XXEMPDET" description="Employee Details" version="1.0">
<parameters></parameters>
<lexicals></lexicals>
<dataQuery>
<sqlStatement name="Q1">
<![CDATA[select employee_number, full_name, 'eyaray@etihad.ae' email_address, pp.name
from per_people_x ppx,
per_assignments_x pax,
per_positions pp
where pax.person_id = ppx.person_id
and pax.position_id = pp.position_id
and ppx.current_employee_flag = 'Y'
and rownum < 5 ]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_EMP" dataType="VARCHAR2" source="Q1">
<element name="EmpNo" dataType="VARCHAR2" value="employee_number"/>
<element name="Employee_Name" dataType="VARCHAR2" value="full_name"/>
<element name="Email" dataType="VARCHAR2" value="email_address"/>
<element name="Position" dataType="VARCHAR2" value="name"/>
</group>
</dataStructure>
</dataTemplate>