Dear Community,
Maybe any of you have faced this issue in the past.
We are on Apps10 UPD21
We try to schedule a few QRs, but we struggling with a strange phenomenon.
We have e.g. the following QR, which gives back some results if I run it in IEE:
But when I try to export the report to Excel, that looks “empty”:
In the report we have some filter parameters:
The “speciality” is if we leave the From_date and To_date parameters empty, the report filter automatically to the last period:
AND hl.time_stamp BETWEEN
NVL(TO_DATE('&From_date', 'dd/mm/yyyy'),
TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')) AND
NVL(TO_DATE('&To_date', 'dd/mm/yyyy'),
TRUNC(SYSDATE, 'MM') - INTERVAL '1' SECOND)
I modified the query and played around, and tried to eliminate not necessary things from the sql, so when I ran in IFS:
Then when I exported to Excel:
I tried many things (e.g.: change the LIKE, replace the NVL date logic etc.) but nothing helped, and I can’t figure it out what cause the issue.
this is the latest and simplified query:
SELECT
TO_CHAR(hl.log_id),
hl.lu_name,
hl.time_stamp,
hl.history_type,
ico.company,
hla.column_name
FROM HISTORY_LOG_ADMIN hl,
HISTORY_LOG_ATTRIBUTE hla,
IDENTITY_INVOICE_INFO ico
WHERE hl.module = 'ENTERP'
AND hl.log_id = hla.log_id
AND SUBSTR(keys, INSTR(keys, '^', 1, 1) - INSTR(keys, '^') + 13, INSTR(keys, '^') - 13) LIKE ico.customer_id
AND hl.table_name LIKE 'CUSTOMER_INFO_TAB'
AND ico.company LIKE UPPER(NVL('&Company%', '%'))
AND TRUNC(hl.time_stamp) >= TO_DATE(NVL('&From_date', TO_CHAR(TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM'), 'DD/MM/YYYY')), 'DD/MM/YYYY')
AND TRUNC(hl.time_stamp) <= TO_DATE(NVL('&To_date', TO_CHAR(TRUNC(SYSDATE, 'MM') - INTERVAL '1' SECOND, 'DD/MM/YYYY')), 'DD/MM/YYYY')
If you have any idea that would be great!
Thank you so much in advance for any input and idea.
Kind regards,
Balazs