Good morning especially to reports developer expert I have this query, this work well in sql developer and in the reports builder when I created the report but when we run it in oracle apps there is no output.. I'm thinking the problem might be in the date format of the parameter but couldn't find the cause, Please help..thank you in advance.
WHERE VOID_DATE between NVL(TO_DATE(:FROMDATE,'yyyy/mm/dd HH24:MI:SS'),SYSDATE - 9999)
AND NVL(TO_DATE(:TODATE, 'yyyy/mm/dd HH24:MI:SS'),SYSDATE - 9999)
Edited by: 944754 on Jul 5, 2012 11:05 PM
Pl post details of OS, database and EBS versions.
When executing in APPS, you need to set context before querying ".._ALL" tables
How to set the Organization Context in R12? [ID 437119.1]
Oracle Applications Multiple Organizations Access Control for Custom Code [ID 420787.1]
Setting the Applications Context (FND_GLOBAL.APPS_INITIALIZE) [ID 209185.1]