Hi All,
I'm trying to generate XML for the Invoice data between :p_Start_Date and :p_End_Date
The Invoice_date column date format is in MM/DD/YYYY format .
SQL Query Condition:
-----------------------------------
AND A.INVOICE_DATE BETWEEN TO_DATE(:p_Start_Date,'MM/DD/YYYY') AND TO_DATE(:p_End_Date,'MM/DD/YYYY')
I have registered the program and while providing Input Parameters in below format:
Encountering below error.Please suggest how to resolve this error
XDO Data Engine Version No: 5.6.3
Resp: 20639
Org ID : 0
Request ID: 4794978
All Parameters: p_Start_Date="2016/01/01 00:00:00":p_End_Date="2016/01/10 00:00:00"
Data Template Code: CPD_AP_PO_INV_REPORT
Data Template Application Short Name: SQLAP
Debug Flag: N
{p_Start_Date=2016/01/01 00:00:00, p_End_Date=2016/01/10 00:00:00}
Calling XDO Data Engine...
--SQLException
java.sql.SQLDataException: ORA-01843: not a valid month