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>
