Receipt Register Report

XML Data Template for AR Applied Register Report in Excel format

Introduction: This XML data tempalte will help us to create a AR Applied Register Report in Excel format <?xml version=”1.0″ encoding=”UTF-8″?> <dataTemplate name=”xxxxx” Version=”1.0″> <parameters> <parameter name=”p_org” dat_idaType=”varchar2″ /> <parameter…

Read More

Oracle Apps(EBS) – AR Receipt Register Query with Bank statement Header and Line Details

Below query is useful when you required  Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELECT ACRA.RECEIPT_DATE ,( select…

Read More