Summary

End Tag Does not Match Start Tag

Content

Hi All,

Below is the xml I'm using  but encountering .Please Suggest if anything needs to be changed

Error :

End tag 'G_CPD_INVOICE_DETAILS_REPORT'
does not match the start tag 'PO_HEADER_STATUS'. Error processing resource
'http://p...

</G_CPD_INVOICE_DETAILS_REPORT> --^

<?xml version="1.0" encoding="UTF-8" ?>

<!--========================================================================= --><!-- CPD AP INVOICE DETAILS--><!-- Chicago Park District --><!--========================================================================= --><!-- Name : CPD_AP_PO_INV_REPORT --><!-- Description : AP Invoice Payment Details Report--><!-- --><!-- --><!-- --><!-- --><!--Change Record: --><!--=============== --><!--Version Date Author Remarks --><!--======= ========== =============== ======================= --><!--1.0 03-MAY-2017 Harish Ventrapragada Initial version --><!--==========================================================================--><dataTemplate version="1.0" description="CPD_AP_INVOICE_DETAILS" name="CPD_INVOICE_DETAILS_REPORT"><properties><property name="scalable_mode" value="on"/></properties><properties><property name="db_fetch_size" value="20"/></properties><properties>
<property name="include_parameters" value="false" /> 
</properties><parameters>
<parameter name="p_Start_Date" dataType="VARCHAR2(11)"/>
<parameter name="p_End_Date"   dataType="VARCHAR2(11)"/>
</parameters><dataQuery><sqlStatement name="CPD_AP_PO_INV_REP"><![CDATA[SELECT  E.SEGMENT1  VENDOR_NUMBER
    ,E.VENDOR_NAME  VENDOR_NAME
    ,TO_CHAR(TRUNC(D.CREATION_DATE)) PO_DATE
    ,decode(d.approved_flag, 'Y', 'Approved') PO_STATUS
    ,D.SEGMENT1  PO_NUMBER
    ,M.RELEASE_NUM  RELEASE_NUM
    ,J.FULL_NAME BUYER
    ,POAH.FULL_NAME APPROVER
    ,D.TYPE_LOOKUP_CODE PO_TYPE
    ,L.segment1 FUND
    ,L.segment2  COST_CENTER
    ,L.segment3 LOCATION
    ,L.segment4  ACCOUNT
    ,L.segment5 PROGRAM
    ,L.segment6  CATEGORIES
    ,L.segment7  SESION
    ,L.segment8  PROJECT
     ,A.INVOICE_NUM  INVOICE_NUMBER
    ,TO_CHAR(TRUNC(A.INVOICE_DATE))  INVOICE_DATE
     ,decode(a.payment_status_flag, 'Y', 'Fully Paid','P','Partially Paid','N' ,'Not Paid') INVOICE_PAYMENT_STATUS
    ,K.LINE_NUMBER INVOICE_LINE_NUMBER
    ,K.DESCRIPTION  LINE_DESCRIPTION
    ,K.AMOUNT INVOICE_LINE_AMOUNT
    ,decode(b.match_status_flag, 'A', 'Approved') INVOICE_APPROVED
    ,I.CHECK_NUMBER CHECK_NUMBER
     ,I.PAYMENT_METHOD_CODE PAYMENT_METHOD
    ,TO_CHAR(TRUNC(I.CHECK_DATE)) PAYMENT_DATE
    ,D.CLOSED_CODE PO_HEADER_STATUS
FROM APPS.AP_INVOICES_ALL A
    ,APPS.AP_INVOICE_DISTRIBUTIONS_ALL B
    ,APPS.PO_DISTRIBUTIONS_ALL C
    ,APPS.PO_HEADERS_ALL D
    ,APPS.PO_VENDORS E
    ,APPS.AP_INVOICE_PAYMENTS_ALL H
    ,APPS.AP_CHECKS_ALL I
    ,APPS.PER_ALL_PEOPLE_F J
    ,APPS.AP_INVOICE_LINES_ALL K
    ,APPS.GL_CODE_COMBINATIONS L
    ,APPS.PO_RELEASES_ALL M
    ,(
        SELECT papf.full_name
            ,pah.object_id
        FROM po.po_action_history pah
            ,po.po_headers_all D
            ,applsys.fnd_user fu
            ,hr.per_all_people_f papf
        WHERE object_id = D.po_header_id
            AND pah.employee_id = fu.employee_id
            AND fu.employee_id = papf.person_id
            AND SYSDATE BETWEEN papf.effective_start_date
                AND papf.effective_end_date
            AND pah.object_type_code = 'RELEASE'
            AND pah.action_code = 'APPROVE'
              AND pah.sequence_num = (
                SELECT MAX(sequence_num)
                FROM po.po_action_history pah1
                WHERE pah1.object_id = pah.object_id
                    AND pah1.object_type_code = 'RELEASE'
                    AND pah1.action_code = 'APPROVE'
                )
        ) poah
WHERE A.INVOICE_ID = B.INVOICE_ID
    AND B.PO_DISTRIBUTION_ID = C.PO_DISTRIBUTION_ID(+)
    AND C.PO_HEADER_ID = D.PO_HEADER_ID(+)
    AND E.VENDOR_ID= D.VENDOR_ID
    AND A.INVOICE_ID = H.INVOICE_ID
    AND A.INVOICE_ID = K.INVOICE_ID
    AND H.CHECK_ID = I.CHECK_ID
    AND L.CODE_COMBINATION_ID = C.CODE_COMBINATION_ID
    AND D.AGENT_ID = J.PERSON_ID
    AND D.PO_HEADER_ID = M.PO_HEADER_ID
    AND poah.OBJECT_ID = M.PO_RELEASE_ID
    AND C.PO_HEADER_ID IS NOT NULL
    AND A.PAYMENT_STATUS_FLAG in ( 'Y' ,'P','N')
    AND D.TYPE_LOOKUP_CODE = 'BLANKET'
AND A.INVOICE_DATE BETWEEN TO_DATE(:p_Start_Date,'YYYY/MM/DD HH24:MI:SS') AND TO_DATE(:p_End_Date,'YYYY/MM/DD HH24:MI:SS')
UNION
SELECT    E.SEGMENT1  VENDOR_NUMBER
    ,E.VENDOR_NAME  VENDOR_NAME
    ,TO_CHAR(TRUNC(D.CREATION_DATE)) PO_DATE
     ,decode(d.approved_flag, 'Y', 'Approved') PO_STATUS
    ,D.SEGMENT1  PO_NUMBER
    ,NULL  RELEASE_NUM
    ,J.FULL_NAME BUYER
    ,POAH.FULL_NAME APPROVER
    ,D.TYPE_LOOKUP_CODE PO_TYPE
    ,L.segment1 FUND
    ,L.segment2  COST_CENTER
    ,L.segment3 LOCATION
    ,L.segment4  ACCOUNT
    ,L.segment5 PROGRAM
    ,L.segment6  CATEGORIES
    ,L.segment7  SESION
    ,L.segment8  PROJECT
     ,A.INVOICE_NUM  INVOICE_NUMBER
    ,TO_CHAR(TRUNC(A.INVOICE_DATE))  INVOICE_DATE
     ,decode(a.payment_status_flag, 'Y', 'Fully Paid','P','Partially Paid','N' ,'Not Paid') INVOICE_PAYMENT_STATUS
    ,K.LINE_NUMBER INVOICE_LINE_NUMBER
    ,K.DESCRIPTION  LINE_DESCRIPTION
    ,K.AMOUNT INVOICE_LINE_AMOUNT
    ,decode(b.match_status_flag, 'A', 'Approved') INVOICE_APPROVED
    ,I.CHECK_NUMBER CHECK_NUMBER
     ,I.PAYMENT_METHOD_CODE PAYMENT_METHOD
    ,TO_CHAR(TRUNC(I.CHECK_DATE)) PAYMENT_DATE
    ,D.CLOSED_CODE PO_HEADER_STATUS
FROM AP_INVOICES_ALL A 
,AP_INVOICE_LINES_ALL K
,AP_INVOICE_DISTRIBUTIONS_ALL B
,APPS.AP_INVOICE_PAYMENTS_ALL H 
,APPS.AP_CHECKS_ALL I
,APPS.PO_DISTRIBUTIONS_ALL C
,APPS.PO_HEADERS_ALL D
,APPS.PO_VENDORS E
,APPS.GL_CODE_COMBINATIONS L
,APPS.PER_ALL_PEOPLE_F J
 ,(
        SELECT papf.full_name
            ,pah.object_id
        FROM po.po_action_history pah
            ,po.po_headers_all D
            ,applsys.fnd_user fu
            ,hr.per_all_people_f papf
        WHERE object_id = D.po_header_id
            AND pah.employee_id = fu.employee_id
            AND fu.employee_id = papf.person_id
            AND SYSDATE BETWEEN papf.effective_start_date
                AND papf.effective_end_date
            AND pah.object_type_code = 'PO'
            AND pah.action_code = 'APPROVE'
                  AND pah.sequence_num = (
                SELECT MAX(sequence_num)
                FROM po.po_action_history pah1
                WHERE pah1.object_id = pah.object_id
                    AND pah1.object_type_code = 'PO'
                    AND pah1.action_code = 'APPROVE'
                )
     ) poah
WHERE A.INVOICE_ID=K.INVOICE_ID
AND    K.INVOICE_ID=B.INVOICE_ID
AND    A.INVOICE_ID=H.INVOICE_ID
AND    H.CHECK_ID=I.CHECK_ID
AND   D.PO_HEADER_ID=C.PO_HEADER_ID
AND   C.PO_DISTRIBUTION_ID=B.PO_DISTRIBUTION_ID
AND   D.VENDOR_ID=E.VENDOR_ID
AND C.CODE_COMBINATION_ID=L.CODE_COMBINATION_ID
AND A.PAYMENT_STATUS_FLAG in ( 'Y' ,'P','N')
AND D.AGENT_ID = J.PERSON_ID
AND poah.OBJECT_ID = D.PO_HEADER_ID
AND D.TYPE_LOOKUP_CODE!='BLANKET'
AND A.INVOICE_DATE BETWEEN TO_DATE(:p_Start_Date,'YYYY/MM/DD HH24:MI:SS') AND TO_DATE(:p_End_Date,'YYYY/MM/DD HH24:MI:SS')
order by 1,2,3,4,5,6,7,8,9,18,19,20,21,22,23,24,25,26,27]]></sqlStatement></dataQuery><dataStructure><group name="g_CPD_INVOICE_DETAILS_REPORT" source="CPD_AP_PO_INV_REP"><element name="VENDOR_NUMBER" value="VENDOR_NUMBER"/><element name="VENDOR_NAME" value="VENDOR_NAME"/><element name="PO_DATE" value="PO_DATE"/><element name="PO_STATUS" value="PO_STATUS"/><element name="PO_NUMBER" value="PO_NUMBER"/><element name="RELEASE_NUMBER" value="RELEASE_NUMBER"/><element name="PO_TYPE" value="PO_TYPE" /><element name="BUYER" value="BUYER"/><element name="APPROVER" value="APPROVER"/><element name="FUND" value="FUND"/><element name="COST_CENTER" value="COST_CENTER"/><element name="LOCATION" value="LOCATION" /><element name="ACCOUNT" value="ACCOUNT" /><element name="PROGRAM" value="PROGRAM"/><element name="CATEGORIES" value="CATEGORIES"/><element name="SESION" value="SESION"/><element name="PROJECT" value="PROJECT"/><element name="INVOICE_NUMBER" value="INVOICE_NUMBER"/><element name="INVOICE_DATE" value="INVOICE_DATE"/><element name="INVOICE_PAYMENT_STATUS" value="INVOICE_PAYMENT_STATUS"/><element name="INVOICE_LINE_NUMBER" value="INVOICE_LINE_NUMBER"/><element name="LINE_DESCRIPTION" value="LINE_DESCRIPTION"/><element name="INVOICE_LINE_AMOUNT" value="INVOICE_LINE_AMOUNT"/><element name="INVOICE_APPROVED" value="INVOICE_APPROVED"/><element name="CHECK_NUMBER" value="CHECK_NUMBER"/><element name="PAYMENT_METHOD" value="PAYMENT_METHOD"/><element name="PAYMENT_DATE" value="PAYMENT_DATE"/><element name="PO_HEADER_STATUS" value="PO_HEADER_STATUS"/></group></dataStructure></dataTemplate>